3 Replies Latest reply: Mar 18, 2014 6:49 PM by Nick.W-Oracle RSS

    Urgent help -- Bi-direcitonal replicat ABEND

    user530956

      we are doing the bi-directional replication, through batch jobs we are loading the data on both sides  and both GG replicate has been stopped with  violated - parent key not found error.

      Tables are in parent and child relationship and supplemental redo log is enabled only to  primary key column in all tables but not to unique key columns

      Looks like parent key data is not replicating first.

       

       

      replicat error on node 1

       

      2014-03-13 16:49:41  WARNING OGG-00869  OCI Error ORA-02291: integrity constraint (ZFF.FK55CD404D69DD1212) violated - parent key not found (sta

      tus = 2291). INSERT INTO "ZFF"."ZFF_USTGHT_SNATACTION" ("USTGHT_SNATACTION_ID","SNAT_DATE","SNAT_ID","USTGHT_ACTION","ZFFUSTGHT_USTGHT_ID")

      VALUES (:a0,:a1,:a2,:a3,:a4).

       

      2014-03-13 16:49:41  WARNING OGG-01004  Aborted grouped SNATaction on 'ZFF.ZFF_USTGHT_SNATACTION', Database error 2291 (OCI Error ORA-02291:

      integrity constraint (ZFF.FK55CD404D69DD1212) violated - parent key not found (status = 2291). INSERT INTO "ZFF"."ZFF_USTGHT_SNATACTION" ("UST

      GHT_SNATACTION_ID","SNAT_DATE","SNAT_ID","USTGHT_ACTION","ZFFUSTGHT_USTGHT_ID") VALUES (:a0,:a1,:a2,:a3,:a4)).

       

      2014-03-13 16:49:41  WARNING OGG-01003  Repositioning to rba 343990778 in seqno 41.

       

      replicat error on node 1

       

      2014-03-13 18:39:10  WARNING OGG-00869  OCI Error calling OCITransCommit (status = 2091-ORA-02091: transaction rolled back

      ORA-02291: integrity constraint (AQQ.FK2FDEE7DC69DD1212) violated - parent key not found), SQL<Not available>.

       

      2014-03-13 18:39:10  WARNING OGG-01003  Repositioning to rba 320838374 in seqno 36.

       

       

       

       

       

      view param EXTGG1

       

      EXTRACT extgg1

      setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

      setenv (ORACLE_HOME=/ora/app/oracle/product/11.2.0/db_1)

      USERID ggate, PASSWORD ggate

      EXTTRAIL ./dirdat/e1

      DISCARDFILE ./dirrpt/extggw1t.dsc, Append

      DDL INCLUDE MAPPED

      ReportCount Every 30 Minutes, Rate

      TRANLOGOPTIONS EXCLUDEUSER ggate

       

      TABLE ZFF.ZFF_USTGHT;

      TABLE ZFF.ZFF_USTGHT_SNATACTION;

      TABLE ZFF.ZFF_USTENGER;

      TABLE ZFF.ZFF_USTENGER_DATA;

      TABLE ZFF.ZFF_SNATACTION;

       

       

       

       

      view param REPGGW2

       

      REPLICAT repgg2

      setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

      setenv (ORACLE_HOME=/ora/app/oracle/product/11.2.0/db_1)

      USERID ggate@GGWYY1T, PASSWORD ggate

      --HandleCollisions

      AssumeTargetdefs

      Report at 02:00

      ReportCount Every 120 minutes, Rate

      ReportRollover at 02:00

      Discardfile ./dirrpt/repggw2.DSC, Append

      DiscardRollover at 02:00 ON SUNDAY

      DDL

       

      MAP  ZFF.*, TARGET ZFF.*;

       

       

       

      view param EXTGGW2

       

      EXTRACT extggw2

      setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

      setenv (ORACLE_HOME=/ora/app/oracle/product/11.2.0/db_1)

      USERID ggate, PASSWORD ggate

      EXTTRAIL ./dirdat/e1

      DISCARDFILE ./dirrpt/extggw2t.dsc, Append

      DDL INCLUDE MAPPED

      ReportCount Every 30 Minutes, Rate

      TRANLOGOPTIONS EXCLUDEUSER ggate

      TABLE ZFF.ZFF_USTGHT;

      TABLE ZFF.ZFF_USTGHT_SNATACTION;

      TABLE ZFF.ZFF_USTENGER;

      TABLE ZFF.ZFF_USTENGER_DATA;

      TABLE ZFF.ZFF_SNATACTION;

       

       

       

      view param REPGG1

       

      REPLICAT repgg1t

      setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)

      setenv (ORACLE_HOME=/ora/app/oracle/product/11.2.0/db_1)

      USERID ggate, PASSWORD ggate

      HandleCollisions

      AssumeTargetdefs

      Report at 02:00

      ReportCount Every 120 minutes, Rate

      ReportRollover at 02:00

      Discardfile ./dirrpt/repggw1.DSC, Append

      DiscardRollover at 02:00 ON SUNDAY

      DDL

       

      MAP  ZFF.*, TARGET ZFF.*;

       

      please advise asap...