You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Svyatoslav (Jira)" <ji...@apache.org> on 2020/11/14 18:45:00 UTC

[jira] [Updated] (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:all-tabpanel ]

Svyatoslav updated NIFI-8004:
-----------------------------
    Description: 
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!

  was:
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 is of type string. The corresponding field in PostgreSQL database, where PutDatabaseRecords upserts the data is of type numeric.

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

!image-2020-11-14-21-33-46-046.png!

PutDatabaseProcessor configuration:

!image-2020-11-14-21-42-25-537.png!


> 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: Major
>         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)