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 126.96.36.199.0 and later
Information in this document applies to any platform.
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.
Failed to load (Odbc driver returned an error (SQLExec DirectW))
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