This discussion is archived
1 Reply Latest reply: Apr 24, 2013 9:45 PM by Rc-oracle RSS

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

690977 Newbie
Currently Being Moderated
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
    Rc-oracle Explorer
    Currently Being Moderated

    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.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points