You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "bruce lowther (JIRA)" <ji...@apache.org> on 2017/09/07 19:05:00 UTC

[jira] [Commented] (NIFI-4238) Error in QueryDatabaseTable (NiFi CDC support): Unable to execute SQL select query due to org.apache.nifi.processor.exception.ProcessException: Error during database query or conversion of records to Avro

    [ https://issues.apache.org/jira/browse/NIFI-4238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16157454#comment-16157454 ] 

bruce lowther commented on NIFI-4238:
-------------------------------------

I am also experiencing this issue with SQLITE.


> Error in QueryDatabaseTable (NiFi CDC support): Unable to execute SQL select query due to org.apache.nifi.processor.exception.ProcessException: Error during database query or conversion of records to Avro
> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: NIFI-4238
>                 URL: https://issues.apache.org/jira/browse/NIFI-4238
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.3.0
>         Environment: Centos
>            Reporter: Ella
>         Attachments: config_file_1.png, config_file_2.png, config_file_3.png, diagram.png, Error.png
>
>
> Hi Guys,
> I should retrieve only the new added records from the DB2 database to a file by NiFi's CDC feature--QueryDatabaseTable processor; however, I have encountered the Error during executing my dataflow scenario. I have respectfully attached the snapshot of Error as well as the dataflow; I would really appreciate if someone helped me after all.
> Thanks a lot.
> Sincerely,
> Ella



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)