Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

The merge process could not update the list of subscriptions

Status
Not open for further replies.

aomara

MIS
Nov 18, 2002
48
LY
I have a Merge Replication between a Publisher SQL Server 2005 and Subscriber SQL Server 2000.

Whenever I establish the replication and after 2 or 3 successful propagations of the data, the Merge Agent stop and provide this error :
--------------------------------------------------------
Error messages:
The merge process could not update the list of subscriptions. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201010)
Get help:
Violation of UNIQUE KEY constraint 'unique_pubsrvdb'. Cannot insert duplicate key in object 'dbo.sysmergesubscriptions'. (Source: MSSQLServer, Error number: 2627)
Get help:
The subscription could not be created. (Source: MSSQLServer, Error number: 14057)
Get help: --------------------------------------------------------
Even I drop the publisher and re-establish it again, the same happen ( after 2 or 3 successful propagations of the data I got the same Error )
Can any body find a solution to this Error ?
 
I find my self forced to upgrade the Subscriber to be SQL Server 2005, so every think is OK now.

But I have got the experiance that Replication between SQL Server 2005 and 2000 is not reliable specially when the database you replicated is already replicated before using SQL Server 2000.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top