DSXchange

Posted: **Sat Aug 18, 2007 11:16 pm**

Hi,

one of the job is giving the following error - any idea what is causing this error and job is failing - we checked all the column data lengths and stage variable lengths and target datatype lengths are same.

Code: Select all

APT_CombinedOperatorController(1),0: Fatal Error: APT_Decimal::compare: the left-hand-side decimal has an invalid representation.

Any info appreciated.

Posted: **Sat Aug 18, 2007 11:22 pm**

See if thispost helps.

Posted: **Sun Aug 19, 2007 12:50 am**

All zero bits is an invalid representation of a decimal data type, unless you explicitly permit it. This may be what has happened in your case. Try disabling operator combination to be certain that a Compare stage has generated this message.

DSXchange

Decimal Issue - he left-hand-side decimal has an invalid re

Decimal Issue - he left-hand-side decimal has an invalid re