DSXchange

A short text to describe your forum
http://dsxchange.com./

Help with this Error

http://dsxchange.com./viewtopic.php?f=24&t=97455

Page 1 of 1

Help with this Error

Posted: Tue Dec 27, 2005 10:48 am
by chowdary
Hi all,

I am getting this error and i unable to figure it out whyi am getting this one, I checked all the metadata, there is notihng wrong in the metadata,

I am reading from table and after doing aggreagation and pivoting i am looking upon hash file and writing into a Seq file that's all i am doing in this job
when i run the job i am getting only one warning which is



"DataStage Job 1809 Phantom 8347
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
Program "JOB.1912664994.DT.1386960595.TRANS3": Line 81, Nonnumeric data when numeric required. Zero used.
DataStage Phantom Finished[quote][/quote]

Posted: Tue Dec 27, 2005 10:51 am
by sjhouse
Check the data in your table. Most lickly you have an empty field in one of the numeric fields and they are treated as non-numeric.

stephen

Posted: Tue Dec 27, 2005 12:46 pm
by ArndW
Check your transform "TRANS3" stage derivations. One of your derivations is doing a numeric operation on a column that does not contain numeric values. Usually a quick look at your derivations will show you the culprit; but if you feel like delving a bit deeper, you can look at your job's generated BASIC code at around line 81 (if can be off by a couple of lines) to see the actual statement.

Help with this Error

Posted: Tue Dec 27, 2005 1:56 pm
by yaminids
Hi Arnd,

Can you tell me where I can find a job's Basic code?

Thanks
Yamini

Posted: Tue Dec 27, 2005 2:21 pm
by ArndW
I would go to TCL and enter the command "LIST DS_JOBS WITH @ID EQ {myjobname} JOBNO to get the job number, then look into the project subdirectory RT_BP{JobNo}. Or you can use the UNIX find command on the object "JOB.1912664994.DT.1386960595.TRANS3".

Posted: Tue Dec 27, 2005 3:27 pm
by ray.wurlod
The job number is given in the first line of the warning message - in this case job number 1809, so you look in subdirectory RT_BP1809.

Note that it is the BASIC code for the Transformer stage, not the BASIC code for the job, for which Yamini asks. BASIC code for the whole job is not available; server jobs are run by the BASIC routine DSD.RUN, while Transformer stage subroutines are invoked by DSD.StageRun. Source code for these is not - never has been - supplied.

Help with this Error

Posted: Tue Dec 27, 2005 9:00 pm
by yaminids
Thanks for the info guys... :)
All times are UTC-06:00
Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited