OAC : SSO option within RPD does not work for ESSBASE back-end
(Doc ID 2618268.1)
Last updated on FEBRUARY 22, 2020
Applies to:Oracle Analytics Cloud - Version 105.4.0 to 105.4.5 [Release 105.3]
Information in this document applies to any platform.
Using Essbase as back-End & SSO Enabled in connection pool to run reports
Then getting the following Error
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: NULL argument (5) passed to ESSAPI function EssLoginAs (HY000)
SQL Issued: SELECT 0 s_0, "IRC_SampleBasic_Flattened"."Year"."Months" s_1, SORTKEY("IRC_SampleBasic_Flattened"."Year"."Months") s_2 FROM "IRC_SampleBasic_Flattened" FETCH FIRST 125001 ROWS ONLY
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