Main sequence getting aborted

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

girija
Participant
Posts: 89
Joined: Fri Mar 24, 2006 1:51 pm
Location: Hartford

Post by girija »

Since your jobs are attached with jobcontrol process, it might cause the problem. We have a similar jobcontrol process and it won't allow a single warning. So if any job in the sequence get a single warning, job finished but sequence aborted due to the job warning.
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Post by betterthanever »

it depends on the triggers we use fo the sequence...
using proper tiggers you should he able to hadle the aborts due to warnings.
betterthanever
Participant
Posts: 152
Joined: Tue Jan 13, 2009 8:59 am

Post by betterthanever »

"repost"
Last edited by betterthanever on Wed Mar 04, 2009 1:54 pm, edited 1 time in total.
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

girija wrote:Since your jobs are attached with jobcontrol process, it might cause the problem. We have a similar jobcontrol process and it won't allow a single warning. So if any job in the sequence get a single warning, job finished but sequence aborted due to the job warning.
That will happen when you trigger the job on "OK" condition but we are using "OK" or "Warning".
hi sam here
uegodawa
Participant
Posts: 71
Joined: Thu Apr 27, 2006 12:46 pm

Post by uegodawa »

you can try with following trigger option;
double click Job Activity and goto Triggers tab select the 'custom' option
and enter the correct expression
example :
Job1.$JobStatus<3
Where Job1 is previous Job Activity Name in the sequence.
Thanks,
Upul
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

Is project level auto purge active?
what is duration after which it clears the log?

Try running it after turning off the project level auto purge and let us know the results.

Edit : This happens some times when the auto purge tries to clear the log of multi instance jobs.

Also check whether the last line of your log says something like project level auto purge. XXX entries removed.

This only implies to the failures when its says not running.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

We turned OFF the auto purge, it's running fine so far. But I want to see for some more runs.
hi sam here
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

samsuf2002 wrote:We turned OFF the auto purge, it's running fine so far. But I want to see for some more runs.
If it runs fine get a patch form IBM or leave it with auto purge off.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post by samsuf2002 »

What patch would that be ? If any one know about it.
hi sam here
Post Reply