My Oracle Support Banner

SQL Error -2147217887 On Datetime2 Column (Doc ID 2523059.1)

Last updated on APRIL 09, 2020

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.3.0.1.3 version, 2 - Non Oracle DB backend

12.3GG mysql to SQL server failed to SQL error -2147217887 on datetime2 column

Replicating data from mysql to sql server.
Replication failed on a table with datetime2 columns as below -
Date value was showing as 2000-17-10 13:12:56.000 instead of 2017-10 13:12:56.000 .


[SQL error -2147217887 (0x80040e21)]
Parameter #: 6 Data Type: 129 DB Part: 7 Length: 23 Max Length: 29 Status: 2 Precision: 23 Scale: 3 Can't Convert Value
Native Error: 0, 0
State: 0, 22018
Class: 0
Source: Line Number: 0
Description: Invalid character value for cast specification


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.