Issue with calling routine in sequencer

udayk_2007 · Post by **udayk_2007** » Wed Dec 02, 2015 4:59 am

Hi Friends

I am facing a issue with a sequencer. Sequencer design is as below

Routine Activity---> Job

Many a times the sequencer is making checkpointed run to routine. In this case it is not returning value to job and job is running with default parameter.

RC_SEQ_J_G4211..JobControl (@Routine_MapVar_Lookup): Checkpointed call of routine 'DSU.GetLastUpdDateTime'

I am not understanding why it is making checkpointed call to routine.

Also on very few occasion the sequencer is running correctly with the routine returning value

Appreciate your help

ray.wurlod · Post by **ray.wurlod** » Wed Dec 02, 2015 2:15 pm

Check the "do not checkpoint run" property in the Routine activity to prevent it from being checkpointed (to force the routine to be run every time the sequence runs).

udayk_2007 · Post by **udayk_2007** » Thu Dec 03, 2015 6:12 am

Thanks Ray. I will check

The point of confusion to me is why it is making checkpointed call on most occasions and a normal call at few times.

There is no abort in the sequencer in any case

Thanks for your help

chulett · Post by **chulett** » Thu Dec 03, 2015 7:34 am

What options do you have enabled in the Sequence job? Does the routine return something other than a zero for success or a non-zero value for failure?

chulett · Post by **chulett** » Thu Dec 03, 2015 7:36 am

If that's literally all you have in the Sequence and you disable checkpoints for the routine then there's absolutely no reason to have them enabled at all.