'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 AUGUST 30, 2021

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'

BIEE Server :(hostname.domainname)

ServerA.local

EBS Server :(hostname.domainname)

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

'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)

Applies to:

Symptoms

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!