Violation of UNIQUE KEY constraint ''unique_pubsrvdb''-SQL 2005 Merge Replication

• Joperez

  SSC-Addicted

  Points: 400

  More actions

  September 10, 2007 at 9:15 am

  #178338

  Replication scenario:

   

  SQL 2005 publisher, distributor; with seven publications from five different databases.

  Database on a SQL 2005 subscriber which two tables are being populated from two different publications in the publisher.

   

  The issue:

  This has been working correctly for more than a year, since day one it was setup. Last Thursday replication started to fail with the following error:

   

  Violation of UNIQUE KEY constraint 'unique_pubsrvdb'. Cannot insert duplicate key in object 'dbo.sysmergesubscriptions'.

   

   

  I have redone the publications and subscriptions, but I am still getting the same error, it works only when replication involves one of the tables but not both at the same time.

   

  Any idea?

   

  Thanks,

  Jose

   

• sqldba-294117

  Hall of Fame

  Points: 3486

  More actions

  September 10, 2007 at 4:27 pm

  #732629

  is this merge replication & if not then check if those tables primary keys have been removed or ?.