Friday, March 9, 2012

Merge Replication fails on deadlocked

I have a merge replication environment with one host is
publisher/distributor and one subscriber. The merge uses continuous
replication. My MSSQL's are 2000SP4.
The process could not enumerate changes at the 'Publisher'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
Transaction (Process ID 70) was deadlocked on lock resources with another
process and has been chosen as the deadlock victim. Rerun the transaction.
(Source: SERVA_SQL (Data source); Error number: 1205)
Thanks for any help,
Darek
These errors are normally transitory. Try restarting your merge agent.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dlib" <dlib@.pap.pl> wrote in message
news:dltakk$hlr$1@.nemesis.news.tpi.pl...
>I have a merge replication environment with one host is
>publisher/distributor and one subscriber. The merge uses continuous
>replication. My MSSQL's are 2000SP4.
>
> The process could not enumerate changes at the 'Publisher'.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> ----
> Transaction (Process ID 70) was deadlocked on lock resources with another
> process and has been chosen as the deadlock victim. Rerun the transaction.
> (Source: SERVA_SQL (Data source); Error number: 1205)
> ----
> Thanks for any help,
> Darek
>

No comments:

Post a Comment