My Oracle Support Banner

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 JANUARY 30, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.1 and later
Exalytics In-Memory Machine X3-4 - Version All Versions and later
Oracle Exalytics Software - Version 1.0.0.3.0 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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