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 8.1.1.7 SIA [21238] and later
Information in this document applies to any platform.

Symptoms

On : 8.1.1.7 SIA [21238] version, Universal Customer Master

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

EXPECTED BEHAVIOR
-----------------------
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.

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

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

Cause

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