1 Reply Latest reply: Apr 25, 2013 4:45 AM by Rc-Oracle RSS

    STREAMS Apply errors in apply queue ORA-02291: integrity constraint

      Hi friend,

      one of my streams replication node is not getting updated from the Soure(MATSER DB node) in streams replication and
      I see lots of apply errors showing in the apply queue.

      i get the below error in streams logs
      when i query dba_apply view for apply_Errors.

      can anyone help me how to fix this issue and catchup the replication again?
      is it related to conflict handlers??

      Apply Local Messages in
      Process Source Transaction Error
      Name Database ID Error Number Error Message Transaction
      ---------- ---------- ----------- ------------ -------------------------------------------------- -----------
      JDDB1_APP JDDB1.WORL 7.6.1197233 2091 ORA-02291: integrity constraint (R6.FK_ACCOUNT_SVC 1
      D _PACKAGE) violated - parent key not found

      JDDB1_APP JDDB1.WORL 4.32.123221 2091 ORA-02291: integrity constraint (R6.FK_USR_ACCOUNT 3
      D 3 ) violated - parent key not found

      JDDB1_APP JDDB1.WORL 1.8.1032939 2091 ORA-02291: integrity constraint (R6.FK_ACCOUNT_SVC 1
      D _PACKAGE) violated - parent key not found                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       
        • 1. Re: STREAMS Apply errors in apply queue ORA-02291: integrity constraint

          Streams Apply processes cannot coordinate the application of LCRs for dependent tables across multiply Apply processes. This has the consequence that when tables have foreign key relationships and the DML changes for these tables are Captured by distinct Capture processes that they will be applied out of order by the different Apply processes which could result in a ORA-2291 errors. This behaviour is expected.