My Oracle Support Banner

Connection Error To Essbase ([nQSError: 96002] Essbase Error: Login failed). Import Successful. Where Do You Enter The Port In The Connection Pool? (Doc ID 1444363.1)

Last updated on JANUARY 27, 2017

Applies to:

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

Symptoms

The ESSBase Sample has been imported and Business Model and Presentation layer was built.

However trying to view members in admin tool or trying to view data in analysis gives the login error below:

Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 96002] Essbase Error: Login failed. Please check if server and port are correct. If you received timeout or handshake failure, please check if you tried to connect to secure port without secure keyword or clear port with secure keyword. (HY000)

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


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