- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Delete data issue with PutdatabaseRecord
- Labels:
-
Apache NiFi
Created 05-03-2020 01:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
