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
>
Friday, March 9, 2012
Merge Replication fails on deadlocked
Labels:
continuousreplication,
database,
deadlocked,
distributor,
environment,
fails,
ispublisher,
merge,
microsoft,
mssqls,
mysql,
oracle,
replication,
server,
sql,
subscriber
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment