topic Re: Duplicate entry 'XXXXX' for key 'PRIMARY' in Talend Studio

Duplicate entry 'XXXXX' for key 'PRIMARY'

Anonymous — Sat, 16 Nov 2024 08:17:13 GMT

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.

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

TRF — Thu, 10 May 2018 12:15:09 GMT

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

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

Anonymous — Thu, 10 May 2018 13:39:29 GMT

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