Five Stars

Duplicate entry 'XXXXX' for key 'PRIMARY'

Hi,

 

When I'm copying records from one database to another database (Source & destination - mysql database) I'm getting "Duplicate entry 'XXXXX' for key 'PRIMARY'".  In tMysqlOutput I mentioned Action of data : "Update or Insert" but still I'm getting duplicate entry error. Someone Please help me.

Thanks,

Nehru.

1 ACCEPTED SOLUTION

Accepted Solutions
Forteen Stars TRF
Forteen Stars

Re: Duplicate entry 'XXXXX' for key 'PRIMARY'

Are you sure the field you mentionned as the primary key in the tMysqlOutput component matches with the primary key on the database side?

TRF
2 REPLIES
Forteen Stars TRF
Forteen Stars

Re: Duplicate entry 'XXXXX' for key 'PRIMARY'

Are you sure the field you mentionned as the primary key in the tMysqlOutput component matches with the primary key on the database side?

TRF
Five Stars

Re: Duplicate entry 'XXXXX' for key 'PRIMARY'

Thanks alot, Actually I missed some primary keys in database but mentioned in Map