Divident by zero
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Divident by zero
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).
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).
Vignesh Kumar N
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
I think we've gone beyond assumption here.
Check your math and add an explicit check to stop dividing by zero.
Check your math and add an explicit check to stop dividing by zero.
Last edited by chulett on Thu Aug 06, 2009 9:19 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Re:Divident by zero
In the job I have many transformers. I am not clear what Trans4 mean? Coudl you please explain briefy.
Vignesh Kumar N
It is the transformer that is called "TRANS4" in your designer.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Dividend by zero
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.
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.
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Dividend by zero
I have zero's in this row like other rows. But the issue is only with these rows.
Vignesh Kumar N
-
- Participant
- Posts: 46
- Joined: Fri May 02, 2008 1:11 am
- Location: Chennai
Dividend by zero
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
12345, 1, 0, 0, 0
23456, 0, 1, 0, 0
34567, 0,0, 0, 1
53265, 0, 0, 1, 0
Vignesh Kumar N