DSXchange

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

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

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 .

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.

[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

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

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

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.