[
https://issues.apache.org/jira/browse/NIFI-12815?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17829694#comment-17829694
]
Jim Steinebrey commented on NIFI-12815:
---------------------------------------
The first thing to try to fix the issue is to set the QueryDatabaseTable (or
GenerateTableFetch)
property called Database Type to:
Oracle 12+ if you are using Oracle 12.0 or higher
and set it to
Oracle if you are using Oracle 11.X or lower
The Database Type is used for generating database-specific SQL statements. In
many cases the Generic database type suffices, but some databases (such as
Oracle) require custom SQL clauses.
If that does not fix this issue, please tell us which version of Oracle you are
using and the SQL table definition you are trying to read from. You can modify
the columns names except the LAST_UPDATE_DATE to protect the IP. Is
LAST_UPDATE_DATE really a column of type DATE or is it TIMESTAMP?
> 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)
