[
https://issues.apache.org/jira/browse/NIFI-8004?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17845088#comment-17845088
]
Jim Steinebrey edited comment on NIFI-8004 at 5/9/24 6:15 PM:
--------------------------------------------------------------
I could not reproduce this error when I set up a NiFi flow with the same
conditions.
So I looked in the code and found that NIFI-8146 changed one of the catch
statements in onTrigger from SQLException to Exception which fixed this ticket.
was (Author: JIRAUSER303705):
I could not reproduce this error when I set up a NiFi flow with the same
conditions.
So I looked in the code and found that NIFI-8146 changed one of the catch
statements in onTrigger from SQLException to Exception which would fixed this
ticket.
> 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
> Fix For: 1.13.0
>
> 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.20.10#820010)
