Wrong Job Status in Director

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

Post Reply
bhurke.tejaswini
Participant
Posts: 2
Joined: Wed May 23, 2007 4:32 am
Location: Pune

Wrong Job Status in Director

Post by bhurke.tejaswini »

Is it possible that Job is failed with Fetal error but still its showing the status as Finished Status in Director and also return code as 0 ?
rleishman
Premium Member
Premium Member
Posts: 252
Joined: Mon Sep 19, 2005 10:28 pm
Location: Melbourne, Australia
Contact:

Post by rleishman »

It certainly shouldn't happen, but Director is just reading from a table to get its info. I could imagine a simple corruption in the table causing such a problem.

We have a similar problem going on in V8 at the moment with multi-instance Server jobs. We have a number of very small server jobs (they process just 1 row), and every now and then one of them will run and succeed, but not return control to the calling Job Sequence. After 1 minute the calling Job Sequence gives up and fails, and the server job status is reset to "Compiled" ("0", I think). Any subsequent run of that job using the same Invocation ID will run, but no stages will start up - the job does nothing. Running the job with any other Invocation ID works OK. Resetting or recompiling the job fixes the problem.

This post seems to have the same problem: viewtopic.php?t=111461

We finally trapped it happening last week and took screen shots all the through documenting the problem. We will raise it with IBM this week.

Does that sound like your problem? If not, sorry for hijacking the thread.
Ross Leishman
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It is possible in parallel jobs for this situation to obtain, because the "fatal" error applies to a player process yet the conductor process (which is the only process writing to the log) is not affected.

Return code 0 means "running". I don't believe you have that right.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply