My Oracle Support Banner

Sql Server replicat- [ODBC Driver 13 for SQL Server]Invalid character value for cast specification. (Doc ID 2741826.1)

Last updated on FEBRUARY 10, 2021

Applies to:

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

Symptoms

The MSSQL replicat was failing with the following error

2020-09-16 18:04:27 WARNING OGG-00869 [SQL error 0 (0x0)][Microsoft][ODBC Driver 13 for SQL Server]Invalid character value for cast specification.
2020-09-16 18:04:27 WARNING OGG-01151 Error mapping from <schema>.<Table> to <schema>.<Table>.

This is a replication from Db2 to Mssql using 19.1.0.0.200204

The specified record shows

Column 3 (x0003), Len 10 (x000a)
0000 3131 2e34 352e 3030 | ..11.45.00 ==========>

The column in source db2 was with time datatype

COLN TIME DEFAULT NULL



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