Divident by zero

vikibemech · Post by **vikibemech** » Thu Aug 06, 2009 1:22 am

I am getting an error as below and not able to move forward to resolve. Please advice if any.

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.

When I am viewing the Performance Statistics in the job, not able to see any error links in any of the stages. But job is getting aborted and causing dependent job to fail (not able to run).

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Aug 06, 2009 1:56 am

You have to look into the TRANS4 lines 109 to 112 to see what operation is being carried out.

My assumption is that you are doing some arithmetic division in a transformer stage in your job.

chulett · Post by **chulett** » Thu Aug 06, 2009 6:23 am

I think we've gone beyond assumption here.

Check your math and add an explicit check to stop dividing by zero.

ray.wurlod · Post by **ray.wurlod** » Thu Aug 06, 2009 4:35 pm

Moderator: please move to server forum

vikibemech · Post by **vikibemech** » Tue Aug 11, 2009 2:34 am

In the job I have many transformers. I am not clear what Trans4 mean? Coudl you please explain briefy.

ArndW · Post by **ArndW** » Tue Aug 11, 2009 2:37 am

It is the transformer that is called "TRANS4" in your designer.

chulett · Post by **chulett** » Tue Aug 11, 2009 7:31 am

Actually, it is the fourth transformer as the crow counts.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 11, 2009 4:38 pm

Look in RT_BP1130/JOB.867233938.DT.1505838351.TRANS4 in your project. The Transformer stage name will be identified in the comments.

Look around the line numbers mentioned to find out what is being divided by what, then change your design to intercept and prevent zero divisors.

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

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.

miwinter · Post by **miwinter** » Thu Aug 27, 2009 5:12 am

Have you checked any stage variables in the transformer stage too, as well as output link derivations?

In the file Ray pointed you to, what is contained at line 109 through line 112?

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

I have Stage Vaiable with If else if conditions. No arithmatic calculation found. In stage Vaiable, operator used is <>. nothing else.

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

I have zero's in this row like other rows. But the issue is only with these rows.

miwinter · Post by **miwinter** » Thu Aug 27, 2009 5:25 am

And in answer to my other question (a re-quote of Ray et al's)...?

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

Policy no, Value 1, Value 2, Vlaue 3, Value 4
12345, 1, 0, 0, 0
23456, 0, 1, 0, 0
34567, 0,0, 0, 1
53265, 0, 0, 1, 0

chulett · Post by **chulett** » Thu Aug 27, 2009 5:33 am

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?

DSXchange

Divident by zero

Divident by zero

Re:Divident by zero

Dividend by zero

Dividend by zero

Dividend by zero