Decimal value is out of range
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Thu Feb 02, 2012 11:23 pm
Decimal value is out of range
Hi Experts..
I imported a SCD job in 8.5 from 8.1
Job Desc: Input datasets--->SCD stage-->Ouput Datasets.
Here,only 1 colmun in lkp dataset is decimal type as(decimal[38,0]) and rest are Varchar.That decimal column also contains negative value for some records.
On running the job in 8.5 it is throwing error as:
APT_CombinedOperatorController(1),0: Fatal Error: APT_Decimal::asIntegerU64: the decimal value is out of range for the integer result.
While this job is running fine in 8.1
Plz give some clue to fix this issue.
Thanx in advance...
I imported a SCD job in 8.5 from 8.1
Job Desc: Input datasets--->SCD stage-->Ouput Datasets.
Here,only 1 colmun in lkp dataset is decimal type as(decimal[38,0]) and rest are Varchar.That decimal column also contains negative value for some records.
On running the job in 8.5 it is throwing error as:
APT_CombinedOperatorController(1),0: Fatal Error: APT_Decimal::asIntegerU64: the decimal value is out of range for the integer result.
While this job is running fine in 8.1
Plz give some clue to fix this issue.
Thanx in advance...
If you look at the error message it states that the problem is occuring while converting from APT_Decimal to IntegerU64. This is an unsigned big integer and I suspect you are forcing this conversion somewhere.
- Check the datatypes to ensure that you aren't forcing this conversion
- Turn off operator combination ($APT_DISABLE_COMBINATION to "true" in the job parameters) to determine exactly which stage is triggering the error.
- Check the datatypes to ensure that you aren't forcing this conversion
- Turn off operator combination ($APT_DISABLE_COMBINATION to "true" in the job parameters) to determine exactly which stage is triggering the error.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Thu Feb 02, 2012 11:23 pm
How is that column being used in your SCD stage?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Thu Feb 02, 2012 11:23 pm
Looks like you have hit on a limitation in the stage. Can you convert the decimal to a string prior to the SCD stage and see if that works?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 9
- Joined: Thu Feb 02, 2012 11:23 pm
Ya..on converting the decimal column to integer or string ,it is working fine...ArndW wrote:Looks like you have hit on a limitation in the stage. Can you convert the decimal to a string prior to the SCD stage and see if that works? ...
But i don't want to do any such conversion..because other jobs with similar conditions are working fine in 8.5.Plz suggest me why this issue is coming with this job in 8.5 as it is working fine in 8.1
-
- Participant
- Posts: 9
- Joined: Thu Feb 02, 2012 11:23 pm
This is a case for your support provider, as the functionality does seem to have changed and you have a good test case/example for the problem. Unless support comes up with a solution, you will probably have to use a conversion to string or similar in any case.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>