My Oracle Support Banner

"Connection Pool Name = odiMasterRepository, State = Overloaded" Signaled in WebLogic Server Console for Managed Servers Health Status with ODI J2EE Agents (Doc ID 1500373.1)

Last updated on SEPTEMBER 18, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
The article applies to all releases of ODI like the current 12C as well as to previous releases.

Symptoms

After having:

  1. Increased the connection pool maximum capacity...
  2. Increased the heap size...

   of an Oracle Data Integrator (ODI) J2EE Agent, the health status as indicated in WebLogic (WLS) Console changes frequently from OK to Overloaded with the following reason:

Connection Pool Name = odiMasterRepository, State = Overloaded

]] Root cause of ServletException.
ODI-1274: Agent Exception
Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: weblogic.comm
on.resourcepool.ResourceLimitException: No resources currently available in pool odiMasterRepository to allocate to applications, please increase the size of
the pool and retry..
  at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:557)
  at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

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!

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