Support Questions

Find answers, ask questions, and share your expertise

Delete data issue with PutdatabaseRecord

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

Rising Star

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 

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.