Transformer : Failure during execution of operator logic

[dsedi]

Hi All,

while runing a parallel job, i am getting
fatel error
"Transformer_91,1: Failure during execution of operator logic."
i checked the design twice and found everything correct.

any idea?

Thanks in advance
Dsedi

[Jay]

Check your data types on source and target and also check if you are doing the correct type conversions.....

Are you getting any other warnings???

Jay

[dsedi]

yes!
we are using column import stage.(all columns imported only as char type)
in transformer we are Trim al the input fields
and convert the datatype of all columns as varchar or decimal(as required)

the warning msg is
"Import_trn0,1: Import consumed only 844bytes of the record's 846 bytes (no further warnings will be generated from this partition)"

Thanks
Dsedi

[Jay]

It may be that the sum of the individual fields may not equal 846. It seems it is equal to 844.

[dsedi]

Thanks Jay!

it's working now!

Dsedi