4 Replies Latest reply: Feb 19, 2013 8:08 AM by 441858 RSS

    Streams dba_apply_error table rows

    441858
      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
          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
            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
              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
                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.