Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication SYNC Error Expand / Collapse
Posted Sunday, June 16, 2013 2:34 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 8:40 PM
Points: 57, Visits: 1,163
I have setup a new replication via backup and restore but its giving me two errors first

"the row was not found at the subscriber when applying the replicated command. (source: mssqlserver, error number: 20598)"

and the second one is
Violation of PRIMARY KEY constraint 'NWX_WQMS_PRIMARY'. Cannot insert duplicate key in object 'dbo.NWX_WQMS_QUEUE_MSG'. The duplicate key value is (20, 3, 13031200020600002).

I have googled for both and tried all the options but nothing is working out I also recreated replication from scratch for the one Main db but same thing.

I have started replication on other dbs same way, and they are not having any problems.
should I open a MS ticket ? or is there any other way you can suggest please let me know its my production system.
This is my Production System Please help.

Thank you all in advance
Post #1463976
Posted Tuesday, June 18, 2013 11:44 AM


Group: General Forum Members
Last Login: Thursday, October 20, 2016 2:00 PM
Points: 498, Visits: 2,839
First error: someone deleted the row at the subscriber and then deleted the row on the publisher. so it's throwing that error. try to insert that row in the subscriber then the replication will delete that row.

Second error: Primary key violation. Vice versa of the above one. You have a row on the subscriber with the same primary key. Try to compare that row with the publisher if it matches delete the row on the subscriber. Replication will insert that row again.
Post #1464814
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse