My Oracle Support Banner

OBIEE 11g: Error: "Blacklisted connection pool" Causes BI Server / NQServer to Crash (Doc ID 1684120.1)

Last updated on MAY 01, 2018

Applies to:

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

Symptoms

When attempting to use OBIEE, the BI Server shuts down with the following error occurring in NQServer.log file:

ERROR
-----------------------
[43143] Blacklisted connection pool: '".......l"'
[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004yN2nm6CwBP985njx0iZ0006mV00002H,0:6363] [tid: 403ee940] [nQSError: 17010] SQL statement preparation failed. [[
[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist  at OCI call OCIStmtExecute.

OR

[OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000002m0avbBDCYFLrfP8A00Vk3q00004K,0] [tid: 5657] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 28001, message: ORA-28001: the password has expired
 at OCI call OCISessionBegin.
[nQSError: 43059] Init block '...': Dynamic refresh of repository scope variables has failed.
]]
[2015-07-21T16:42:56.000+03:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000002m0avbBDCYFLrfP8A00Vk3q00004K,0] [tid: 5657] [43143] Blacklisted connection pool: '"..."'
[2015-07-21T16:42:56.000+03:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 000002m0avbBDCYFLrfP8A00Vk3q00004K,0] [tid: 5657] [43144] Skipping execution of Initialization Block: '...' due to blacklisted Connection Pool



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.