EIM Process Failure ODBC error S1000: [DataDirect][ODBC Oracle driver][Oracle]ORA-01841: (full) year must be between -4713 and +9999, and not be 0

(Doc ID 1680124.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Enterprise Integration Manager - Version SIA [21238] and later
Information in this document applies to any platform.


On : SIA [21238] version, Universal Customer Master

While running an EIM job to import 8188 records, only 3188 got fully imported. The remaining 5000 were partially imported only.

The business expected that all data be fully imported as they did not see any particular difference in the data that got imported and the data that did not get imported in full.

The issue can be reproduced at will with the following steps:
1. Just run this particular EIM task on this particular data set.

The issue has the following business impact:
Due to this issue, users cannot fully import the data


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms