Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Unable to get a system user connection to BI Server
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
Answers
-
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
0