Help with this Error

[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]

[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

[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.

[yaminids]

Hi Arnd,

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

Thanks
Yamini

[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".

[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.

[yaminids]

Thanks for the info guys...