DBA Hub

📋Steps in this guide1/2

OGG-01028 Formatting error on: table name DBACLASS

Use the below parameter in your extract file to solve the error , OGG-01028 Formatting error on

oracle replicationintermediate
by OracleDba
13 views
1

Overview

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|.
2

Section 2

Add the below parameter in your extract file and start the extract. TRANLOGOPTIONS _INFINITYTOZERO TRANLOGOPTIONS _CONVERTBADNUMBER ZERO

Comments (0)

Please to add comments

No comments yet. Be the first to comment!