Duplicate entry 'XXXXX' for key 'PRIMARY'

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.


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

All 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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.