My Oracle Support Banner

Replicat at MSSQL Abends With Conversion Failed When Converting Character String To SmallDateTime Data Type (Doc ID 2611606.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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

Symptoms

Replicat at MSSQL abended with the following errors:

2019-10-29T10:12:10.623+0300 WARNING OGG-01004 Oracle GoldenGate Delivery for SQL Server, REPXXX.prm: Aborted grouped transaction on dbo.<tablename>, Database error 295 ([SQL error 295 (0x127)][Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Conversion failed when converting character string to smalldatetime data type.

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


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