1 Reply Latest reply: Nov 9, 2012 4:31 AM by A. Drieux RSS

    Restart session from Failover point

    973455
      Hi,

      ODI process loading 10 million rows from Oracle to Oracle (same instance). Process failed half way after 2 hour. Anyone build any framework to restart from failed point? Can we save 2 hours?

      Regards
        • 1. Re: Restart session from Failover point
          A. Drieux
          Some questions :
          1) In which step did it fail ?
          2) Which KM are you using ?


          It's too late for now. But before starting again, you can modify the IKM step "insert new rows" in order to commit rows every 10 000 rows.
          If you do that, if it fails the next time, some rows will be correctly loaded.