This monitor checks the status of the Replication Merge Agent service for Subscription.
Knowledge Base article:
Summary
The Replication Merge Agent is an executable that applies the initial snapshot held in the database tables to the Subscribers. It also merges incremental data changes that occurred at the Publisher after the initial snapshot was created. The agent also reconciles conflicts using either the configured rules or uses a custom resolver.
The Replication Merge Agent is an executable that applies the initial snapshot held in the database tables to the Subscribers. It also merges incremental data changes that occurred at the Publisher after the initial snapshot was created. The agent also reconciles conflicts using either the configured rules or uses a custom resolver.
Causes
A merge agent can fail because of the following reasons:
The Merge Agent cannot connect the publisher database(pull subscription)
The Merge Agent cannot connect to the subscriber database(push subscription)
The merge replication metadata is deleted at the subscriber because the merge agent has not synchronized within the retention period
The subscription is marked as expired.
Query timeout errors
Network connectivity errors
The Merge agent cannot start because of memory exhaustion for the non-interactive desktop heap
Incorrect parameters passed to the agent executable
Resolutions
This issue can be resolved by ensuring the following:
The merge agent cannot connect to both publisher and subscriber. Configure access to dbo to the merge agent account on both the publisher and subscriber databases
If the subscription is marked as expired, reinitialize the subscription
Resolve network or connectivity issues between the servers when the merge agent is running
If the subscription metadata is deleted at the publisher, drop and recreate the subscription.
This can happen when the merge agent has not synchronized with the subscriber/publisher in double the retention period.
Ensure the correct parameters are passed to the agent executable.
Query the msmerge_agents and msmerge_history tables on the distribution database to get more information on the agent failure. The Msrepl_errors table also contains information about any agent failures.
Home
ENU