Online Tutorials & Training Materials | STechies.com
Register Login

Transactional Replication Error 20598 - Missing Row on the Subscriber Side.

|| || 1

Transactional Replication Error 20598 - Missing Row on the Subscriber Side.
Stechies

Hello Experts,

Need all of your help to fix the following issue:

Transactional Replication Error 20598 - missing row on the subscriber side, there are two scenarios that are following:

1. An UPDATE command cannot be replicated because there is no record that matches the update condition on the subscriber side. 

2. A DELETE command cannot be replicated because there is no record that matches the delete condition on the subscriber side.

Please let me know your reply to solve this issue step by step.

Thanks in advance.


Comments

  • 28 Oct 2015 6:31 pm

    One option is to replicate SP execution instead of actual DELETE command. you can also create 2 diff versions of SP one on publisher that does the delete and other on subscrber that does not do the delete.

Related Articles