Divident by zero

vikibemech · Post by **vikibemech** » Thu Aug 27, 2009 5:44 am

By seeing the log in Director, I have taken the transformer count (4th trans in log). Error msg i have mentioned above. 5 columns coming as input to transformer (as mentioned above). let me know if you have any questions.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 27, 2009 5:52 am

If you are looking for any assistance from others, you need to do what they are asking.

1.) Provide those lines mentioned from RT_BP1130 file - as mentioned by Ray
2.) Provide the (non-direct) derivations in stage variables and links - even though they may not be division operation carried out.

vikibemech · Post by **vikibemech** » Thu Aug 27, 2009 6:32 am

DataStage Job 1130 Phantom 10132

Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 112, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 109, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 110, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 111, Division by zero, zero returned.

Program "JOB.867233938.DT.1505838351.TRANS4": Line 112, Division by zero, zero returned.

miwinter · Post by **miwinter** » Thu Aug 27, 2009 6:51 am

That's a repost of the output from the phantom error / job log, not what was requested.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 27, 2009 7:55 am

Craig after reading this =

->

aladap12 · Post by **aladap12** » Thu Aug 27, 2009 8:05 am

vikibemech wrote:thanks for the info. I walked through the trans4 stage and there is no arithmatic division in any of the column. My design is like this Seq file-> Agg -> Hash file ->transformer.

Hash file input is 10K records but output is only 33 records(which is the input for Transformer). I am not clear where the other records are? Please advice if any.

Have you checked the file Names in the hashed file ? ie.. Input and output.. check that once... I assume that they are different in your case.

Thx

chulett · Post by **chulett** » Thu Aug 27, 2009 8:51 am

Sainath.Srinivasan wrote:Craig after reading this = -> -> -> -> ->

chulett · Post by **chulett** » Thu Aug 27, 2009 8:51 am

chulett wrote:How about you go to that TRANS4 file and actually post the code from the lines mentioned plus several on either side, let us take a look?

miwinter · Post by **miwinter** » Thu Aug 27, 2009 9:42 am

chulett wrote:
chulett wrote:How about you go to that TRANS4 file and actually post the code from the lines mentioned plus several on either side, let us take a look?

teeth/pulling :D

vikibemech · Post by **vikibemech** » Fri Aug 28, 2009 2:40 am

Thanks for the info provided till now. Issue has been resolved now.

miwinter · Post by **miwinter** » Fri Aug 28, 2009 2:42 am

In the spirit of things (and the effort expended here), could you elaborate on how this was resolved in the end please? Mark the topic as resolved too please, as it will guide others to this resolvable issue in future.

vikibemech · Post by **vikibemech** » Sun Aug 30, 2009 11:38 pm

Identified the policy no which is creatign the issue. Filter the policy in transformer stage by a constraint. Job completed succesfully.

miwinter · Post by **miwinter** » Tue Sep 01, 2009 1:35 am

So what was the issue caused by the policy number? Was it a null / a zero?

DSXchange

Divident by zero

Dividend by zero

Dividend by zero

Re: Dividend by zero

Divident by zero