PHANTOM ERROR.

karry450 · Post by **karry450** » Wed May 07, 2008 2:39 am

Hi Friends,

Can anyone help me with this phantom error in my server job,I have checked my job is working fine but getting a type of warning like

-----------------------------------------------------------------------------------
DataStage Job 1217 Phantom 7411
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440, Nonnumeric data when numeric required. Zero used.
Program "JOB.282366356.DT.1473640285.TRANS2": Line 440,
---------------------------------------------------------------------------

Please can Anyone help me out to resolve the above warning.

Thanks
Karthik

ArndW · Post by **ArndW** » Wed May 07, 2008 3:17 am

Look at your TRANS2 transform stage. Somewhere in there you are performing a numeric operation (addition, subtraction, etc.) and the column data value that is coming in is a string and cannot be converted to a number.

karry450 · Post by **karry450** » Wed May 07, 2008 4:40 am

ArndW wrote:Look at your TRANS2 transform stage. Somewhere in there you are performing a numeric operation (addition, subtraction, etc.) and the column data value that is coming in is a string and cannot be conve ...

Hello friend,

I dont have trans2 transformer stage in my mapping.
plz can anyone help.

thanks

ArndW · Post by **ArndW** » Wed May 07, 2008 5:06 am

What transform stages do you have?

karry450 · Post by **karry450** » Wed May 07, 2008 6:10 am

ArndW wrote:What transform stages do you have? ...

Hi Friend

I have tTrade_Validation- Transformer Stage

Thanks &Regards
Karthik

ArndW · Post by **ArndW** » Wed May 07, 2008 6:19 am

My fault on the naming convention, the TRANS2 means the second transform stage defined in your job. If you deleted the first one and only have one transform left then you need to look at that transform stage and see if you are doing a mathematical operation on a column or derived value that might contain a string value.

If your transformation does a lot of such operations, then you will need to use a more complex method that involves getting the job number, then going into the appropriate RT_BPnnn subdirectory in the project and looking at the source code around line 440

chulett · Post by **chulett** » Wed May 07, 2008 6:49 am

The job number for the 'RT_BPnnn' subdirectory is already noted in the message - in your case 1217. So you would cd to the Project directory in question, then the RT_BP1217 sub-directory there and then finally 'vi' the file noted in the message: "JOB.282366356.DT.1473640285.TRANS2". Check at and around line 440 to see what is causing the problem.

karry450 · Post by **karry450** » Wed May 07, 2008 7:03 am

chulett wrote:The job number for the 'RT_BPnnn' subdirectory is already noted in the message - in your case 1217. So you would cd to the Project directory in question, then the RT_BP1217 sub-directory there and then finally 'vi' the file noted in the message: "JOB.282366356.DT.1473640285.TRANS2". Check at and around line 440 to see what is causing the problem.

Can Anyone please help me to how actually to view that line 440?

Thanks
Karthik

chulett · Post by **chulett** » Wed May 07, 2008 7:04 am

Meaning what? You don't know where your Projects are on the server? You don't know 'cd' or 'vi'? All the steps are spelled out in my post, what part are you having a problem with?

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed May 07, 2008 7:32 am

karry450 wrote:
chulett wrote:The job number for the 'RT_BPnnn' subdirectory is already noted in the message - in your case 1217. So you would cd to the Project directory in question, then the RT_BP1217 sub-directory there and then finally 'vi' the file noted in the message: "JOB.282366356.DT.1473640285.TRANS2". Check at and around line 440 to see what is causing the problem.
Can Anyone please help me to how actually to view that line 440?

Thanks
Karthik

Carry on the following step:
1.use 'cd' command to go to your RT_BP directory.
example "cd /data/Project_Name/RT_BP1217"
2.Then do 'ls' command to view the file
3. By doing 'ls' you will find the file name
in your case JOB.282366356.DT.1473640285.TRANS2
4. Use 'vi' command.
" vi JOB.282366356.DT.1473640285.TRANS2
5. Now you have to use this ':' along with the line number
that is ' :440'

This is same thing which chulett has written

I am not trying to be rude...

chulett · Post by **chulett** » Wed May 07, 2008 7:43 am

If the confusion is where exactly your Projects directory is located, let's see if this helps. Assuming a standard setup, try:

Code: Select all

cd $DSHOME
cd ../Projects/<YourProjectName>/RT_BP1217

If the first step doesn't seem to work, try:

Code: Select all

cd `cat /.dshome`
cd ../Projects/<YourProjectName>/RT_BP1217

One of the two (hopefully) should get you to the right place to check the generated code.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed May 07, 2008 7:54 am

chulett wrote:If the confusion is where exactly your Projects directory is located, let's see if this helps. Assuming a standard setup, try:

Or one more method....in the Job logs ....check in the 2nd log..that is logs with name "Environment variable settings:" in that ,value for the "PATH" has the detail path where you will find "RT_BP"

Hey! now you have found many ways to find the RT_BP directory....

Hope this will help you..

ArndW · Post by **ArndW** » Wed May 07, 2008 7:58 am

Nice - I never used that approach before, that is faster than my usual approach of opening up a shell with TCL.
Thanks!

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed May 07, 2008 8:52 am

ArndW wrote:Nice - I never used that approach before, that is faster than my usual approach of opening up a shell with TCL.
Thanks! ...

Really my pleasure sir....Guruji..Thanks again...now it is time to enjoy...

hsahay · Post by **hsahay** » Mon Sep 08, 2008 1:49 pm

Hi,

I am getting Phantom error in the server job as shown below.

DataStage Job 1414 Phantom 28898
Program "JOB.1923272856.DT.1482858810.TRANS4": Line 679, Nonnumeric data when numeric required. Zero used.
DataStage Phantom Finished

As the members suggested,I went in to the project directory (RT_BP1414) and checked for the file "JOB.1923272856.DT.1482858810.TRANS4". But there is no file in that directory.

But when i checked the directory RT_BP1414.0, there is a JOB.1923272856.DT.1482858810.TRANS4 file but the data is in Binary format and when i did

vi JOB.1923272856.DT.1482858810.TRANS4

and looked for line 679(using :679) it is saying "Not that many lines in buffer"

please help me if i am missing anything..

DSXchange

PHANTOM ERROR.

PHANTOM ERROR.

Phantom Error

Re: PHANTOM ERROR.