Unable to create a system user connection to BI Server while running user population queries

problem

Cannot Log Into Oracle Business Intelligence as a User With the BISystem Role

The password of the user ID with the BISystem role may not be synchronized with the credential store.

[OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getroles] [ecid: 00iQ9iGH0rzFw0zwBG0Ezz03OxU0j1myF0001YO000000,0:1] [tid: 6932] Error retrieving user/group data from Oracle BI Server’s User Population API.
Unable to create a system user connection to BI Server while running user population queries
Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (MohamedOmar.domain66.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
File:odbcuserpoploaderimpl.cpp
Line:523
Location:
saw.security.odbcuserpopulationimpl.getroles
saw.security.userpopulationcache.populateapproleshierarchy
saw.RoleHierarchyCache.cache.cleanup
saw.taskScheduler.processJob
saw.threadpool.taskscheduler
saw.threads
ecid: 00iQ9iGH0rzFw0zwBG0Ezz03OxU0j1myF0001YO000000,0:1
ThreadID: 6932
task: Cache/RoleHierarchyCache
]]
[2014-12-12T15:58:03.000+02:00] [OBIPS] [ERROR:16] [] [saw.security.userpopulationcache.populateapproleshierarchy] [ecid: 00iQ9iGH0rzFw0zwBG0Ezz03OxU0j1myF0001YO000000,0:1] [tid: 6932] Error retrieving user/group data from Oracle BI Server’s User Population API.
Unable to create a system user connection to BI Server while running user population queries
Odbc driver returned an error (SQLDriverConnectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.
[nQSError: 73006] Cannot obtain Oracle BI Servers from either the primary Cluster Controller (MohamedOmar.domain66.com) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
File:userpopulationcache.cpp
Line:381
Location:
saw.security.userpopulationcache.populateapproleshierarchy
saw.RoleHierarchyCache.cache.cleanup
saw.taskScheduler.processJob
saw.threadpool.taskscheduler
saw.threads
ecid: 00iQ9iGH0rzFw0zwBG0Ezz03OxU0j1myF0001YO000000,0:1
ThreadID: 6932
task: Cache/RoleHierarchyCache
]]
[2014-12-12T15:58:06.000+02:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services are shutting down.[[
File:sawserver.cpp
Line:713
Location:
saw.sawserver
saw.sawserver.terminatesawserver
saw.sawserver
ecid:
]]

Solution 2

To confirm that the password is correct:

  1. Log into Oracle WebLogic Server Administration Console.
  2. Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
  3. Click the Users and Groups tab, and then the Users subtab.
  4. In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
  5. Click the Passwords tab and reset the user password. Click Save.
  6. Log into Fusion Applications Control.
  7. Open the WebLogic Domain node and right-click BIDomain.
  8. Select Security, and then select Credentials.
  9. Select oracle.bi.system and the select system.user.
  10. Edit the password to match the user password that you set in Oracle WebLogic Server.
  11. Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server
Advertisements

About lorddisk

WebCenter Content, WebCenter Portal, WebCenter Sites,Weblogic, Identity and Access Management (IAM),SSO,OAM,OIM,OAAM,OUD, OPAM,OID, OVD ,Oracle API Gateway ,OBIEE,OEDQ, Oracle ADF, Oracle SOA,J2EE, CackePHP ,PHP,J2SE,J2EE,Spring,Hibernate,JQuery,CSS,Java Script ,Joomla,Drupal,Worpress
This entry was posted in OBIEE, ] Oracle BI Presentation Services and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s