My Oracle Support Banner

Extract falsely abends with "OGG-01028 Formatting error ... Number of digits xx exceeds max xx on column" (Doc ID 1939795.1)

Last updated on MAY 14, 2021

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 <SCHEMA>.<TABLE>, rowid , XID 18.9.66509, position (Seqno 69125, RBA 10901084).
Number of digits 58 exceeds max 19 on column <COLUMN>, value: -.00000000000000000000000000000000001930363648155336532932273623312413472332513030284713294944.

 

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.