OBIEE 11g: Error: "Unable to create a system user connection to BI Server while running user population queries" BI Server Component does not Start (Doc ID 1903038.1)

Last updated on JANUARY 23, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.6 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.6 and later
Information in this document applies to any platform.

Symptoms

You have installed OBIEE 11.1.1.6.6.  When you start it up, the BI Server component does not start.  You can see this, with the following command:

> opmnctl status

Processes in Instance: instance1
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
coreapplication_obiccs1 | OracleBIClusterCo~ | 129106~ | Alive
coreapplication_obisch1 | OracleBIScheduler~ | 9044004 | Alive
coreapplication_obijh1 | OracleBIJavaHostC~ | 8126584 | Alive
coreapplication_obips1 | OracleBIPresentat~ | 124518~ | Alive
coreapplication_obis1 | OracleBIServerCom~ | N/A | Down


You see the following error in sawlog.log:

[2014-05-03T22:35:20.000-04:00] [OBIPS] [ERROR:31] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 000003TQQHZAxGoLOUH7id01400u000000,0:2] [tid: 12081] 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 (axrsgpar1815) or the secondary Cluster Controller (axrsgpar1816) specified for the clustered DSN. (HY000)[[
File:odbcuserpoploaderimpl.cpp
Line:998
Location:
saw.security.odbcuserpopulationimpl.getbisystemconnection
saw.security.odbcuserpopulationimpl.getroles
saw.security.userpopulationcache.populateapproleshierarchy
saw.RoleHierarchyCache.cache.cleanup
saw.taskScheduler.processJob
taskscheduler
saw.threads

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms