'Connection Pool Name = odiMasterRepository, State = Overloaded' Signalled In WebLogic Server Console For Managed Servers Health Status With ODI JEE Agents (Doc ID 1500373.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Symptoms

After having :

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


of an ODI 11.1.1.5 JEE Agent, the health status as indicated in WebLogic 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

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 hundreds of Community platforms