1 Reply Latest reply: Jan 23, 2013 12:28 AM by chillychin RSS

    OWB Process Flow stuck

    985513
      Hi Gurus,

      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?

      Thanks!
        • 1. Re: OWB Process Flow stuck
          chillychin
          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