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 MAY 26, 2021

Applies to:

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

Symptoms

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



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


Changes

 

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
Changes
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.