'Query for Initialization Block 'EBS_SSO' has failed' Appears in NQServer Log When Integrating OBIEE With Oracle E-Business Suite With a Domain Name Consisting of a Single Word (Doc ID 1950536.1)

Last updated on JANUARY 02, 2017

Applies to:

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

Symptoms

OBIEE Integrating with EBS environment; referencing documenation here.

The BIEE Server and EBS Server is on the same domain 'local'

          ServerA.local

          ServerB.local

When user navigates from EBS to BIEE, the users who take the EBS security authentication cannot log into OBIEE. No error message is displayed; however; the following errors appear in the nQServer.log file:

2014-04-24T09:06:04.000+09:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 34abe04c74cebe89:-d56c74d:14581a311a0:-8000-00000000000348e3] [tid: c5bbf700]  [nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition. [[
[nQSError: 13011] Query for Initialization Block 'EBS_SSO' has failed.
]]
[2014-04-24T09:06:04.000+09:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 34abe04c74cebe89:-d56c74d:14581a311a0:-8000-00000000000348e3] [tid: c5bbf700]  [nQSError: 13011] Query for Initialization Block 'EBS_SSO' has failed.
[2014-04-24T09:06:04.000+09:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 34abe04c74cebe89:-d56c74d:14581a311a0:-8000-00000000000348e3] [tid: c5bbf700]  [nQSError: 43126] Authentication failed: invalid user/password.
[2014-04-24T09:07:06.000+09:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 34abe04c74cebe89:-d56c74d:14581a311a0:-8000-00000000000348fe] [tid: c58a4700] User OBIS spent 9.000000 milliseconds for http response when getAuthenticatedUserWithLanguageAndProperties
[2014-04-24T09:07:06.000+09:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 34abe04c74cebe89:-d56c74d:14581a311a0:-8000-00000000000348fe] [tid: c58a4700] User OBIS spent 0.000000 milliseconds for xerces parsing when getAuthenticatedUserWithLanguageAndProperties
[2014-04-24T09:07:06.000+09:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 34abe04c74cebe89:-d56c74d:14581a311a0:-8000-00000000000348fe] [tid: c58a4700]  [nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition. [[
[nQSError: 13011] Query for Initialization Block 'EBS_SSO' has failed.
]]

  

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