My Oracle Support Banner

After Configuring the Essbase Connection Pool to Use Shared logon, Reports Fail With [nqSError: 96002] Essbase error: Login Fails Due to Invalid Login Credentials (Doc ID 2702072.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.4.190716 and later
Information in this document applies to any platform.

Symptoms

Implemented Essbase data level security in OBIEE as per document "OBIEE To Essbase Supported and Recommended Authentication Methods (Doc ID 1993210.1) and configured Essbase Connection Pool in the OBIEE RPD to use the Shared logon option,  entered the variables :USER and :PASSWORD for the username and password.

However, when try to run report in Analytics, get error:

Odbc driver ruterned an error(SQLExecDirectW)
Error Codes:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
...
[nqSError: 96002] Essbase error: Login fails due to invalid login credentials

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
References


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