Replication Error – the row was not found at the subsciber when applying the replicated command

row_not_found_at_SubscriberIts likely just one table causing this, identify the table for a start.

Get the transaction sequence command number out of the error message and to find the table – paste into this query below.

select * from dbo.MSarticles (nolock) where article_id in 
( select article_id from MSrepl_commands (nolock) where xact_seqno 
= 0x0011FE8000000531000600000000)

--And this will give you the command (and the primary key (ie the row) 
the command was executing against)

exec sp_browsereplcmds @xact_seqno_start = '0x0011FE8000000531000600000000'
, @xact_seqno_end = '0x0011FE8000000531000600000000'

Once you know what you are dealing with you can reinitialize/resnapshot the offending publication. Problem solved!

Rob StGeorge
Senior SQL Server Database Administrator residing in Auckland, NZ

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.