Hi ,
While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted and finished fine.Any solution will be appreciated.
sub sequence aborted but the main sequence didn't
Moderators: chulett, rschirm, roy
Re: sub sequence aborted but the main sequence didn't
Hi,
Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly.
the result is if sub sequencer is fail your main sequencer also will fail
Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly.
the result is if sub sequencer is fail your main sequencer also will fail
major wrote:Hi ,
While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted and finished fine.Any solution will be appreciated.
Re: sub sequence aborted but the main sequence didn't
Hi,
Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly.
the result is if sub sequencer is fail your main sequencer also will fail
Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly.
the result is if sub sequencer is fail your main sequencer also will fail
major wrote:Hi ,
While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted and finished fine.Any solution will be appreciated.
Re: sub sequence aborted but the main sequence didn't
Hi,
Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly.
the result is if sub sequencer is fail your main sequencer also will fail
Please verify your sequence design. use "uttility abort log" routine and set up the trigger correctly.
the result is if sub sequencer is fail your main sequencer also will fail
major wrote:Hi ,
While i am running the master sequence , a job in subsequence aborted but master sequence didn't aborted and finished fine.Any solution will be appreciated.
Re: sub sequence aborted but the main sequence didn't
Major,
Check if you have selected following property at the job sequence property level.
Automatically Handle Activities that fail.
Check if you have selected following property at the job sequence property level.
Automatically Handle Activities that fail.
Hmm i will fill this when ever i get one
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Verify in your master sequence that the activity stage calling the sub sequence has a failed trigger and does NOT have an unconditional trigger.
The default trigger colors of DataStage Designer do not give enough visual clues. I suggest changing the wraning trigger to yellow, and the otherwise trigger to bright green.
After changing the colors, reopen your job and investigate your trigger settings.
Even if your sub sequence aborts, your master sequence may not abort unless you invoke a terminiation activity stage. However, you may not want your master sequence to abort if it is scheduled. Aborting leaves a sequence in a non-runnable state that must be reset before the scheduler will start it. I prefer the master sending an email when the sub sequence aborts, rather than aborting itself.
The default trigger colors of DataStage Designer do not give enough visual clues. I suggest changing the wraning trigger to yellow, and the otherwise trigger to bright green.
After changing the colors, reopen your job and investigate your trigger settings.
Even if your sub sequence aborts, your master sequence may not abort unless you invoke a terminiation activity stage. However, you may not want your master sequence to abort if it is scheduled. Aborting leaves a sequence in a non-runnable state that must be reset before the scheduler will start it. I prefer the master sending an email when the sub sequence aborts, rather than aborting itself.
Chuck Smith
www.anotheritco.com
www.anotheritco.com