The row was not found at the Subscriber when applying the replicated command

Error:
The row was not found at the Subscriber when applying the replicated command
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0013DD67000002EA007F00000000, Command ID: 1)

Solution:
The error is beacuse an update or delete statement cannot find rows in the subscriber database.

Execute the below command in the distribution database to find the row which its trying to access. Check if this row is existing in the subscriber database.

exec sp_browsereplcmds @xact_seqno_start = ‘0x0013DD67000002EA007F00000000’
,@xact_seqno_end = ‘0x0013DD67000002EA007F00000000’
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= ‘1’

You could also try the below query & check for command id 1

select * from dbo.MSarticles
where article_id IN (SELECT Article_id from MSrepl_commands
where xact_seqno = 0x0013DD67000002EA007F00000000)

It is probably because someone might have deleted that row from the subscriber.

Or

Enable -OutputVerbloseLevel to 2 in the distribution agent & get the exact statement.

Leave a Reply

Your email address will not be published. Required fields are marked *