Support Questions

Find answers, ask questions, and share your expertise

Delete data issue with PutdatabaseRecord

avatar
Explorer

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 >>>

DuongNT_0-1588494464939.png

 

 

2 REPLIES 2

avatar
Expert Contributor

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 

avatar
Explorer

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.