Job Failed Due to unknown error (for me)

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Job Failed Due to unknown error (for me)

Post by karthi_gana »

All,

5377\2009-05-29 21:02:20\2\\295\P_S06_TO_PS_MA_SL..JobControl (@S07_MA_SL): Controller problem: Error calling DSRunJob(P_S07_MA_SL_HG_DATA), code=-2 (...)
5380\2009-05-29 21:02:20\2\\295\Attempting to Cleanup after ABORT raised in stage P_S06_TO_PS_MA_SL..JobControl
5379\2009-05-29 21:02:20\3\\295\P_S06_TO_PS_MA_SL..JobControl (fatal error from @Coordinator): Sequence job will abort due to previous unrecoverable errors


I have received an email like above.

1) What it denotes?

2) If something is problem with the job, which job has the problem?
i.e P_06 or P_07

3) What i need to do?

4) What is the solution to this problem?

5) From where i have to dig this issue?

Inputs are welcome!
Karthik
mahadev.v
Participant
Posts: 111
Joined: Tue May 06, 2008 5:29 am
Location: Bangalore

Post by mahadev.v »

Problem with you job "P_S07_MA_SL_HG_DATA". Don't know what code = -2 represents. Start with checking the job log.
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Who or what sent the email? Track that down.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Post by karthi_gana »

ray.wurlod wrote:Who or what sent the email? Track that down. ...
Actually we schedule the jobs,i received it from that email id. I already posted the content of the email. Just i got the above error message only.
Karthik
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Look in the DSINCLUDE/JOBCONTROL.H file in any project, search for the token DSJE. BADSTATE (which equates to error code -2). This indicates that the job is (was) not in a runnable state - perhaps not compiled but more likely aborted or stopped and not reset.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Post by karthi_gana »

ray.wurlod wrote:Look in the DSINCLUDE/JOBCONTROL.H file in any project, search for the token DSJE. BADSTATE (which equates to error code -2). This indicates that the job is (was) not in a runnable state - perhaps no ...
From where i have to find it?

can you tell me the exact location?
Karthik
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Under your DSEngine directory where the Server software is installed.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, not there. There is one in each project directory on the server.

In any case I have provided the decoding for you, as well as advising where to find the error codes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's true... I'm thinking of $DSHOME/include/dsapi.h which has the same information.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply