Sequencer aborting when restarted with dsjob command

Maximus_Jack · Post by **Maximus_Jack** » Wed Oct 19, 2016 7:31 pm

Hi
I'm trying to restart an aborted sequencer using the below dsjob command

$DSHOME/bin/dsjob -run -mode RESTART -warn 0 $parameter $dsproj $sequencername

for this sequencer all the parameter should run with the default values, so i'm not assigning any value for the "$parameter", when I submit the command

The sequencer is getting aborted with the message "The current job run does not have the same parameters as its checkpoint record.", when i see the job log, the first parameter value is getting the value as below

Code: Select all

The checkpointed parameter values were:
parame_x=1   [current run=1?parame_y=50000?param_z=1000?

if you see above, all the parameter values are getting assigned to the first parameter and moreover the parameters values are having a "?" ( it may be a ctrl+z ), any idea why its happening and why the sequencer is failing?

thanks
MJ

Maximus_Jack · Post by **Maximus_Jack** » Thu Oct 20, 2016 5:33 am

Hi all, any ideas please?

FranklinE · Post by **FranklinE** » Thu Oct 20, 2016 9:10 am

Not sure without more details about your job sequence design, but you might need to issue a RESET command before trying to rerun.

However, you could also enable checkpoints instead, and let DataStage handle reset and restart internally without needing to do it yourself with separate command lines.

chulett · Post by **chulett** » Thu Oct 20, 2016 9:27 am

That RESTART option is only valid for restartable Sequences, i.e. ones with checkpoints enabled. Is that the case here?

qt_ky · Post by **qt_ky** » Thu Oct 20, 2016 9:29 am

Sequence is a job type.

Sequencer is a stage type.

chulett · Post by **chulett** » Thu Oct 20, 2016 9:50 am

Gee, thanks Ray.

FranklinE · Post by **FranklinE** » Thu Oct 20, 2016 9:56 am

That's like what I tell people when I'm teaching them a folk dance: "No! The other left foot!"

Maximus_Jack · Post by **Maximus_Jack** » Thu Oct 20, 2016 12:02 pm

Hi
thanks for responding, yes the checkpoint is enabled, the issue is I don't know why all the the parameters values are getting assigned to the first parameter and why are they having "?" in them, don't know whether that is causing the issue.

I saw this below thread, but there is no definite solution

http://www-01.ibm.com/support/docview.w ... wg1JR47272

thanks
MJ

Maximus_Jack · Post by **Maximus_Jack** » Thu Oct 20, 2016 12:03 pm

Hi
thanks for responding, yes the checkpoint is enabled, the issue is I don't know why all the the parameters values are getting assigned to the first parameter and why are they having "?" in them, don't know whether that is causing the issue.

I saw this below thread, but there is no definite solution

http://www-01.ibm.com/support/docview.w ... wg1JR47272

thanks
MJ

chulett · Post by **chulett** » Thu Oct 20, 2016 12:05 pm

That doesn't sound like your issue, that looks to be specific to parameter values with <CR><LF> characters in them. Probably best to open your own support case and let us know what you find out.