[
https://issues.apache.org/jira/browse/NIFI-6409?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16880783#comment-16880783
]
Matt Burgess commented on NIFI-6409:
------------------------------------
PutSQL has a check to call setNull() where PutDatabaseRecord does not. As a
(non-ideal) workaround you can try SplitRecord (into JSON) -> ConvertJSONToSQL
-> PutSQL, it won't be performant but it should get you around the rollback
issue.
PutDatabaseRecord should check for null at appropriate times and at least call
setNull then. Consider putting it in a try/catch and attempting setObject()
with a null type as a fallback, then letting any exception propagate afterward.
> Error inserting null fields in Teradata (through JDBC)
> ------------------------------------------------------
>
> Key: NIFI-6409
> URL: https://issues.apache.org/jira/browse/NIFI-6409
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.8.0
> Reporter: Guillermo Chico
> Priority: Critical
> Labels: Nifi
> Attachments: ErrorNull.png, PutDatabaseRecord.PNG, TeradataPool.jpg
>
>
> Hi,
> I'm trying to insert data in a Teradata database using PutDatabaseRecord
> processor. The process is fine until one record (input field) is null. Then
> the entire insertion batch get an error and do rollback of the transaction.
> Error capture: !ErrorNull.png!
> Attached the configuration info:
> -Processor: !PutDatabaseRecord.PNG!
> -Pool: !TeradataPool.jpg!
> Any idea about how can I resolve this error?
>
> Thank you in advance,
> Guillermo Chico
>
>
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
