Re: Replication error 100

A couple of things you might look at:

  Do you have execute_as_user set to true - if not, you'll be trying to execute the update at site B as the same user who initiated the transaction at site A. If you set execute_as_user to true, then the update at site B will probably be done by repadmin, depending on how you've set up your replication environment. You might also want to verify that repadmin has execute_any_procedure granted it. Those are the only 2 things that I can think of right off the top of my head - if you can provide additional information, maybe I can come up with some more. We're right in the middle of a symmetric replication project ourselves, so I'm sure we've some of the same stuff you have. Feel free to email me!

Steve

B.Yim <yimfam_at_pc.jaring.my> wrote in article <5grck9$3al_at_news2.jaring.my>...
> We have implemented multi-masters symmetric replication, however
> updates is only from one direction, from the master definition
> site A to site B.
>
> At site B sys.deferrors shows that there are deferred calls error. The
>
> error number is 100, but the error_msg shows "ORA-1043 No data found".
>
> The errors are generated by replication update procedures, i.e
> table_name$rp.rep_update. On analysis of the arguments, I have
> determined that all the rows in that are to be updated, but failed
> with this error, does exist at site B. So why doesn't replication
> applies the update? Anyone encountered such errors before? Is there a
> bug?
>
>
  Received on Fri Mar 21 1997 - 00:00:00 CST