Hi,
Starting last week our out of the box PSOFT load plan went from taking a little less than 2 hours(for over a year now) to run to 12 to 16 hours. While watching the execution you see that a certain tasks completes but it may be stuck in a wait state until ODI continues on sometimes 30 minutes later.
-I have restarted the weblogic side and database side numerous times.
-I have checked all the datasource connection pools, timeouts, etc (the datasources are not choking waiting for connections)
-memory settings for the weblogic server look good (xms 2G and xmx 4G)
-bi/odi server is not out of space
-database server is healthy
-network between weblogic server and database is good
I have attached two screenshots. In one you can see the task in the wait state. In the second you can see after drilling into the task it actually completed in a few seconds...but the ODI execution was stuck in a wait state for that step for around 30 minutes.
Any ideas and where I can dig to see what its waiting on?
Thanks!