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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms