1 Reply Latest reply on Oct 9, 2019 4:59 PM by Charles M

    Unable to get a system user connection to BI Server

    Mosala Mochela

      Hi,

       

      I was busy setting up OBIEE and EBS Integration as per doc: https://docs.oracle.com/middleware/11119/biee/BIEIT/ebs_actions.htm. Got to step 10 and after when I tried to login into Analytics, getting error:

      [2019-08-15T13:07:05.000+02:00] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 005^2D47PV06iKu5kb8DyZ00034q000000,0:2539] [tid: 155674368] Authentication Failure.

      Odbc driver returned an error (SQLDriverConnectW).

      State: 08004.  Code: 10018.  [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.

      [nQSError: 43113] Message returned from OBIS.

      [nQSError: 43126] Authentication failed: invalid user/password.

        (08004)[[

      File:connection.cpp

      Line:471

      Location:

               saw.connectionPool.getConnection

               saw.security.odbcuserpopulationimpl.getbisystemconnection

               saw.security.odbcuserpopulationimpl.getroles

               saw.security.userpopulationcache.populateapproleshierarchy

               saw.RoleHierarchyCache.cache.cleanup

               saw.taskScheduler.processJob

               taskscheduler

               saw.threads

      task: Cache/RoleHierarchyCache

       

      I'm able to login to EM and Console with same password I was using to login into analytics and same username: weblogic but no luck with analytics