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.