Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Informatica Workflow hung/waits.

816279Nov 18 2010

We have Informatica version 8.6.0 HF4 and OBIA 7.9.6. We are facing a weird issue with Informatica workflows hanging/waiting in recent months.

Informatica session completes quick, but workflow takes long time to recognize last session finished. So it waits for long time to finish workflow. Sometimes the time difference between last session completion and workflow completion time can be in hours. Not sure, what is causing workflow to wait.. I know for sure there is no lock on target database.

Also this behavior is random. It happens on intermittently on different workflows at different timings. There is no specific pattern to narrow down to root cause.

Did any of you face this issue in your environment? Appreciate your time for response.

Thanks,
Ash

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2010

Added on Nov 18 2010

#business-intelligence-applications

0 comments

785 views