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)