Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g OBIApps RPD Update row count, NQ_SESSION.USER_LANGUAGE_CODE “No value defination”

Received Response
1
Views
1
Comments
Akshay Bhan
Akshay Bhan Rank 3 - Community Apprentice
edited Aug 13, 2024 6:03PM in Oracle Analytics Forum

The repository in OBIEE 11g is a prebuilt RPD from oracle OBIApps. The connection pool is appropriate and is working.

But while updating the row count there are few variables which pop up and as they are default so i press them "OK".

But then there is an error message which is stated as

<span class="pln" style="color: #303336;">nQSError23006</span><span class="pun" style="color: #303336;">:</span><span class="pln" style="color: #303336;">The session variable</span><span class="pun" style="color: #303336;">,</span><span class="pln" style="color: #303336;"> NQ_SESSION</span><span class="pun" style="color: #303336;">.</span><span class="pln" style="color: #303336;">USER_LANGUAGE_CODE</span><span class="pun" style="color: #303336;">,</span><span class="pln" style="color: #303336;"> has no value</span>

Then I tried to disable the session variable by disabling initialization block.

Then also the same error is popping up.

Please guide me with this error.

Answers

  • Akshay Bhan
    Akshay Bhan Rank 3 - Community Apprentice

    The Variable was being pointed from the Standard Views by oracle where in the the view was written with a where clause.

    Where Clause was as follows:

    <span class="kwd" style="color: #101094;">select</span><span class="pln" style="color: #303336;"> </span><span class="pun" style="color: #303336;">*</span><span class="pln" style="color: #303336;"> </span><span class="kwd" style="color: #101094;">from</span><span class="pln" style="color: #303336;"> xyz </span><span class="kwd" style="color: #101094;">where</span><span class="pln" style="color: #303336;"> language_code </span><span class="pun" style="color: #303336;">=</span><span class="pln" style="color: #303336;"> </span><span class="str" style="color: #7d2727;">'NQ_SESSION.USER_LANGUAGE_CODE'</span><span class="pun" style="color: #303336;">.</span>