When trying to replicate I get the message "Another merge agent for the
subscription(s) is running."
Both publisher/distributor and subscriber are SQL2K SP3.
There is no orphan process for the agent in the sysprocesses table.
I monitored the sysprocesses while the agent is connecting: for few
seconds several processes added to the list with the host name of the
subscriber, all start and gone in the same time, and then I get the
message above.
Please help
Yes, the ActiveX is in use, but only it. No other agent for the
subscription is running.
The publication was created by hand with the wizard.
Rgds,
Orr
Paul Ibison wrote:
> It doesn't sound as though this applies, but have you
> used the ActiveX control or windows synchronization
> manager to initiate a pull when the merge agent was
> already running? Was your publication created by hand
> from scripts?
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
|||Problem solved!
The application that is using the ActiveX was started twice
automatically when computer booted.
Thanks,
Orr
Thursday, March 8, 2012
Another merge agent for the subscription is running
Labels:
agent,
database,
distributor,
merge,
message,
microsoft,
mysql,
oracle,
publisher,
replicate,
running,
server,
sql,
subscriber,
subscription,
thesubscription
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment