mainly sequencers abort due to the error in the job or if the job is in failed or uncompiled state . so check fro the proper run state and also check for any errors and then compile and run
Login to rate this answer.
Have you set the compilation options for the sequence so that in case job aborts, you need not to run it from from the first job. By selecting that compilation option you can run that aborted sequence from the point the sequence was aborted.
Like for example, you have 10 jobs(job1, job2, job3 etc.) in a sequence and the job 5 aborts, then by checking "Add checkpoints so sequence is restartable on failure" and "Automatically handle activities that fail" you can restart this sequence from job 5 only. it will not run the jobs 1,2,3 and 4.
Please check these options in your sequence.
Hope this helps.
1 User has rated as useful.
Login to rate this answer.
The are 2 reasons why the sequencer might get aborted:-
1:- Due to wrong parameters assigned to it.
2:- Due to error in the mapping or the job the sequencer calls
solution:
Step1:- for this correct the parameters, recomplie the job(if the parameters are hard-coded) & rerun from starting step
Step2:- For this check the reason for which the abort might be having in the job, correct it & compile the process(both job & Sequencer)
and start the job from point of failure by providing the default parameters or previous aborts.
Staring the job from point of failure will reduce the time of again loading the data if it loaded into any tables)
Login to rate this answer.
muralidhar
Answered On : Mar 26th, 2012
In Administrator we have one add check point.whenever the job is aborted we define the add check points for completed jobs.so where the job is aborted from that job itself it will run.
Login to rate this answer.
Riten
Answered On : May 30th, 2012
To Handle Aborted Sequence These are the steps to be taken: First Add Terminator to Job Sequence and Choose Terminator with Other option(Trigger in Job sequence) ( if job fails it will go to Other link which is Terminator). Now in Terminator we have option " Send Stop signal to other jobs" & "Wait for other Jobs to finish". ( What This will do is it will abort current job but wont send stop signal to other jobs so next time you run it will be shorter time This is helpful when Sequencer runs at night time and in morning it wont take much time to complete.) Now Last but not Least option is in Job Properties Select "Add checkpoints so sequence is restartable on failure" . So Essentially it was Two prong approach to handle Failed sequencer
Login to rate this answer.
