When checking operator: Dropping component

Prakash3366 · Post by **Prakash3366** » Tue Oct 27, 2009 5:11 am

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

chulett · Post by **chulett** » Tue Oct 27, 2009 5:41 am

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.

Prakash3366 · Post by **Prakash3366** » Tue Oct 27, 2009 11:44 pm

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

gssr · Post by **gssr** » Wed Oct 28, 2009 12:29 am

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

ArndW · Post by **ArndW** » Wed Oct 28, 2009 2:00 am

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?

Prakash3366 · Post by **Prakash3366** » Thu Oct 29, 2009 12:36 am

In transformer i am facing this issue.

Thanks
Prakash

samyamkrishna · Post by **samyamkrishna** » Wed Nov 04, 2009 2:04 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Nov 04, 2009 2:37 am

Is dat_maj_socl referred to twice (or more)?

samyamkrishna · Post by **samyamkrishna** » Wed Nov 04, 2009 3:42 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Nov 04, 2009 4:33 am

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

samyamkrishna · Post by **samyamkrishna** » Wed Nov 04, 2009 4:39 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Nov 04, 2009 4:40 am

And the error message ID ?

samyamkrishna · Post by **samyamkrishna** » Wed Nov 04, 2009 4:47 am

There is no error message id in the warning.

or where will i find it?

Thanks,
Samyam

samyamkrishna · Post by **samyamkrishna** » Wed Nov 04, 2009 5:23 am

Does this have to do anything with partitioning

Thanks,
Samyam

patelamit009 · Post by **patelamit009** » Tue Sep 27, 2011 3:52 am

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.

DSXchange

When checking operator: Dropping component

When checking operator: Dropping component

Re : When checking operator: Dropping component