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

  • Article

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

Step 1 : Copy the sequence number in the error and  execute the below command in distributor server

Use Distribution

GO

select * from dbo.MSarticles

where article_id IN (SELECT Article_id from MSrepl_commands

where xact_seqno = 0x0000001900000104001100000000)

Step 2:  open cmd  run as a adminstrator

tablediff.exe -sourceserver SERVER1 -sourcedatabase POD -sourcetable GLNRL -sourceschema dbo -sourcelocked -destinationserver SERVER5 -destinationdatabase RPOD -destinationtable GLNTRL  -destinationschema stg -destinationlocked -f c:\temp\TableDiff_txt.txt

If publisher and subscriber has different schema then use EXCEPT parameter to find out the difference in both tables, generate the rows and insert on subscriber

Step3: open the file c:\temp\TableDiff_txt.txt

Step 4. Stop the distributor agent and run the querys on the subscriber

Step 5: Start the Distributor Agent

Step 6: Verify the replication.