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