Hello Group,
(I have posted this query in Microsoft Newsgroup also, but I did not get any response. Please respond. Thanx)
I have setup a Merge Replication between two
servers. (SERVER_PUBLISH is the Publisher and
SERVER_SUBSCRIBE is the Subscriber).
I was periodically getting Network errors, I tried looping
step 3 (both on success and failure) of the job back to
step 1. I have also given a higher number of retry
attempts and interval, but still at times I get this error
(mentioned below) and my replication stops. Is there a
way to automatically resume replication after such errors
occurs.
Please Help. This is very urgent.
Thanks in advance
Anand
Part of the error log is mentioned below =>
Downloading data changes to the Subscriber
Percent Complete: 4
No data needed to be merged.
Percent Complete: 4
Uploading data changes to the Publisher
Percent Complete: 4
No data needed to be merged.
Percent Complete: 4
Downloading data changes to the Subscriber
Percent Complete: 4
No data needed to be merged.
Percent Complete: 4
Uploading data changes to the Publisher
The merge process could not apply the replication metadata.
The process could not enumerate changes at
the 'Subscriber'.
The process could not enumerate changes at
the 'Subscriber'.
The merge process encountered an unexpected network error.
The connection to Subscriber 'SERVER_SUBSCRIBE' is no
longer available.
Percent Complete: 0
The merge process could not apply the replication metadata.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147200968
Message: The merge process could not apply the replication
metadata.
Percent Complete: 0
Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSproxiedmetadata(?,?,?,?)}{call
sp_MSproxiedmetadata(?,?,?,?)}{call sp_MSproxiedmetadata
(?,?,?,?)}{call sp_MSproxiedmetadata(?,?,?,?)}{call
sp_MSproxiedmetadata(?,?,?,?)}{call sp_MSproxiedmetadata
(?,?,?,?)}{call sp_MSproxiedmetadata(?,?,?,?)}
Percent Complete: 0
Category:SQLSERVER
Source: SERVER_SUBSCRIBE
Number: 11
Message: General network error. Check your network
documentation.
Percent Complete: 0
Category:NULL
Source: Merge Replication Provider
Number: -2147199469
Message: The process was successfully stopped.
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Subscriber 'SERVER_SUBSCRIBE'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Publisher 'SERVER_PUBLISH'
Disconnecting from Distributor 'SERVER_PUBLISH'Try setting up the Merge Agent to run on a schedule of every one minute. That way, it will start up again even if it has failed. Also, please do not say your request is "urgent". All of us that ask for help feel our requests are "urgent".
No comments:
Post a Comment