This discussion is archived
4 Replies Latest reply: Feb 19, 2013 6:08 AM by 441858 RSS

Streams dba_apply_error table rows

441858 Newbie
Currently Being Moderated
Oracle 11gR2 OELinux 5 64 bit
Streams local capture

Hi,

I'm not sure what may have caused the issue, but all of a sudden I am seeing thousands of errors in the dba_apply_error table. Many failures for UPDATES, INSERTS and DELETES. The update handlers that I had configured originally are no longer working.
The main concern to me is that the table keeps growing as if it keeps trying to apply records in a loop.
select count(*) from dba_apply_error;

  COUNT(*)
----------
     83283

sys> /

  COUNT(*)
----------
     83284

sys> /

  COUNT(*)
----------
     83296

sys> /

  COUNT(*)
----------
     83297
Any ideas as to what may be causing this?

Even if I delete the transactions that are trying to be applied, it starts to grow again.
  • 1. Re: Streams dba_apply_error table rows
    mseberg Guru
    Currently Being Moderated
    Try getting more information and post it


    select MESSAGE_NUMBER, ERROR_NUMBER,ERROR_MESSAGE from dba_apply_error;


    Best Regards

    mseberg
  • 2. Re: Streams dba_apply_error table rows
    441858 Newbie
    Currently Being Moderated
    The errors that are reported in the table are the following:
    ORA-26787 The row with key... does not exist in the table <table_name>
    ORA-01403: no data found
    
    ORA-26786: A row with key... exits but has conflicting columns <column_list> in table <table_name>
    ORA-01403: no data found
    These errors are repeated over and over again.

    I don't want to post the complete output because its about 80,000 rows.

    As I mentioned, have created update conflict handlers for many of the tables and the errors were OVERIDDEN. But it seems like it is not working.
  • 3. Re: Streams dba_apply_error table rows
    mseberg Guru
    Currently Being Moderated
    OK

    Thanks!

    Refer to this MOS note :

    Master Note for Troubleshooting Streams Apply Errors ORA-1403, ORA-26787 or ORA-26786,Conflict Resolution [ID 265201.1]


    Plus

    http://docs.oracle.com/cd/E11882_01/server.112/e17069/strms_trapply.htm#CEGICDJB

    http://docs.oracle.com/cd/B28359_01/server.111/b28322/troub_rep.htm#CEGICDJB

    Streams Recommended Patches [ID 437838.1]

    Master Note for Streams Recommended Configuration [ID 418755.1]

    Best Regards

    mseberg

    Edited by: mseberg on Feb 14, 2013 11:42 AM
  • 4. Re: Streams dba_apply_error table rows
    441858 Newbie
    Currently Being Moderated
    Thanks for your reply msberg.

    I actually have seen those notes.

    I was just wondering what could be causing those errors to keep on occuring non-stop even after I delete them. I understand that there are some conflicts occurring, but why does it keep on going? Strange.

Legend

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