Error in transformer stage

arun_im4u · Post by **arun_im4u** » Mon Nov 07, 2005 11:40 am

Hi,

I am getting this error in one of my jobs, that was working fine till now. It doesnt give me too much info.

Error message:

Warning: XXX..Transformer_62: %s
Fatal: XXX..Transformer_62: |-100|

Any help would be great,

I tried copying the job, renaming the stages and replacing the stages with new ones. But getting the same error.

Thanks
Arun.

chulett · Post by **chulett** » Mon Nov 07, 2005 11:49 am

Have you tried resetting the job from the Director after it aborts? See if it then logs an entry labelled "From previous run..." and let us know what's in there.

arun_im4u · Post by **arun_im4u** » Mon Nov 07, 2005 12:44 pm

The problem is solved. My user-defined sql query and my table definitions were not in sync. I changed that and its working fine now.

Thanks.