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 APRIL 18, 2023

Applies to:

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

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.

	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

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