Exalytics: OBIEE 220.127.116.11.1 Query Fails with Error Codes: "OAMP2OPY:GIQKCQ7V Too Many Running Queries. Server Is Too Busy To Process Any More Queries at this Time."
Last updated on SEPTEMBER 29, 2017
Applies to:Oracle Exalytics Software - Version 18.104.22.168.0 and later
Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.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.
Users are encountering errors when using Exalytics and running Oracle Business Intelligence Enterprise Edition (OBIEE) 126.96.36.199.1 reports and dashboards against tables that contain millions of rows. The error shown in the web browser is:
- 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:
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