Error in Sequence Job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
hema arvind
Participant
Posts: 26
Joined: Fri Jun 30, 2006 9:24 am

Error in Sequence Job

Post by hema arvind »

I have one sequence job which contains two stages.

When I try to run the sequence, at the second stage the following error is encountered


SEQProjectLoadP3iREFRESH..JobControl (@P3iProjectLoad): Controller problem: Error calling DSRunJob(P3iNewProjectLoadREFRESH), code=-99
[General repository interface 'other error']
SEQProjectLoadP3iREFRESH..JobControl (fatal error from @Coordinator): Sequence job will abort due to previous unrecoverable errors

Please provide me a solution for what could have happened.
loveojha2
Participant
Posts: 362
Joined: Thu May 26, 2005 12:59 am

Post by loveojha2 »

Check whether the job being called is in the runnable state or not, if it is not then compile it and rerun the sequence job.
Success consists of getting up just one more time than you fall.
keshav0307
Premium Member
Premium Member
Posts: 783
Joined: Mon Jan 16, 2006 10:17 pm
Location: Sydney, Australia

Post by keshav0307 »

check if you have set "Reset if Required" for the job
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Check that both of the child jobs are compiled. Use Status view in Director.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
hema arvind
Participant
Posts: 26
Joined: Fri Jun 30, 2006 9:24 am

Post by hema arvind »

Thank you for your suggestions.I got it done.The problem is with a look up hash file which has positioning problem with reference to another hash file.

Thanks much again.
Post Reply