OBIEE11g: Error: "[nQSError: 23006] The session variable, NQ_SESSION.ROLE_IDS, has no value definition" Session Variables not Storing Values
(Doc ID 1424947.1)
Last updated on AUGUST 29, 2018
Applies to:
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and laterBusiness Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2013***
Symptoms
While passing values to non-system session variables through HttpHeaders, the system session variable takes the value correctly but the non-system session variables are not storing any values. You have defined the variables and init blocks in the repository and also the httpHeader info in the authenticationschemas.xml file.
You get the following error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 23006] The session variable, NQ_SESSION.ROLE_IDS, has no value definition.Please have your System Administrator look at the log for more details on this error. (HY000)
SQL Issued: SELECT 0 s_0, "CompassDB"."Fact: Navigation Role Access"."ROLE_ID" s_1 FROM "CompassDB" WHERE ("Fact: Navigation Role Access"."ROLE_ID" = VALUEOF(NQ_SESSION."ROLE_IDS"))
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |