OBIEE 11g: Unable To Start The Presentation Server Component (Doc ID 2364720.1)

Last updated on DECEMBER 14, 2023

Applies to:

Symptoms

You are trying to start/restart the presentation server component (might be as part of the process to refresh the GUIDs) but it takes a long time to start and you see this error in the sawlogn.log:

[<timestamp>] [OBIPS] [WARNING:16] [] [saw.security.odbcuserpopulationimpl.getbisystemconnection] [ecid: 0002Ikgm404Fw00Fzzw0w00000RJ000000,0:38] [tid: 61] Unable to get a system user connection to BI Server (attempt m of 500). Sleeping for 4 seconds before trying again.[[
File:odbcuserpoploaderimpl.cpp
Line:1054
Location:
saw.security.odbcuserpopulationimpl.getbisystemconnection
saw.security.odbcuserpopulationimpl.getroles
saw.security.userpopulationcache.populateapproleshierarchy
saw.RoleHierarchyCache.cache.cleanup
saw.taskScheduler.processJob
saw.threadpool.taskscheduler
saw.threads
task: Cache/RoleHierarchyCache
]]

Also, at the same time this error is seen on the nqcluster.log:

[<timestamp>] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: babfa700] [71021] An attempt to establish a connection with Oracle BI Server <server>:<port> (monitor port <monitor_port>) failed.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.