Hi,
We have a publisher and 2 subsribers. The subscribers are spanning 2
transactions/sec. We have inplemented merge replication and it was
scheduled to occur every 5 min. When we start the replication, the
replications is going on without any problem for sometime(may be some
hours), but after that it fails with the message, "the process could
not deliver inserts at the publisher". That too we have 3 articles to
replicate. The first article is replicating fine.But the second article
fails with this error message "the process could not deliver inserts at
the publisher".We have SAN. When I searched for this error in google,
it asked me to increase the queytimeout value in agent profile. So I
increased it from 300 to 600, but in vain. If anybody could help me in
this, that would be great.
Thanks,
Preethi.
Preethi,
perhaps you could further increase the timeout? I'd also implement logging
(http://support.microsoft.com/?id=312292). After that, have a look at the
spid using dbcc inputbuffer to see what is happening on synchronization. You
might also want to run sp_who2 to look for any blocking occurring.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
sql
Monday, March 26, 2012
Merge agent failure; Urgent
Labels:
2transactions,
agent,
database,
failure,
inplemented,
merge,
microsoft,
mysql,
oracle,
publisher,
replication,
sec,
server,
spanning,
sql,
subscribers,
subsribers,
urgent,
wasscheduled
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment