Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Session variable error with no reference to session variables in Prompt/RPD
I am receiving 3 errors in the session logs for my dashboard prompt as seen below. Despite multiple prompts using the same identical subject area and column prompts, only one dashboard is throwing these session log errors.
I have done extensive research for this error type and all solutions point to either the dashboard prompt or the RPD session variables. I went through every single variable and report analysis associated to this single dashboard but there is absolutely no reference to the "supposed" session variable in the error message below. The same goes for the other column prompts throwing the same error.
Can someone please help diagnose this issue? I have never seen anything like this.
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 23006] The session variable, NQ_SESSION.Division, has no value definition. (HY000)
Answers
-
Hello,
OBIEE show this message, because the session variable doesnt have any value.
How to do a troubleshoutting for this:
1. First ensure the CONNECTION POOL of your SESSION- INITIALIZATION BLOCKS, is correct.
Check your CONNECTION POOL:
- Datasource name
- Username
- Password
2. Ensure the result of query that you use to set up the value to your session variable is not null
3. If you use, SESSION VARIABLE - ROW WISE, check if there is any conflicts between the NAME DEFINITION of your variable.
Kind Regards,
0