<tpapad@gmail.com> wrote in message
news:1175700772.663196.202170@y80g2000hsf.googlegroups.com...
> Hello all,
>
> We have implemented a merge publication with merge agents
> synchronizing over a slow WAN connection. The connection seems to be
> rather unstable and users often disconnect during synchronization.
> When they try to repeat the process (after the connection is re-
> established) they get the error:
>
> Another merge agent for the subscription is running
>
> Meantime, in EM the merge agent is shown as re-trying (this is even
> when there is no connection between publisher/subscriber).
>
> During my searches about the issue, the only useful solution was to
> kill the orphaned processes. This works fine BUT the error is way to
> often (2-4 users having it several times a day) so there must be a
> better solution.
>
> btw, the agents are already configured with "Slow Link" profile.
>
> I suppose the SQL Server kills the orphaned processes at some point
> but this time-out could be too long (not sure how long but longer than
> 3-4 hours, which is un-acceptable).
>
> Any other solution aside of manually killing processes? Any ideas or
> suggestions?
>
> TIA
>