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 and later
Information in this document applies to any platform.


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)
[nqSError: 96002] Essbase error: Login fails due to invalid login credentials


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

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