[ 
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)

Reply via email to