REG : Job Status = 99 Error

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
Vinodanand
Premium Member
Premium Member
Posts: 112
Joined: Mon Jul 11, 2005 7:54 am

REG : Job Status = 99 Error

Post by Vinodanand »

Hi,

I've been getting this error only for this job .The job is a multi instance job and i've tried tried clearing the status file , compiling the job and rerunning but still i get this General Server error. Can anyone help me resolving the same.Please find the error message below

Job name:EligPxiLoadFileExtractSeq.TEST_1
Event #:29
Timestamp:7/4/2006 2:51:09 AM
Event type:Info
Message:
EligPxiLoadFileExtractSeq.TEST_1.JobControl (DSWaitForJob): Job EligPxiFileNameCoalitionJob.1832 has finished, status = 99 (Not running)
[/b]
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Is this a job sequence or does it have Job Control code? It seems to be issuing a call to DSWaitForjob() that is returning the error.
Vinodanand
Premium Member
Premium Member
Posts: 112
Joined: Mon Jul 11, 2005 7:54 am

Post by Vinodanand »

yes its a sequence calling the server job which does not run. Even though the server job is a multi instance job it does not show the status in the director as finished.The detail log for the server job is given below..

(EligPxiLoadFileExtractSeq) <- EligPxiFileNameCoalitionJob.1832: Job under control finished.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So... this is a Sequence job calling a multi-instance Server job? Once or many times? How are you handling the uniqueness that the Invocation ID needs? Any chance that it is running into itself?

If you have more in the way of error messages, post them. The ones that surround this one, for example or any from the other log.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Vinodanand
Premium Member
Premium Member
Posts: 112
Joined: Mon Jul 11, 2005 7:54 am

Post by Vinodanand »

chulett wrote:So... this is a Sequence job calling a multi-instance Server job? Once or many times? How are you handling the uniqueness that the Invocation ID needs? Any chance that it is running into itself?

If you have more in the way of error messages, post them. The ones that surround this one, for example or any from the other log.
A surrogate key is assigned to the invocation ID . As its a running sequence number handling of the invocation ID does not seem to be a problem. All other multi instance server jobs are running fine except for this one.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Ok... then what's different about this one? Must be something. And how about those log messages, anything else worth sharing?
-craig

"You can never have too many knives" -- Logan Nine Fingers
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

What is the status of the job EligPxiFileNameCoalitionJob.1832 in director?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply