Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12C [nQSError: 23006] The session variable, NQ_SESSION.V_PROG_TYPE, has no value definition
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
Best Answers
-
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.
1 -
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).
1
Answers
-
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.
0 -
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!
0 -
Sure, I will deploy the rpd and display the session variable in Answers
0 -
I am able to see session variables in Answers.
Thank you very much for your help! :)
2