ODI Executions Are Queued and "Max session count ([NUMBER]) is reached for agent" Message Might Be Seen in Agent Log (Doc ID 3054748.1)

Last updated on NOVEMBER 27, 2024

Applies to:

Symptoms

Using Oracle Data Integrator 12.2.1.4.x Agents, executions are being queued.

Following some symptoms that may be observed:

• The database experiences high CPU and resources during data load.
• Out-of-memory (OOM) errors might be observed for the agent, managed servers or Coherence.
• The following message might be seen in the agent log:
  
  

NOTE: The "Maximum number of sessions" configured as seen on the "Definition" tab of the Agent using ODI Studio, is the number as reported by the error message.

• When monitoring the number of session over a time frame, it can be seen that the queued sessions increase as the maximum of running sessions is reached. Reaching the maximum of sessions defined for the agent is unexpected.

Cause