Hi.
I've a sequence job which iterates 12 hours to monitor some datastage jobs are executed sucessfully or not. After 30 or 40 minutes job failes with message "Attempting to Cleanup after ABORT raised in stage seq_SP_MONITOR..JobControl".
Command executed previous to this message was "Unix sed " command;
seq_SP_MONITOR..JobControl (@StartLoop2): Loop from 1 to 9 step 1: iteration 5
seq_SP_MONITOR..JobControl (@cmd_sed): Executed: sed -n -e 5p /opt/bi/data/rss/work/SP_MON_JOBS.txt 2>/dev/null
Reply=0
Output from command ====>
INFINITY,Load_RSS_Infinity_Exec_SP_To_Stg
I've checked/unchecked following properties in sequence to make some difference, unfortunately it didn't worked for me.
1.Add checkpoints so sequence is restartable on failure
2. Automatically handle activities that fail.
Can somebody help me to figure out the issue on this situation?
Sequence Abort with message Attempting to Cleanup after ABOR
Moderators: chulett, rschirm, roy
These are the couple of messages from bottom to top with regarding to issue;
Job seq_SP_MONITOR aborted.
Attempting to Cleanup after ABORT raised in stage seq_SP_MONITOR..JobControl
seq_SP_MONITOR..JobControl (@cmd_sed): Checkpointed execution of command 'sed'
seq_SP_MONITOR..JobControl (@cmd_sed): Executed: sed -n -e 5p /opt/bi/data/rss/work/SP_MON_JOBS.txt
Reply=0
Output from command ====>
INFINITY,Load_RSS_Infinity_Exec_SP_To_Stg
seq_SP_MONITOR..JobControl (@StartLoop2): Loop from 1 to 9 step 1: iteration 5
seq_SP_MONITOR..JobControl (@cmd_sed): Checkpointed execution of command 'sed'
Job seq_SP_MONITOR aborted.
Attempting to Cleanup after ABORT raised in stage seq_SP_MONITOR..JobControl
seq_SP_MONITOR..JobControl (@cmd_sed): Checkpointed execution of command 'sed'
seq_SP_MONITOR..JobControl (@cmd_sed): Executed: sed -n -e 5p /opt/bi/data/rss/work/SP_MON_JOBS.txt
Reply=0
Output from command ====>
INFINITY,Load_RSS_Infinity_Exec_SP_To_Stg
seq_SP_MONITOR..JobControl (@StartLoop2): Loop from 1 to 9 step 1: iteration 5
seq_SP_MONITOR..JobControl (@cmd_sed): Checkpointed execution of command 'sed'
Thanks,
Upul
Upul
Next stage in this sequence after unix 'sed' command is datastage routine named 'GetJobInfo' .
I'm not sure this controller issue coming from that routine. I've handled both triggers [ Failed-[Conditional] and Otherwise ] ; Below code is inside that routone.
* Routine : GetJobInfo
* Return Job stats
* Arg1 - Name of the Job
* 0 - Job Is Running 1 - Finished
************************************
$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle = DSAttachJob (Arg1, DSJ.ERRNONE)
jbStatus = DSGetJobInfo (JobHandle, DSJ.JOBSTATUS)
jbStartTime = DSGetJobInfo (JobHandle, DSJ.JOBSTARTTIMESTAMP)
jbEndTime = DSGetJobInfo (JobHandle, DSJ.JOBLASTTIMESTAMP)
ErrCode1 = DSDetachJob(JobHandle)
Ans = jbStatus:'|':jbStartTime:'|':jbEndTime
Return(Ans)
End:
I'm not sure this controller issue coming from that routine. I've handled both triggers [ Failed-[Conditional] and Otherwise ] ; Below code is inside that routone.
* Routine : GetJobInfo
* Return Job stats
* Arg1 - Name of the Job
* 0 - Job Is Running 1 - Finished
************************************
$INCLUDE DSINCLUDE JOBCONTROL.H
JobHandle = DSAttachJob (Arg1, DSJ.ERRNONE)
jbStatus = DSGetJobInfo (JobHandle, DSJ.JOBSTATUS)
jbStartTime = DSGetJobInfo (JobHandle, DSJ.JOBSTARTTIMESTAMP)
jbEndTime = DSGetJobInfo (JobHandle, DSJ.JOBLASTTIMESTAMP)
ErrCode1 = DSDetachJob(JobHandle)
Ans = jbStatus:'|':jbStartTime:'|':jbEndTime
Return(Ans)
End:
Thanks,
Upul
Upul
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The "End:" is not correct syntax (it should not be there at all), but I would expect that that error would have been found at compile time. It appears that a sed command finished successfully (it was checkpointed) and whatever is next in the sequence has caused the sequence to abort. What is next in the sequence?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 1
- Joined: Tue Nov 10, 2009 1:30 am
Re: Sequence Abort with message Attempting to Cleanup after
Hello All,
Just to let all know that this problem may have re-occurred again with V9.1 and there is a fixpack in place JR46525 for this.
I am following up with IBM on the issue and will keep all posted.
http://www-01.ibm.com/support/docview.w ... wg1JR46525
Regards,
Good Samaritan
Just to let all know that this problem may have re-occurred again with V9.1 and there is a fixpack in place JR46525 for this.
I am following up with IBM on the issue and will keep all posted.
http://www-01.ibm.com/support/docview.w ... wg1JR46525
Regards,
Good Samaritan