Page 1 of 1

Phantom 2892 warning

Posted: Tue May 09, 2006 3:11 am
by arasan
I am getting this Phantom warning can any one suggest me how to get rid of it..........


DataStage Job 1095 Phantom 2892
Program "JOB.166157985.DT.1400823392.TRANS1": Line 376, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 377, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 378, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 379, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 380, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 381, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 376, Division by zero, zero returned.
Program "JOB.166157985.DT.1400823392.TRANS1": Line 377, Division by zero, zero returned.

Posted: Tue May 09, 2006 3:17 am
by maheshsada
Check in the transformer of your job, You are trying to divide some variable with zero, check the rows fetched by the source

Posted: Tue May 09, 2006 5:00 am
by ray.wurlod
Look in the file RT_BP1095/JOB.166157985.DT.1400823392.TRANS1 on your server around about the line numbers indicated. Identify the corresponding expressions in your Transformer stage, and add If functions to make sure that zero-valued divisors are properly handled.