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 [nQSError: 23006] The session variable, NQ_SESSION.V_PROG_TYPE, has no value definition

Karthi_obiee

Dear Team ,

I created a non-system session variable in the RPD V_PROG_TYPE and

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

Find more posts tagged with

OBIEE 12c

Accepted answers

Gianni Ceresa

Is this an issue? Not seeing the data while inside the RPD doesn't prevent you to model your sources and develop your RPD.

Technically, a session variable exists when there is a session. When working on the RPD there isn't a session like you would have if you login in the front end. That would explain why you get the message that the variable has no value. Set a default value for that variable and it has a chance to work even when looking at data inside the RPD.

GayathriAnand-Oracle

The right way to test this will be to deploy the rpd and use answers to display this session variable.

Does this show error? Attach screenshot of this. View Data in rpd is not the right test.

Also there should be connectivity to the database used for populating this variable from the obis server(assuming that this connection is fine since you are on onprem and probably connecting to onprem db).

All comments

Gianni Ceresa

Is this an issue? Not seeing the data while inside the RPD doesn't prevent you to model your sources and develop your RPD.

GayathriAnand-Oracle

The right way to test this will be to deploy the rpd and use answers to display this session variable.

Does this show error? Attach screenshot of this. View Data in rpd is not the right test.

Gianni Ceresa

There was a comment by @Karthi_obiee , that has been deleted somehow, saying it wasn't working also with the default value.

That's why I said "it has a chance to work": maybe it would, maybe not. But as implicitly said by my original answer, and explicitly said by Gayathri, the key point is if it does work once you deployed the RPD, if you can build analyses on that subject area.

Karthi_obiee

Here is my earlier comment…

Hi Gianni,

I did set up the default value for the session variable in rpd and even then it does not show any results.

And I tested using those default values in the opaque view replacing the session variables and I see results.

I am not sure if I am missing something as it it is showing an error as well.

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

Thanks!

Karthi_obiee

@GayathriAnand-Oracle

@Gianni Ceresa

Sure, I will deploy the rpd and display the session variable in Answers

Karthi_obiee

@GayathriAnand-Oracle

@Gianni Ceresa

I am able to see session variables in Answers.

Thank you very much for your help! :)