Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

Labels (3)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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

View solution in original post

2 Replies
TRF
Champion II
Champion II

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

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