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 2017/08/02 03: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=16110192#comment-16110192 ] 

Matt Burgess commented on NIFI-4238:
------------------------------------

[~ella] this might be a configuration issue, can you share the configuration of the QueryDatabaseTable processor? If you are using the Generic database adapter, it is possible that DB2 requires a specific dialect for paging results (see NIFI-3596). If so, we could convert this to a "support DB2 in NiFi DB Fetch processors" Jira, where the workaround could be to rewrite the SQL as described in NIFI-3596.

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