How to Resolve ORA-01438 in GoldenGate

  • by

ORA-01438 with OGG-00869 in GoldenGate

REPLICAT was found as ABENDED in the daily check on GoldenGate. ORA-01438 with OGG-00869 is found in REPLICAT report:

2018-06-21 08:39:27 WARNING OGG-00869 OCI Error ORA-01438: value larger than specified precision allowed for this column (status = 1438), SQL <INSERT INTO "ERPAPP"."BANK_TRANS" (

ORA-01438 with OGG-01296 in GoldenGate

A similar error pattern like the above can also be found in REPLICAT report:

2018-06-21 08:39:27  ERROR   OGG-01296  Error mapping from ERPAPP.BANK_BRANCHS to ERPAPP.BANK_BRANCHS.

Let's drill down a little bit to the discard file.

OCI Error ORA-01438: value larger than specified precision allowed for this column (status = 1438), SQL <INSERT INTO "ERPAPP"."BANK_BRANCHS" ("ID", "BRANCH", ...) VALUES (:a0,:a1,...)>

Solution

I decided to import this table only to conform to the original definition.

[oracle@standby ~]$ impdp system tables=ERPAPP.BANK_BRANCHS content=all table_exists_action=replace network_link=erpapp_link exclude=statistics logfile=BANK_BRANCHS_`date +'%Y%m%d'`.log directory=data_pump_dir

Now, we can start REPLICAT again.

Please note that, I exclude STATISTICS and its related object paths to avoid bug 20345554 which is only for release 12.1.

By this solution, you should igonore ORA-00001: unique constraint violated in REPLICAT parameter file to avoid potential REPLICAT ABENDED.

Leave a Reply

Your email address will not be published. Required fields are marked *