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

[Titto]

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.

[DSguru2B]

See if thispost helps.

[ray.wurlod]

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.