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

Last updated on APRIL 07, 2021

Applies to:

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)

Changes

Cause

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