OBIEE 11g: In A Clustered Scale-out environment, The OBI Server Connection On The Second Node To An ODBC Data Source Falis With Error ' nQSError: 16001' On Startup (Doc ID 1958018.1)

Last updated on JUNE 24, 2015

Applies to:

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

Symptoms

Using the Rpd to view data via new odbc connection to Sql server throws the error:

[xxxx-xx-xxT13:23:59.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0051Q6H8qoU9Hfs5sjCCyX0007cX000000] [tid: 9e81e940] [nQSError: 16001] ODBC error state: 81 code: 0 message: 523 80.
[xxxx-xx-xxT13:23:59.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0051Q6H8qoU9Hfs5sjCCyX0007cX000000] [tid: abb73940] [nQSError: 16001] ODBC error state: 81 code: 0 message: 523 80.
[xxxx-xx-xxT13:23:59.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0051Q6H8qoU9Hfs5sjCCyX0007cX000000] [tid: abb73940] [nQSError: 16001] ODBC error state: 81 code: 0 message: 523 80.
[[Init block 'XYZ': Dynamic refresh of repository scope variables has failed.]]
[xxxx-xx-xxT13:23:59.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 0050OZd24RA9Hfs5sjCCyX0005lj000000] [tid: aaa6e940]  [43143] Blacklisted connection pool: '"OBIEE11"."XYZ"'

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