Support Questions

Find answers, ask questions, and share your expertise
Welcome to the upgraded Community! Read this blog to see What’s New!

PutDataBaseRecord does not insert any record when one of them already exists in the database


Hi everybody, please help!

I'm working in NIFI with PutDataBaseRecord to insert the data of a csv file to a database table. Everything goes well in the first execution because there is no data in the table. Then I modify the file so it contains new records and existing ones. PutDataBaseRecord fails because of existing records (primary key constraint) but it doesn´t insert the new records.

Is there any way to configure the processor to instruct it to insert the new records and ignore the ones that failed?

I attached pictures how my processor is configured.



Thanks in advance.



The above was originally posted in the Community Help track. On Sat May 11 03:14 UTC 2019, the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help track is appropriate for questions about using the HCC site itself.

Bill Brooks, Community Moderator
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.