Hi,
I am running an ODI Load Plan which has an Parallel step which runs 380 Scenarios , after running around 180-220 (this value is not consistent) scenarios it hangs with out doing anything.
When i see the operator some of the sessions will be in "Waiting" status and some of the sessions will be without any status and after running there for approximately 2 hours load plan fails with the following error
Oracle.odi.runtime.agent.invocation.InvocationException: ODI-1274: Agent Exception Caused by: Could not get JDBC Connection; nested exception is java.sql.SQLException: weblogic.common.resourcepool.ResourceLimitException:
No resources currently available in pool odiMasterRepository to allocate to applications, please increase the size of the pool and retry..
I went and made some changes to the Weblogic agent Connection pool settings and set the value to 400 (Random Value) for Master repository and Work Respository even then i face the same issue ?
Is there a limitation in the load plan on number of sessions to run in parallel ?
Can you please suggest what other thing i need to check.
Thank you