APT_Decimal error in transformer
Posted: Thu Jun 20, 2013 7:44 am
Hi,
I am running a parallel job which is reading a fixed width sequential file, passed it to transformer for trasformation and writting to a delimited sequntial file. At runtime it is giving following warning for some records .
PXmfCR01_AS,1: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record sent to reject dataset.
I could find out the rejected records through reject link from transformer, but I am not able to figure out which filed is causing this issue. By looking at rejected data, everything looks good.
By searching on google I found an environment variable $APT_CHECK_DECIMAL_VALIDITY which can help somewhat to identify which column is causing this issue. But I am not finding this variable in my project.
Could anyone help me to debug this issue.
Thanks,
Maulik
I am running a parallel job which is reading a fixed width sequential file, passed it to transformer for trasformation and writting to a delimited sequntial file. At runtime it is giving following warning for some records .
PXmfCR01_AS,1: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record sent to reject dataset.
I could find out the rejected records through reject link from transformer, but I am not able to figure out which filed is causing this issue. By looking at rejected data, everything looks good.
By searching on google I found an environment variable $APT_CHECK_DECIMAL_VALIDITY which can help somewhat to identify which column is causing this issue. But I am not finding this variable in my project.
Could anyone help me to debug this issue.
Thanks,
Maulik