OGG Extract Abend with GGS ERROR 190 Invalid Numeric Data Detected Error Converting Numeric from Oracle to ASCII on Column Raw Length 1, Raw Data: 0x00 (Doc ID 1316627.1)

Last updated on JANUARY 31, 2017

Applies to:

Oracle GoldenGate - Version 10.4.0.103 to 11.2.1.0.1 [Release 10.4.0 to 11.2]
Information in this document applies to any platform.
INTERNAL Checked for currency on 11-Dec-2012

Symptoms

GGS ERROR 190 Formatting error on: table name <table name>, rowid <rowid>, XID 1.234.567, position (Seqno 4321, RBA 1234567). Invalid numeric data detected. Error converting numeric from Oracle to ASCII on column <column_name>, raw length 1, raw data: 0x00.

 

select dump(<column_name>,10), vsize(<column_name>), to_char(<column_name>,'0000.9999')
from <table name> a where rowid in ('<rowid>');
DUMP(FREE_CHARGE_AMOUNT,10)
VSIZE(FREE_CHARGE_AMOUNT)
TO_CHAR(FREE_CHARGE_AMOUNT,'0000.9999')
Typ=2 Len=1: 0
1
-0000.0000

 

TRANLOGOPTIONS _CONVERTBADNUMBER ZERO



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