OBIA 7.9.6.3: Error: "[nQSError: 17014] and [nQSError: 43059]" Causing Initialization Blocks to Fai (Doc ID 1500051.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

You are using OBIA 7.9.6.3 with OBIEE 11.1.1.6.0 and Oracle 11g.

Initialization blocks for OBIA are failing with following errors in nqsserver.log:

[2012-09-12T12:00:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004mNrUrJNBFCCG6yz7i6G00021K0005MM] [tid: 441d8940] [nQSError: 43059] Init block 'Current Date Variables': Dynamic refresh of repository scope variables has failed.
[2012-09-12T12:00:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004mNrUrJNBFCCG6yz7i6G00021K0005MM] [tid: 441d8940] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
at OCI call OCILogon.
]]
[2012-09-12T12:00:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004mNrUrJNBFCCG6yz7i6G00021K0005MM] [tid: 441d8940] [nQSError: 43059] Init block 'Current Snapshot': Dynamic refresh of repository scope variables has failed.
[2012-09-12T12:00:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004mNrUrJNBFCCG6yz7i6G00021K0005MM] [tid: 441d8940] [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied
at OCI call OCILogon.
]]
[2012-09-12T12:00:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004mNrUrJNBFCCG6yz7i6G00021K0005MM] [tid: 441d8940] [nQSError: 43059] Init block 'Warehouse Refresh Date': Dynamic refresh of repository scope variables has failed.


When you test the initialization blocks in the Administrator tool in online mode, they are successful.

Oracle Call Interface for connection pool is set to OCI 10g/11g as specified in <Note 1470423.1> - OBIEE 11g: Error: "[nQSError: 43059] Init Block ..Dynamic refresh of repository scope variables has failed. Oracle Error code: 1017, message: ORA-01017: invalid username/password; logon denied".

You have checked you settings against the document 'Initialization Block Configuration in OBI Repository.pdf' (which is attached to this note for reference) and all your settings are correct.

 

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