APT_Decimal error in transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mauliklm
Participant
Posts: 1
Joined: Tue Nov 25, 2008 11:50 pm

APT_Decimal error in transformer

Post by mauliklm »

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
Thanks & Regards
Maulik L Mehta
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Go ahead and simply add it.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply