Solved

Incremental load on Oracle fails with ORA-1830

  • 16 February 2023
  • 2 replies
  • 54 views

Userlevel 2
Badge +1

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!

icon

Best answer by Syed Yousuf 16 February 2023, 17:23

View original

2 replies

Userlevel 3
Badge +3

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.

Userlevel 2
Badge +1

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

Reply