You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Matt Burgess (Jira)" <ji...@apache.org> on 2021/03/11 22:16:00 UTC
[jira] [Commented] (NIFI-8004) PutDatabaseRecord doesn't route
error flow file to failure and leaves it in the input queue
[ 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)