Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

weblogic could not login after EBS SSO integration with OBIEE 11.1.1.9.3

Received Response
112
Views
3
Comments
AnkitR Gupta
AnkitR Gupta Rank 4 - Community Specialist
edited Aug 13, 2024 6:11PM in Oracle Analytics Cloud and Server

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

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    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.

  • AnkitR Gupta
    AnkitR Gupta Rank 4 - Community Specialist

    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: <anonymous>] [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: <anonymous>] [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.[[

  • AnkitR Gupta
    AnkitR Gupta Rank 4 - Community Specialist

    Also,

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

    Not sure what am I missing.