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

Akshay Bhan

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.

Akshay Bhan

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>