Error in transformer stage:decimal value out of integer rang
Posted: 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.
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.