Error in transformer stage:decimal value out of integer rang

adasgupta123 · Post by **adasgupta123** » Thu Sep 20, 2007 2:54 am

Hi,

We are extracting data from OLTP oracle table into Dataset.
In oracle table some columns are their which are of Decimal data type.
There is a transformer stage between oracle stage and dataset stage.

In the transformer we are converting decimal data type to intrger data
type.
Though every thing was ok,for the last few days the job is getting
aborted and showing an error message:

"one_to_one_map,2: Fatal Error: APT_Decimal::asInteger: the decimal value is out of range for the integer result"

I have tried by increasing the column length.But that is not working.
Plz help

Thanks in advance.

Regards

Avik Dasgupta.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 20, 2007 4:38 pm

The largest possible (signed) integer is 2147483647. Any decimal value coming from Oracle that is bigger than this will cause the error to be generated. You may need to use a BigInt data type.

adasgupta123 · Post by **adasgupta123** » Mon Sep 24, 2007 10:51 pm

Thanks a lot .
The problem is solved

ray.wurlod wrote:The largest possible (signed) integer is 2147483647. Any decimal value coming from Oracle that is bigger than this will cause the error to be generated. You may need to use a BigInt data type. ...