Sequence

[sri75]

Hi,

I have one routine activity and one job in sequence.


1 >When I ran the sequence, job in the sequence got aborted. but in the director , status of sequence is shown as finished and job's status is shown as Aborted.I wanted to see the status of sequence is also aborted.all compile options in the job properties are unchecked.

2 >When I checked all compilation options , sequence is getting aborted at routine activity.

Can you please explain me why in the first case it didn't abort at routine activity ?

this is the error message

Seq..JobControl (@Routine_Activity_0): Controller problem: Unhandled failure (2006) encountered calling routine DSU.GetYear

Message: Seq..JobControl (@Coordinator): Summary of sequence run
12:49:45: Sequence started (checkpointing on)
12:49:45: Routine_Activity_0 (ROUTINE DSU.GetYear) started
12:49:45: Routine_Activity_0 finished, reply=2006
12:49:45: Exception raised: @Routine_Activity_0, Unhandled failure (2006) encountered calling routine DSU.GetYear
12:49:45: Sequence failed (restartable)
Message: Seq..JobControl (fatal error from @Coordinator): Sequence job (restartable) will abort due to previous unrecoverable errors

Thanks
Sri

[Maveric]

You need to use a sequence terminator activity to terminate the sequence. Trigger the terminator activity stage only when the job aborts.

[sri75]

Thanks Maveric for your reply.

I added sequence terminator Stage to the Sequence.Can you please tell me where to put the logic to trigger the terminator stage only ,when the job aborts.
is this in job control code.

Thanks

[sri75]

I am able to solve this prblem.

Thanks Maveric for your help