Too many running queries in OAS versions 2022 / 2025

Chad Williams

Hello,

Only until recently did we encounter this error for the first time. When users were trying to run any reports or dashboards, they were getting the following error.

“Condition cannot be evaluated: Too many running queries. Server is too busy to process any more queries at this time." 

I found a thread here in the forum on this from Jan 2018, and just want to verify that the following document is still applicable, in OAS version 6.4 (2022) and in the newest version for OAS 8.2 (2025).

Usable link:

https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=132608204487187&id=1462776.1

We simply restarted our bi server and admin server that day and haven't seen the issue again since.

Regards,

Chad

Sumanth V -Oracle

@Chad Williams - Yes, it is still applicable in Oracle Analytics Server (OAS) versions 2022 (6.4) and 2025. The MOS Doc ID 1462776.1 that you've referenced remains relevant for addressing this issue.

This condition typically arises when the BI Server reaches its maximum threshold of concurrent queries or system resources become temporarily constrained. Restarting the BI and Admin servers, as you did, often resolves the issue temporarily by releasing held resources and clearing blocked sessions.

For a more permanent mitigation, it's advisable to review and tune the following:

• BI Server Configuration parameters, such as MAX_SESSION_LIMIT or MAX_REQUEST_PER_SESSION
• Connection Pool settings in RPD
• Long-running queries or dashboard design that may be contributing to load

Please refer the below documentation for more details:
Best Practices Guide for Tuning Oracle® Analytics Server (Doc ID 2866848.2)

Chad Williams

Thank you, @Sumanth V -Oracle !