"[SQLServer JDBC Driver][SQLServer]The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value" Error when Loading Data into SQL Server Database (Doc ID 3017808.1)

Last updated on APRIL 25, 2024

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.220112 and later
Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

While loading data into SQL Server Database using Oracle Data Integrator (ODI) Mapping, the execution fails with below error:

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!

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

"[SQLServer JDBC Driver][SQLServer]The conversion of a datetimeoffset data type to a datetime data type resulted in an out-of-range value" Error when Loading Data into SQL Server Database (Doc ID 3017808.1)

Applies to:

Symptoms

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!