Surrogate Stage causing job to hang

[rohanf]

Hi,

I am facing a strange issue. When we run the job(having the surrogate stage) in a sequencer the job and the sequencer hangs.

When we open the job and view performance stats, All records seem to stop at the surrogate stage and 0 records moving out of the stage.

However when we abort the re-startable sequence and restart the sequence , the job runs fine the second time.

I don't know what more info to provide.

Thanks & Regards
Rohan

[vivekgadwal]

I don't know what more info to provide.

Rohan - For starters, you could post any error that appears when you re-set the job.
Also, post the settings inside the surrogate key generator stage (if you are using one) and the general job design.

[nirav.parikh]

Rohan,

Any update on the above issue? Were you able to fix it?
I am possibly having a similar issue, where my jobs with Surrogate key generator stages are hanging intermittently.

2 or 3 times they run fine and then they hang, on killing them and restart they get done in a minute. We are on DS 8.5 on linux.