Wednesday, December 27, 2017

Error:

2017-12-27 22:51:11  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, rep1.prm:  REPLICAT REP1 started.
2017-12-27 22:51:11  WARNING OGG-03504  Oracle GoldenGate Delivery for Oracle, rep1.prm:  NLS_LANG character set AL32UTF8 on the target is different from the source database character set WE8MSWIN1252. Replication may not be valid if the source data has an incompatible character for the target NLS_LANG character set.
2017-12-27 22:51:11  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, rep1.prm:  OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Aborted grouped transaction on 'DA.PMSET_TN', Database error 2291 (OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0).
2017-12-27 22:51:11  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, rep1.prm:  SQL error 2291 mapping DA.PMSET_TN to DA.PMSET_TN OCI Error ORA-02291: integrity constraint (DA.PMSET_PMPROJECT_FK) violated - parent key not found (status = 2291). UPDATE "DA"."PMSET_TN" SET "PMSET_COMP_CODE" = :a1,"PMSET_DEFAULT_PROJ_ORASEQ" = :a2,"PMSET__IU__UPDATE_DATE" = :a3,"PMSET__IU__UPDATE_USER" = :a4,"PMSET_LAST_SESSIONINFO" = :a5 WHERE "PMSET_USER" = :b0.
2017-12-27 22:51:11  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Repositioning to rba 68690185 in seqno 42.
2017-12-27 22:51:11  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, rep1.prm:  Error mapping from DA.PMSET_TN to DA.PMSET_TN.
2017-12-27 22:51:11  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, rep1.prm:  PROCESS ABENDING.


Fix:

GGSCI (oracledbprod-ro) 10> alter replicat rep1 begin now
REPLICAT altered.


GGSCI (oracledbprod-ro) 11> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     STOPPED
REPLICAT    STOPPED     REP1        00:00:00      00:00:02


GGSCI (oracledbprod-ro) 12> start manager

Manager started.


GGSCI (oracledbprod-ro) 13> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
REPLICAT    RUNNING     REP1        00:00:00      00:00:09

1 comment:

Google, Mozilla, and Apple choosing to no longer support Entrust as a publicly trusted certificate authority

Google, Mozilla, and Apple have all decided to stop trusting Entrust’s publicly issued certificates after specific cutoff dates , due to lon...