MSSQL DB Replication Error

Command attempted:

if @@trancount > 0 rollback tran

(Transaction sequence number: 0x000283BE000071F0002900000000, Command ID: 22)

 

Error messages:

The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: 20598)

Get help: http://help/20598

The row was not found at the Subscriber when applying the replicated command. (Source: MSSQLServer, Error number: 20598)

Get help: http://help/20598

 

Resolution:

Try to reinitialize Subscription from Replication monitor.

use distribution

Delete from MSrepl_commands

 where xact_seqno = 0x000283BE000071F0002900000000 and command_ID=22

 select * from MSrepl_commands

 select * from dbo.MSarticles

 where article_id in (

 select article_id from MSrepl_commands

 where xact_seqno = 0x000283BE000071F0002900000000)

 

 exec sp_browsereplcmds

 @xact_seqno_start = '0x000283BE000071F0002900000000',

 @xact_seqno_end = '0x000283BE000071F0002900000000'

 

转载于:https://www.cnblogs.com/lijavasy/p/9555664.html