OBIEE 10g: Error: "[nQSError: 13011] Query for Initialization Block 'Authentication' has failed. " The HR_ORG Variable for Analytics E-Business Suite Org-Based Security is not Initialising

(Doc ID 827506.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 10.1.3.4.0 [1900] to 10.1.3.4.2 [2405] [Release 10g]
Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.0 [1900] to 10.1.3.4.2 [2405] [Release 10g]
Information in this document applies to any platform.
Checked for relevance on 15-Feb-2011
Checked for relevance on 22-May-2013
***Checked for relevance on 24-Apr-2014***


Symptoms

You tried to configure OBIEE with Oracle eBusiness Suite HR Org-Based Security.  You set up the HR_ORG variable (row-wise) under the HR Organizations initialization block as per the documentation. But the variable is not initialising. The query was tested (replacing the :USER variable with a surname) and it works with direct SQL, so the statement itself is not an issue.

The NQServer.log file shows the following errors:

[nQSError: 13011] Query for Initialization Block 'Authentication' has failed.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'LOGIN Properties' has failed.
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach.
[nQSError: 17014] Could not connect to Oracle database.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'EBS Security Context' has failed.
[nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'Ledgers' has failed.
[nQSError: 23006] The session variable, NQ_SESSION.OLTP_EBS_RESP_APPL_ID, has no value definition.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'Ledgers' has failed.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'Business Groups' has failed.
[nQSError: 23006] The session variable, NQ_SESSION.OLTP_EBS_RESP_APPL_ID, has no value definition.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'Business Groups' has failed.
2009-02-12 11:27:37
[nQSError: 13011] Query for Initialization Block 'HR Organizations' has failed.
[nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition.
2009-02-12 11:45:15
[nQSError: 12002] Socket communication error at call=recv: (Number=104) Connection reset by peer
2009-02-12 11:45:15
[43031] : Oracle BI Server shutdown.
2009-02-12 11:45:17
[14058] Unloaded all subject areas.

 

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