Parallel job reports failure (code -99)

sreekanth kutumbaka · Post by **sreekanth kutumbaka** » Fri Nov 27, 2009 1:01 am

One of the Px jobs fails reporting a fatal error : Parallel job reports failure (code -99). When do we get this error and what are the possible reasons? The job reads from a DB2, DB2 lookups and outputs to DB2.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 27, 2009 5:23 am

No idea.

Did you Search DSXchange for this error message?

Funnily enough, code -99 also really means "no idea" (technically "other error").

Were there any other messages? Is this repeatable? Was your system heavily loaded at the time?

seenusr2000 · Post by **seenusr2000** » Fri Nov 27, 2009 8:54 am

You got c0de -99 error.
i think it is coming from target data loding area.
at a time your doing 2 operations in u r target database.
may be your using 2 table names in single DB2 stage.
am i right?

ray.wurlod wrote:No idea.

Did you Search DSXchange for this error message?

Funnily enough, code -99 also really means "no idea" (technically "other error").

Were ...

ray.wurlod · Post by **ray.wurlod** » Fri Nov 27, 2009 2:22 pm

Welcome aboard.

Please strive to maintain a professional standard of written English on DataStage. It assists people whose first language is not English. There is no need to resort to SMS-style abbreviations - you can make your posts as long as you wish.

Neither "your" nor "u r" is correct spelling when you're abbreviating "you are". Ordinarily the first person personal pronoun is capitalized.

As to whether you're right or not, there is not enough information in the original post to make a cogent reply, that is there is no way you could come to that diagnosis from what was provided.

You may have seen this error code in the circumstances you describe, but please do not confuse cause and effect - code -99 can be caused by myriad different problems.

vasu23 · Post by **vasu23** » Sun Nov 29, 2009 11:56 pm

This is compilation problem,please compile the job and run

ray.wurlod · Post by **ray.wurlod** » Mon Nov 30, 2009 12:02 am

vasu23 wrote:This is compilation problem,please compile the job and run

A job can't be run unless it has been successfully compiled, and this error is being thrown at run time. Therefore this is NOT a compilation problem.

ragavendradineshdsx · Post by **ragavendradineshdsx** » Tue Dec 01, 2009 1:06 am

if possible, can you post the complete job error log?

DSXchange

Parallel job reports failure (code -99)

Parallel job reports failure (code -99)

Hi srikant

Re: Parallel job reports failure (code -99)

Re: Parallel job reports failure (code -99)