This discussion is archived
1 Reply Latest reply: Nov 9, 2012 2:31 AM by A. Drieux RSS

Restart session from Failover point

973455 Newbie
Currently Being Moderated

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?

  • 1. Re: Restart session from Failover point
    A. Drieux Pro
    Currently Being Moderated
    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.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points