Extract falsely abends with "OGG-01028 Formatting error ... Number of digits xx exceeds max xx on column"

(Doc ID 1939795.1)

Last updated on JULY 05, 2017

Applies to:

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

Symptoms

Extract falsely abends with below error when logminer shows no bad numeric data for the table/ XID in question

2014-05-19 17:23:37  ERROR   OGG-01028  Formatting error on: table name GG.T1586, rowid , XID 18.9.66509, position (Seqno 69125, RBA 10901084).
Number of digits 58 exceeds max 19 on column C250000034, value: -.00000000000000000000000000000000001930363648155336532932273623312413472332513030284713294944.

 

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