1 Reply Latest reply: Apr 2, 2013 4:17 AM by albertone RSS

    Issue with Advanced Replication - ORA-01403: no data found

    albertone
      Hi,

      got into this weird issue with my replicated environment (9.2.0.5.0 on solaris). We have a bidirectionally replicated table which has been working fine for years but is now showing issues on certain records.

      We had to manually update locally some fields but that's something we did in the past, ensuring both sides were aligned, but this time it does not work.

      The two records are identical but when we try to update on one side the far end fires:

      ERROR at line 1:
      ORA-01403: no data found
      ORA-06512: at "SYS.DBMS_DEFER_SYS_PART1", line 442
      ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1854
      ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1900
      ORA-06512: at line 1

      Thoutght there could be some field out of sync, but the update we execute is quite easy:



      Records on current DBs:
      9495411494 EA10CARD 10 169 0 used 1.0000E+17 31-DEC-99 E-VOUCHER_10_CARD 28-MAR-13 12 10 949541

      9495411494 EA10CARD 10 169 0 used 1.0000E+17 31-DEC-99 E-VOUCHER_10_CARD 28-MAR-13 12 10 949541

      Trying to:


      update ucms_batches set batch_status='new' where serial_no=9495411494;
      commit;

      I see the change locally applied but I see an error reported on the far end. Could not decode the content of the user_data completely, the only thing I could get was:

      3.45.53207 0 0 ?
      OPS$SCNCRAFT? UCMS_BATCHES$RP?
      REP_UPDATE? ?A
      !? used? new?EA10CARD??Y
      7
      Y?'
      !?AE-VOUCHER_10_CARD??AF!????_`*!??!?A
      !????_`*_!?E
      !??? NSMS_MASTERDEF.RMS? N

      Is there anyway I could verify the SQL attempted on the far end with the data used to match the record?

      Thanks

      Mike