Ads

12 August 2012

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


Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000210C100000223000D00000000, Command ID: 8)


Ex:

Step 1 :-

Connect to the Distributor
select * from dbo.MSarticles
where article_id IN (SELECT Article_id from MSrepl_commands
where xact_seqno =  0x000210C100000223000D00000000 )


Step 2 :- 
 
exec sp_browsereplcmds @xact_seqno_start = '0x0013DD67000002EA007F00000000'
,@xact_seqno_end = '0x0013DD67000002EA007F00000000'
,@publisher_database_id = xxx
,@article_id = xxx
,@command_id= '8'
Step 3:- 

If data is in sync, do skip errors




For replication Errors,

select 

From distributor..MSrepl_errors

Select * from MSrepl_commands Where xact_seqno>'0x0000000000000000000000000000'

Which will give the article details and issues.


No comments:

Post a Comment