nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12c, session variable error "[nqsError: 23006] The session variable, NQ_SESSION."variable nam

User_INLWQ

Hi All,

Here is the scenario.

I created a non-system session variable in the RPD and a request variable in answers dashboard prompt (both with same name, including case). In the RPD, i defined a default value as well for the session variable and the connection also established (when i hit "test" shows the variable and its default value)

In the front end, i created a simple report and one of the column is being filtered using the prompt created with request variable.

But once i run the report i see below error:

State: HY000: Code: 23006: [nQSError: 23006] The session variable, NQ_SESSION.("my variable name") has no value definition.

i did some online search and read suggestions like assign a default value for session variable in RPD (which i already did), still see this error.

Please suggest what might be causing this.

Thanks in advance.

Find more posts tagged with

Accepted answers

All comments

Karthi_obiee

I have a similar issue

INIT block:

Select

'REGULAR' AS V_PROG_TYPE

from DUAL

Default initializer 'REGULAR'

INIT block test results are good

Session variable used in Opaque View has PROG_TYPE = 'VALUEOF(NQ_SESSION.V_PROG_TYPE)'

when trying to view data in rpd physical layer throws error

- [nQSError: 23006] The session variable, NQ_SESSION.V_PROG_TYPE, has no value definition.

once I click on OK on this dialogue box I see another dialogue box says Empty result set.

OBIEE version 12.2.1.4.0