Monday, February 21, 2011

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

When you get the error as described below:
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x000013DC0003277A006D00000000, Command ID: 2)

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
Lookup the executed command by viewing the call (see my previous post) and update the stored procedure by commenting the rowcount check
ALTER procedure [dbo].[sp_MSdel_genTokenBalance]
  @pkc1 varchar(19)
as
begin  
 delete [gen].[TokenBalance]
where [TokenNumber] = @pkc1
--if @@rowcount = 0
--    if @@microsoftversion>0x07320000
--        exec sp_MSreplraiserror 20598
end
NOTE: don't forget to restore to the original when the problem is solved.

Good luck!