Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

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

    • Product: Alma

    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
    • Was this article helpful?
    //Feedback