Page 1 of 1

Transformer : Failure during execution of operator logic

Posted: Wed Jan 26, 2005 5:21 pm
by 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

Posted: Wed Jan 26, 2005 5:44 pm
by 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

Posted: Wed Jan 26, 2005 5:54 pm
by 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

Posted: Wed Jan 26, 2005 6:15 pm
by Jay
It may be that the sum of the individual fields may not equal 846. It seems it is equal to 844.

Posted: Wed Jan 26, 2005 6:44 pm
by dsedi
Thanks Jay!

it's working now!

Dsedi