DSXchange

HI All,

I am having a problem

Tr_DAT_MAJ_SOCLE: When checking operator: Dropping component "DAT_MAJ_SOCL" because of a prior component with the same name.

Could you let me know , for what reason we are getting this warning.

Thanks
Prakash

First question is always going to be - have you searched here for a portion that message? You're not the first person to have this issue.

My problem was not resoved by searching in the forum. So again i posted in the form..
Please send me the suggestion for this problem

Thanks
Prakash

As the message itself clearly tells you, there is a column name that is similar in the two links that you have used. Try the message handler to avoid the message

I prefer not to hide the cause of the problem by using a message handler but to correct the issue. What type of stage is producing this error?

In transformer i am facing this issue.

Thanks
Prakash

the job design is as given below.

[dataset] ----> [Transformer] --------> [Teradata enterprise stage]

the error message is
"Tr_DAT_MAJ_SOCLE: When checking operator: Dropping component "DAT_MAJ_SOCL" because of a prior component with the same name"


The column dat_maj_socl is not present in the dataset.
but in the transformer and Teradata table it is present.
in transformer we are giving dat_maj_socl as StringToTimestamp(L_TIMESTAMP,"%yyyy-%mm-%dd %hh:%nn:%ss")

This warning dosent make sense because there is no other component with the same name and this column is being added in the transformer with above given definition.

I dont even know from where to start.

Need help

Thanks in advance

Is dat_maj_socl referred to twice (or more)?

no its refered only once.

dataset does not have dat_maj_socl
in transformer we are adding teh column dat_maj_socl with StringToTimestamp(L_TIMESTAMP,"%yyyy-%mm-%dd %hh:%nn:%ss")

in teradata we load dat_maj_socl which is comming from transformer.

Thanks,
Samyam

Please post the complete detail of the error message, including the error message ID.

Tr_DAT_MAJ_SOCLE: When checking operator: Dropping component "DAT_MAJ_SOCL" because of a prior component with the same name.

it is a warning.

Thanks
Samyam

And the error message ID ?

There is no error message id in the warning.

or where will i find it?

Thanks,
Samyam

Does this have to do anything with partitioning

Thanks,
Samyam

Hi All,

I was also facing the similar kind of error message in one of my job development in transformer stage as below.

Transformer_113: When checking operator: On output data set 0: Dropping component "keyChange" because of a prior component with the same name.

I tried all options that were suggested in the thread and i wasnt successful. Finaly, i realised the problem was due to RCP enabled in the job level. After unchecking it, i get rid of the error.

But, any one could help me out to understand how RCP related to this error ?

Thanks in advance.