Replication fails with primary key violation error

[Teresa Schroat]

I have a publication that has been working great for over eight months. I have on occassion had to stop publishing and stop subscribing in normal operation without problems.

Yesterday, I ran into a problem that I am not sure how to solve.

I keep getting a distribution task failure "Violation of Primary Key constraint 'aaaashipm_pk'. Attempt to insert duplicate key in object shipm failed while bulk copying into shipm

Anyone run across this or have any suggestions -- do I have a transaction log problem, distribution data base/log problem. I have checked the identity column to make sure its not out of sync, run a check on the table to make sure its not corrupted. I have a couple of other things I am trying but was curious if anyone else had come across this?

Will let you know if I find a solution but it doesn't look good.

[Sriram Krishna]

It's Happened due to the Primary Key already existing in the Subscriber side. when it trying to replace the data in that Particular field both the Primary Keys are getting collided. So you are getting that Error. There are so many ways to come out from this Error. The best one is :

Drop that Table in Subscriber side and Reintialize that Table.