My Oracle Support Banner

'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 30, 2019

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

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.