My Oracle Support Banner

After 80 or 90 Hours of Uptime, OBIEE non-OCI/TNS (ODBC, Essbase) Data Sources Fail To Connect (Doc ID 2576311.1)

Last updated on AUGUST 13, 2019

Applies to:

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

Symptoms


After 80 or 90 hours of uptime OBIEE is hanging when using any connection which is non Oracle Call Interface (e.g. |TNS).

 


The main errors observed are:


Essbase reports fail with

Essbase Error
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: Network Error [98]: Failed to bind a socket during connection to a peerLogin 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)

SQLServer Error
State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: 01000 code: 11 message: [DataDirect][ODBC SQL Server Driver][libssclient23]ConnectionOpen (()).. (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
References


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