[
https://issues.apache.org/jira/browse/NIFI-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17299903#comment-17299903
]
Matt Burgess commented on NIFI-8004:
------------------------------------
Does this work for INSERT and/or UPDATE, or does it fail for the same reason as
UPSERT?
> PutDatabaseRecord doesn't route error flow file to failure and leaves it in
> the input queue
> -------------------------------------------------------------------------------------------
>
> Key: NIFI-8004
> URL: https://issues.apache.org/jira/browse/NIFI-8004
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.12.1
> Reporter: Svyatoslav
> Priority: Critical
> Attachments: image-2020-11-14-21-30-56-114.png,
> image-2020-11-14-21-32-12-673.png, image-2020-11-14-21-33-46-046.png,
> image-2020-11-14-21-42-25-537.png
>
>
> Input flow file is in Avro format, contains array of records, one of them
> with following fields
> !image-2020-11-14-21-32-12-673.png!
> 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:
> !image-2020-11-14-21-33-46-046.png!
> PutDatabaseRecord processor configuration:
> !image-2020-11-14-21-42-25-537.png!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
