You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Mohamad Itani (Jira)" <ji...@apache.org> on 2024/02/19 12:15:00 UTC
[jira] [Updated] (NIFI-12815) QueryDatabaseTable or GenerateTableFetch causes ORA-01861 when choosing a date field as Max-Value Column
[ https://issues.apache.org/jira/browse/NIFI-12815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mohamad Itani updated NIFI-12815:
---------------------------------
Attachment: Configuration.jpg
> QueryDatabaseTable or GenerateTableFetch causes ORA-01861 when choosing a date field as Max-Value Column
> --------------------------------------------------------------------------------------------------------
>
> Key: NIFI-12815
> URL: https://issues.apache.org/jira/browse/NIFI-12815
> Project: Apache NiFi
> Issue Type: Bug
> Components: NiFi Stateless
> Affects Versions: 2.0.0-M2
> Reporter: Mohamad Itani
> Priority: Blocker
> Attachments: Configuration.jpg
>
>
> Hi,
> We would like to build a process to extract incrementally the data of a certain table using a last_update_date column.
>
> However, when choosing the last_update_date column which is of type Date in oracle, we're facing the following ORA-018160 when NIFI tries to issue the following Select:
> QueryDatabaseTable[id=136718e8-104a-11b0-8274-016f1de2e42e] Unable to execute SQL select query SELECT * FROM TEST2 WHERE LAST_UPDATE_DATE > '2024-02-03 11:55:22.0' due to java.sql.SQLDataException: ORA-01861: literal does not match format string
> Regards,
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)