I am facing the error 20598 with Transactional Replication:
The row was not found at the Subscriber when applying the replicated command.
Normally this error occurs when an
DELETE statement is executed by the publisher for a primary key value and the record (against which UPDATE/DELETE executed) does not exist in the subscriber database.
But in my case the scenario is different.
I diagnosed and found the record exists in the article/table of subscriber database, because when I executed the command (retrieved with help of
sp_browsereplcmds) at the subscriber it executed successfully.
What may be the possible reason of it?
I'm using SQL Server 2016 both side.