Problem:

Goldengate extract may abend with the error OGG-01028  Formatting error on.

 

Source Context :

  SourceModule            : [er.redo.ora]

  SourceID                : [/scratch.local/mmar/view_storage/mmar_14516066/oggcore/OpenSys/src/app/er/redo/oracle/redoora.c]

  SourceFunction          : [REDOORA_handle_format_error SourceLine              : [8949]

2016-03-30 18:13:34  ERROR   OGG-01028  Formatting error on: table name SIEBEL.S_CONTACT, rowid AABjIBAAgAAC/svAAL, XID 12.16.3440952, position (Seqno 7643, RBA 541369824). Invalid numeric data detected. Error converting numeric from Oracle to ASCII on column X_DUP_ID_SEQ, raw length 1, raw data: 02184FD0: 4e |N|.

 

 

Solution:

 

Add the below parameter in your extract file and start the extract.

 

TRANLOGOPTIONS _INFINITYTOZERO

TRANLOGOPTIONS _CONVERTBADNUMBER ZERO