Exalytics: OBIEE 11.1.1.7.1 Query Fails with Error Codes: "OAMP2OPY:GIQKCQ7V Too Many Running Queries. Server Is Too Busy To Process Any More Queries at this Time."

(Doc ID 1911202.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Oracle Exalytics Software - Version 1.0.0.3.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Exalytics In-Memory Machine X3-4 - Version All Versions and later
Exalytics In-Memory Machine X2-4 - Version All Versions and later
Information in this document applies to any platform.

Symptoms

Users are encountering errors when using Exalytics and running Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.1 reports and dashboards against tables that contain millions of rows.  The error shown in the web browser is:

Error Codes:
OAMP2OPY:GIQKCQ7V
- Too many running queries. Server is too busy to process any more queries at this time

The NQQuery.log does not show a matching error, but there are many errors related to missed cache entries near the same time that the browser error was reported:

 

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