Created 05-03-2020 01:34 AM
Hi team,
I faced the issue with PutdatabaseRecord. This processor always delete miss some record, just some records. Could you help me give some advise >>>
Created 05-04-2020 11:43 AM
Looks like there is on a table 2 or more PRIMERY_KEY columns.
You can check it with:
SHOW CREATE TABLE MYSQL_TABLE_NAME
The Problem occurs if the same value is entered for several primary key columns.
So you have to remove some of them
Created 05-04-2020 06:33 PM
Thanks for your response.
But it have only 1 primary key on my table and as i checked, just some id are not deleted @@.
Now i use PutSQL instead of PutdatabaseRecord to delete these records, it work well.