Microsoft KB Archive/241511

= PRB: REPL: Msgs. 20515, 21054, or 20512 with Immediate-Updating Subscribers =

Article ID: 241511

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q241511



SYMPTOMS
When you have replication set up with immediate-updating subscribers and you attempt to update a row on the subscriber, you may receive the following error messages:

Server: Msg 20515, Level 16, State 1, Procedure sp_MSreplraiserror, Line 9

Updatable Subscribers: Rows do not match between Publisher and Subscriber. Refresh rows at Subscriber.

Server: Msg 21054, Level 16, State 1, Procedure sp_MSreplraiserror, Line 16

Updatable Subscribers: RPC to Publisher failed.

Server: Msg 20512, Level 16, State 1, Procedure sp_MSreplraiserror, Line 8

Updatable Subscribers: Rolling back transaction.



CAUSE
These messages appear if a change has been made at the publisher and that change has not appeared on the subscriber yet. These messages prevent you from making a change that would violate transactional consistency.



WORKAROUND
To work around this problem, make sure any pending changes on the publisher have been sent to the subscriber before attempting to make a new change on the subscriber.



MORE INFORMATION
For example, this problem may occur if the following sequence of events has occurred:
 * 1) One of the Agents (Logreader or Distribution) have been stopped.
 * 2) A change is made to a row on the publisher.
 * 3) A different change is attempted on the same row on the subscriber. Since one of the Agents is stopped, the change that was made on the publisher has not yet been applied at the subscriber.

Additional query words: repl

Keywords: kbprb KB241511

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.