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 ?
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 ?