weblogic could not login after EBS SSO integration with OBIEE 11.1.1.9.3

Question

I'm attempting to integrate EBS at a client in a fresh OBIEE 11.1.1.9 installation and have followed the oracle doc: http://docs.oracle.com/cd/E28280_01/bi.1111/e16364/ebs_actions.htm#BIEIT1327

we had OBIEE 11.1.1.7.140719 - EBS SSO Intergration and it works as expected. we referred Oracle Whitepaper for OBI-EBS SSO ( Doc ID 1343143.1 )

However, with the new 11.1.1.9 installation, once the RPD is deployed with the EBS variable, Able to access OBIEE dashboards from EBS, but unable to login into Analytics with administrator credentials, getting the error:

"Unable to Sign In. An error occurred during authentication. Try again later or contact your system administrator."

Note: Able to login into admin console and EM with the above user and password. OBI and EBS have the same domain.

we found support Doc ID 1604851.1 and the resolution was to uncheck the 'Required for Authentication' on the init block. In our RPD, that checkbox is NOT checked.

We've compared the OBIEE 11.1.1.7.140719 and 11.1.1.9 RPD and both RPDs match. The instanceconfig.xml from both installations match, as do the authenticaschemas.xml

AnkitR Gupta · Answer

Also,

I can login into Catalog manager and RPD in Online Mode.

Not sure what am I missing.

AnkitR Gupta · Answer

Hi team, I found below details from biserver-diagonstic log Does this help in identifying any gap and fix it to enable Weblogic and other admins to login using analytics URL directly BI Security Service access denied - Web Service Security SOAP header credentials are missing or empty. [2016-10-18T15:29:11.251-04:00] [bi_server1] [NOTIFICATION] [] [oracle.bi.security.service] [tid: [ACTIVE].ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 147c99f6c2492431:-bceafa3:157c4861cff:-8000-0000000000127fe3,0:1:6:1] [APP: bisecurity#11.1.1] [J2EE_APP.name: bisecurity_11.1.1] [J2EE_MODULE.name: bisecurity] [WEBSERVICE.name: SecurityWebService] [WEBSERVICE_PORT.name: SecurityWebServicePort] BI Security Service access denied - Web Service Security SOAP header credentials are missing or empty. [2016-10-18T15:29:11.256-04:00] [bi_server1] [ERROR] [OWS-04086] [oracle.webservices.service] [tid: [ACTIVE].ExecuteThread: '24' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 147c99f6c2492431:-bceafa3:157c4861cff:-8000-0000000000127fe3,0:1:6:1] [APP: bisecurity#11.1.1] oracle.webservices.provider.ProviderException: javax.xml.ws.WebServiceException: [OBI-SEC-00110] FailedAuthentication : BI Security access denied - missing web service credentials.[[

cesar.advincula.o · Answer

Yes you are right in the Oracle Support Note, however, could please, check the bi_server1.log and Adminserver.log, to check what is wrong with your authentication.