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

Charles M

Can you check some other logs to see if there is any more details? Try bi_server1.log and AdminServer.log. They should be under: /{$MW_HOME}/user_projects/domains/bifoundation_domain/servers (if you're using 11g).

BTW - You may want to add some system details ... OS, etc.?

Regards,

Charles