Wednesday, November 19, 2008

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

This error mainly occurs because the row which the distributor is trying to update is not available in the subscriber. This error can occur with Transactional Replication.

Solution is simple... find the Transaction Sequence from the Error log in the replication monitor which will be somthing like 0x00066C5300002F80004E0 and run the below command to get the corresponding article or table.

Use Distribution
GO
select * from dbo.MSarticles
where article_id IN (SELECT Article_id from MSrepl_commands
where xact_seqno = 0x00066C5300002F80004E00000000)


So once you get the article, find out the row primary key value from the error message and you will not be able to find this row in the subsrciber. So do a INSERT INTO SELECT * FROM and mind that incase the subscriber is having IDENTITY then you need to enable IDENTITY_INSERT ON for that particular table.

SET IDENTITY_INSERT tabledest ON

No comments:

Post a Comment

Please do not spam!