Page 1 of 1

Transformer detected

Posted: Wed Dec 29, 2004 4:49 am
by nkln@you
I have a source DRS stage A , it is connected to a transformer Tr, and TR is connected to two target DRS stages B,C. When i run the job, in director i observed the following:

trace mode =0 for transformer.
then sql in A got executed.
then sql in B got executed.
then sql in c got executed.
then a warning occurreed saying "Tr detected".

What is this error and how can we rectify this.

Actuall the same job ran fine in one project. When i exported and imported into another project, this warning occurred. All parameters are set up in this new project.

Posted: Wed Dec 29, 2004 8:35 am
by chulett
Usually, errors are 'detected' in your Transformers as they are the primary active stages in jobs. You'll need to post the actual error message before anyone can help you, however.

You can also try resetting (not recompiling) the job after it fails and see if it puts anything in the log labelled as 'From last run'. If it does, post that here as well.

Posted: Wed Dec 29, 2004 2:51 pm
by ray.wurlod
And you must post the entire message. There is no such message as "TR detected". It probably says something like "abnormal termination of stage TR detected".
Without the entire message your question is like "My car is. Can you fix it?" Not helpful, is it?