Skip to main content
To homepage To homepage

I am loading a table from an Oracle source with the ODX. When I load the table without an incremental selection rule, the table loads fine. But when I add an incremental rule on a datetime column (change date column in the source table) I get the error:

ORA-01861: literal does not match format string

Does the ODX server pass the correct where clause to the Oracle DB for the incremental load? Or am I doing something wrong?

Any help greatly appreciated!

Which version of TimeXtender are you using? 

Release Notes for TimeXtender 20.10.x

Fixed in ODX 20.10.4

  • 8551: Oracle fails when using date fields as incremental load in ODX on OLE DB version

This contains a new option for the ADO and OLEDB data sources called "Date and time syntax'

Options are: Default, ANSI, and ODBC.
For Oracle, you will need to set it to ANSI to get the date-time formatting to work.

@Syed Yousuf I am using version 6143.1 but your solution works fine, thank you!

Reply


Terms and ConditionsCookie settings