My Oracle Support Banner

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.

Goal

Using Essbase as back-End & SSO Enabled in connection pool to run reports 

Then getting the following Error

 

Error Details
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
 

 

Solution

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
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.