I'm new to OWB, I hope to get some help from you!
I'm supporting a ETL system based on OWB. We have daily process flows scheduled to run without any issue, however, these couple of days the ETL process can not complete. It's always stuck at certain step. We kill the process, and re-run the process, but still can not solve the problem.
Have anyone of you encountered such a situation? What need to check?
You might want to check to see if you have anything "parallel" running
We recently had an issue with one of our mappings where one day it decided to just stop working and "freeze"
Our DBA found that we had a Oracle hint for "Parallel" in the code and removed it. After that the mapping ran fine.
Best of luck