OBIEE 11g - Error "Too many running queries. Server is too busy to process any more queries at this time" When Running Queries (Doc ID 2030890.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

[2015-07-02T15:20:13.000-03:00] [OBIPS] [ERROR:31] [] [saw.views.promptvaluesquerycache.runsqlusingquerycache] [ecid: 04ea7676a39e77b9:-4b640f35:14dc629c0d7:-8000-0000000000371ce4,0:1] [tid: 3557271872] Too many running queries. Server is too busy to process any more queries at this time.[[
File:querycacheimpl.cpp
Line:3131
Location:
saw.views.promptvaluesquerycache.runsqlusingquerycache
saw.views.promptvaluesquerycache.findcursorforgeneratedsql
saw.views.promptvaluesquerycache.findcursorformergedsqlandgroupnames
saw.views.columnandgrouppromptvaluesmanager.execute
saw.httpserver.processrequest
saw.rpc.server.responder
saw.rpc.server
saw.rpc.server.handleConnection
saw.rpc.server.dispatch
saw.threadpool.socketrpcserver
saw.threads
SessionID: 191u00cdb6ealfln9h5moq9abukebgddibisi5a
AuthProps: AuthSchema=SSO-Siteminder|IMPERSONATE=*************|PWD=******|UID=BISystemUser|User=XYZ
ecid: 04ea7676a39e77b9:-4b640f35:14dc629c0d7:-8000-0000000000371ce4,0:1
ThreadID: 3557271872
HttpCommand: ValueTableAjax
RemoteIP: 10.xxx.xxx.xxx
]]

Changes

 The database is an Oracle RAC and one instance had crashed and was restarted.

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