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

• Microsoft SQL Server version 7.0

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 : SSrvRep kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb