[NIFI-8004] PutDatabaseRecord doesn't route error flow file to failure and leaves it in the input queue

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.12.1
• Fix Version/s: 1.13.0
• Component/s: Core Framework
• Assignee: Unassigned
• Reporter: Svyatoslav
• Created: 14/Nov/20 18:43
• Updated: 09/May/24 18:15
• Resolved: 09/May/24 18:15

Description

Input flow file is in Avro format, contains array of records, one of them with following fields

Field in line 124 (let's name it f124) in one of the records contains string value. The corresponding field in PostgreSQL database, where PutDatabaseRecords upserts the data is of type numeric.

PutDatabaseRecord writes errors to the bulletin board, but the flow file causing error doesn't route to failure and stays in the input queue:

PutDatabaseRecord processor configuration:

Issue Links

• duplicates: NIFI-8146 Allow RecordPath to be used for specifying operation type and data fields when using PutDatabaseRecord