My Oracle Support Banner

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 NOVEMBER 22, 2019

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.