My Oracle Support Banner

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 FEBRUARY 19, 2019

Applies to:

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


On : version, 1 - Oracle DB backend

In replicat Version:
Oracle GoldenGate Command Interpreter for SQL Server
Version 19181440 OGGCORE_11.
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 25892308
Windows x64 (optimized), Microsoft SQL Server

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


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


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

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