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

[#1]

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.

[#2]

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.