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..
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’.