Page 1 of 1

Sequencer aborting when restarted with dsjob command

Posted: Wed Oct 19, 2016 7:31 pm
by Maximus_Jack
Hi
I'm trying to restart an aborted sequencer using the below dsjob command

Code: Select all

$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

Posted: Thu Oct 20, 2016 5:33 am
by Maximus_Jack
Hi all, any ideas please?

Posted: Thu Oct 20, 2016 9:10 am
by FranklinE
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.

Posted: Thu Oct 20, 2016 9:27 am
by chulett
That RESTART option is only valid for restartable Sequences, i.e. ones with checkpoints enabled. Is that the case here?

Posted: Thu Oct 20, 2016 9:29 am
by qt_ky
:oops:

Sequence is a job type.

Sequencer is a stage type.

:mrgreen:

Posted: Thu Oct 20, 2016 9:50 am
by chulett
Gee, thanks Ray. :wink:

Posted: Thu Oct 20, 2016 9:56 am
by FranklinE
That's like what I tell people when I'm teaching them a folk dance: "No! The other left foot!"

Posted: Thu Oct 20, 2016 12:02 pm
by Maximus_Jack
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

Posted: Thu Oct 20, 2016 12:03 pm
by Maximus_Jack
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

Posted: Thu Oct 20, 2016 12:05 pm
by chulett
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.