My Oracle Support Banner

'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 15, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.