Description

When running an Analytics report, the following error is returned:

"Too many running queries. Server is too busy to process any more queries at this time."

Resolution

According to the OBIEE blog at https://blogs.oracle.com/pa/entry/obiee_11_1_1_too this error is explained as follows:

The Oracle Database instance is configured by default to run only 150 PROCESSES (...) When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections.

This is a very rare event when a lot of queries are run at the same time. Just run it again some seconds or minutes later, and it should be okay.

• Article last edited: 3-Nov-2016