looping and restartability
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
looping and restartability
Hello,
I have one list loop which calls one sequence. The sequence is called for each of the parameter which is getting passed from the loop. I need to implement the restartability here.ie If the sequence fails while processing the 5th parameter, when restarting the job,it should skip running the sequence for the first 4 parameters and should start from the failed run(which is for 5th parameter).
Please let me know how this can be implemented from loop.
Thanks in advance...
Linda
I have one list loop which calls one sequence. The sequence is called for each of the parameter which is getting passed from the loop. I need to implement the restartability here.ie If the sequence fails while processing the 5th parameter, when restarting the job,it should skip running the sequence for the first 4 parameters and should start from the failed run(which is for 5th parameter).
Please let me know how this can be implemented from loop.
Thanks in advance...
Linda
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
Re: looping and restartability
Hello everyone,
I tried running a sequence inside one list loop with 3 parameters. Also restartability was implemented in the sequence level by adding checkpoint. The job ran and completed for the first 2 parameters and failed for the third one. When it was restarted, datastage gave a warning message that, the parameters are not the same as that of checkpointed, and continued executing the sequence for the first 2 parameters (which were completed successfully in the previous run) again. May I know how to correct this?
Linda
I tried running a sequence inside one list loop with 3 parameters. Also restartability was implemented in the sequence level by adding checkpoint. The job ran and completed for the first 2 parameters and failed for the third one. When it was restarted, datastage gave a warning message that, the parameters are not the same as that of checkpointed, and continued executing the sequence for the first 2 parameters (which were completed successfully in the previous run) again. May I know how to correct this?
Linda
OK, perhaps it's unclear which job is giving you the warning message re: the parameters. I was assuming the outer loop Sequence job but you are talking about the inner Sequence job it seems.
Question: when the inner Sequence job aborted did the outer Sequence job abort as well? It must and both need checkpoints and to show "Aborted/Restartable" as their status for this to work. Which means you'll need to abort the outer (say, with a Terminator stage) when you detect a failure in the inner.
Question: when the inner Sequence job aborted did the outer Sequence job abort as well? It must and both need checkpoints and to show "Aborted/Restartable" as their status for this to work. Which means you'll need to abort the outer (say, with a Terminator stage) when you detect a failure in the inner.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
I am using the datastage 8.1 version.
The outer sequence will fail, when the inner sequence fails. The inner sequence has a job and a routine.So the inner sequence and the outer sequences are on "aborted/restartable" state after the job run, and checkpoints are enabled for both. But still ,on restarting it runs from the beginning (ie, from the first parameter).
The outer sequence will fail, when the inner sequence fails. The inner sequence has a job and a routine.So the inner sequence and the outer sequences are on "aborted/restartable" state after the job run, and checkpoints are enabled for both. But still ,on restarting it runs from the beginning (ie, from the first parameter).
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore
Odd. As noted, I know this works just fine in the 7.5.x world, perhaps something is not quite right in the version you have. I would suggest contacting your official support provider and seeing if this is a known issue with perhaps a patch available for it.
In the meantime, can you list the stages used in your outer Sequence job?
![Confused :?](./images/smilies/icon_confused.gif)
In the meantime, can you list the stages used in your outer Sequence job?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 34
- Joined: Mon Jun 15, 2009 12:16 am
- Location: Bangalore