OBIEE 11g: Error: "'Unable to create a system user connection to BI Server while running user population queries" Presentation Server Fails To Start (Doc ID 1352697.1)

Last updated on JUNE 12, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.9.170418 [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.9.170418 [Release 11g]
Generic Windows

Symptoms

After configuring Windows Services for the OBIEE 11g (11.1.1.x) AdminServer and BI_Server, the Presentation Server does not start. However, the Presentation Server starts fine if the AdminServer and BI Managed Server are started via the console or via the Start BI Services menu.

The repository (rpd) and presentation server catalog (webcat) may also have changed.

After enabling full catalog logging, the following errors are displayed in the Presentation Server (sawlog.log) logs:

[2011-08-24T11:44:18.000-07:00] [OBIPS] [ERROR:32] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: ] [tid: ] 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 (host.domain) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
File:odbcuserpoploaderimpl.cpp
Line:909
Location:
saw.security.odbcuserpopulationimpl.getbisystemconnection
saw.security.odbcuserpopulationimpl.searchidentities
saw.security.userpopulationmanagerimpl.getaccountdetailsbyid
saw.subsystem.catalog.repaircatalogsecurity
saw.subsystem.catalog.initialize
saw.subsystems.catalogbootstrapper.loadcatalog
saw.webextensionbase.init
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver
ecid:
]]
[2011-08-24T11:44:18.000-07:00] [OBIPS] [ERROR:32] [] [saw.security.odbcuserpopulationimpl.searchidentities] [ecid: ] [tid: ] 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 (host.domain) or the secondary Cluster Controller () specified for the clustered DSN. (HY000)[[
File:odbcuserpoploaderimpl.cpp
Line:659
Location:
saw.security.odbcuserpopulationimpl.searchidentities
saw.security.userpopulationmanagerimpl.getaccountdetailsbyid
saw.subsystem.catalog.repaircatalogsecurity
saw.subsystem.catalog.initialize
saw.subsystems.catalogbootstrapper.loadcatalog
saw.webextensionbase.init
saw.sawserver
saw.sawserver.initializesawserver
saw.sawserver
ecid:
]]
[2011-08-24T11:44:18.000-07:00] [OBIPS] [NOTIFICATION:1] [] [saw.sawserver] [ecid: ] [tid: ] Oracle BI Presentation Services are shutting down.[[

Changes

Configure Weblogic AdminServer and BI Managed Servers as Windows services.
Upload new RPD/catalog.

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