datastage Phantom error

deepthi · Post by **deepthi** » Tue Jan 15, 2008 12:05 pm

Hi,
I have a simple server job that has XML input stage and webservice transformer.

The job runs fine , but always throws a Phantom warning

"DataStage Job 80 Phantom 28551
Program "DSD.StageRun": Line 301, Square root of a negative number.
DataStage Phantom Finished"

I have the job design as

seqfile ---->trn----->webservice trn------>xmlip---->seqop.

Not sure where the error is .

Please advice

Thanks

chulett · Post by **chulett** » Tue Jan 15, 2008 12:22 pm

Search the forums for "square root of a negative number", it's been reported a number times.

deepthi · Post by **deepthi** » Tue Jan 15, 2008 12:42 pm

chulett wrote:Search the forums for "square root of a negative number", it's been reported a number times. ...

I have a routine that calls this job. As the job is returning a phantom warning, it is producing DsLogFatal error in the routine .

chulett · Post by **chulett** » Tue Jan 15, 2008 12:50 pm

And? From what I recall, this is an acknowledged bug so not sure you can do anything to fix it, per se. Can you 'work around' the issue by considering a Finished with Warnings result as ok?

Bring the issue up with your official support provider, perhaps there is a patch available.

deepthi · Post by **deepthi** » Tue Jan 15, 2008 1:35 pm

[quote="chulett"]And? From what I recall, this is an acknowledged bug

I am calling DSRunJob Command to run this specific job. How can i control the DSRunJob not to give DSLogFatal error if the job runs with this phantom warning. My run command is

ERRORCODE = DSRunJob(JobHandle1,DSJ.RUNNORMAL).

Please advice

ray.wurlod · Post by **ray.wurlod** » Tue Jan 15, 2008 2:26 pm

Use DSJ.ERRNONE as the second argument to DSAttachJob(), then handle the job status explicitly in your code.

SHARAD123 · Post by **SHARAD123** » Tue Jan 29, 2008 1:31 am

I think ur job would be handling some null values. Thats a common scenario for this error to occur

ray.wurlod · Post by **ray.wurlod** » Tue Jan 29, 2008 1:32 am

Or there may be an expression that takes the square root of a negative number - well, attempts to - in the Transformer stage in question. One ought never to leap to conclusions during diagnosis.