Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Replication (2005)  Merge push only replication primary key violation

Author  Topic  cyber Starting Member 1 Post Posted - 2009-04-20 : 16:03:44 Hi, can anyone help me to resolve the below issue with the sql server 2005 merge replication. i am getting an error with Merge replication which has push only replication to 2 subscribers ... the error is "A row insert at <DatabaseName> could not be propagated to <destination database name>. This failure can be caused by a constraint violation. Violation of PRIMARY KEY constraint <primarykey>. Cannot insert duplicate key in object <tableName>".. in this we are not allowing the subscribers to modify as it is just a push only replication... and again when we try to run the job 2nd time it is passing successfully this is happening everyday ( first time it fails and second time is complets successfully). Note: in the publisher we have around 50 tables in that 5 tables has the filter clause too.