ODI-1274

Scenario:

While running scenarios in parallel on ODI, it might fail out 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..

Solution:

1. For Datasources, Master repository and Work Respository,

Check the ‘Actvie Connections High Count’ and it should be equal to ‘Maximum Capacity’ in Connection Pool page.

2. Update ‘Maximum Capacity’ to a higher count (no need to restart WebLogic as Maximum Capacity is a dynamic property).

If it fails the same, you have to check from DB side to ensure your db instance supports more connections than your ‘Maximum Capacity’.