DATETIMEOFFSET column having positive offset's are not replicating correctly

(Doc ID 2384248.1)

Last updated on APRIL 18, 2018

Applies to:

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

Symptoms

 Replicate errors with

ERROR OGG-01296 Error mapping from dbo.tQuotes to dbo.tQuotes.

2018-01-18 13:37:07 WARNING OGG-01154 SQL error -2147217887 mapping dbo.tQuotes to dbo.tQuotes [SQL error -2147217887 (0x80040e21)]
Parameter #: 64 Data Type: 129 DB Part: 7 Length: 34 Max Length: 36 Status: 6 Precision: 34 Scale: 7 Data Overflow
Native Error: 0, 0
State: 0, 22018
Class: 0
Source: Line Number: 0
Description: Invalid character value for cast specification.

 

Changes

 

Cause

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 hundreds of Community platforms