My Oracle Support Banner

OBIEE 12c "Failed to load" error when Idle Connection Timeout occurs (Doc ID 2506721.1)

Last updated on AUGUST 14, 2019

Applies to:

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

Symptoms


OBIEE reports are connecting to a (Netezza) datasource using (Netezza) ODBC client libraries provided by Netezza. (However, this could occur for any 3rd party ODBC).

We have enabled connection pooling and the datasource has set an Idle connection timeout of 4 hours. If OBIEE is not being used for four hours the connection is severed by Netezza as expected.

When user runs reports after this, BI tries to connect and we are facing ODBC errors. BI keeps retrying three times and throws an error.

Seems BI is not aware of connection termination. Services begin working again only after restarting the OBIEE services.

Error
=====
Failed to load (Odbc driver returned an error (SQLExec DirectW))

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.