SQL Server Replicat On OGG 12.2 Abends With ERROR OGG-10124 : Parsing error, value "-2147217887" is not one of the legal values (DEFAULT([2]?)|([-]?[0-9]{1,7})) for [spec_option].

(Doc ID 2344895.1)

Last updated on JANUARY 02, 2018

Applies to:

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

Symptoms

On : 12.2.0.1.0 version, 1 - Oracle DB backend

In replicat Version:
Oracle GoldenGate Command Interpreter for SQL Server
Version 11.2.1.0.25 19181440 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_140722.0604
Windows x64 (optimized), Microsoft SQL Server

We have the reperror parameter like this :
REPERROR (-2147217887, IGNORE)  --> This works well.

Sql_server error -2147217887 means date out of range, for example, to_date('0163-07-31','YYYY-MM-DD')

We are building a new environment with
Oracle GoldenGate Command Interpreter for SQL Server
Version 12.2.0.1.170221 25892308
Windows x64 (optimized), Microsoft SQL Server

and trying to use the same parameter REPERROR (-2147217887, IGNORE), but replicat abends with below error:

Changes

Got Error at DB level: 

Database error -2147217887 ([SQL error -2147217887 (0x80040e21)]
Parameter #: 1 Data Type: 129 DB Part: 7 Length: 23 Max Length: 29 Status: 6 Precision: 23 Scale: 3 Data Overflow
Native Error: 0, 0
State: 0, 22007
Class: 0
Source: Line Number: 0
Description: Invalid date format

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