Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

The merge process is retrying a failed operation made to article..

557 views
Skip to first unread message

Gregor

unread,
Nov 26, 2009, 3:49:01 AM11/26/09
to
I have one problem. Replication to one of subcriber in merge replication stop
synhronizing. Both, publisher and subscriber, are SQL 2005 SP3. This hapens
already one weak ago. Then i have tried to reinitialize subscribtions but it
didn't work. So i have deleted publication and set up subscriber again. It
worked now for 5 days and now it hapens again. Can you please help me .. its
urgent. Tnx.

This is error that i get:
2009-11-26 08:23:59.175 Enumerating inserts and updates in article
'setup_aor_online' (generation batch 1)
2009-11-26 08:23:59.191 OLE DB Distributor 'ZL-ZALEC-DC\SQL2005': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-11-26 08:24:29.410 OLE DB Subscriber 'ZL-PETROVCE-DC\SQL2005': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-11-26 08:24:29.441 Percent Complete: 0
2009-11-26 08:24:29.441 OLE DB Subscriber 'ZL-PETROVCE-DC\SQL2005': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-11-26 08:24:29.472 The merge process is retrying a failed operation
made to article 'aor_prevzem' - Reason: 'Unspecified error'.
2009-11-26 08:24:29.550 OLE DB Distributor 'ZL-ZALEC-DC\SQL2005': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-11-26 08:24:29.550 OLE DB Subscriber 'ZL-PETROVCE-DC\SQL2005': {call
sys.sp_MSadd_merge_history90
(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2009-11-26 08:24:29.628 Percent Complete: 0
2009-11-26 08:24:29.644 The merge process is retrying a failed operation
made to article 'aor_prevzem' - Reason: 'The Merge Agent was unable to
synchronize the row due to one or more unanticipated errors in the batch of
changes. When troubleshooting, increase the -OutputVerboseLevel setting,
restart the agent, and check for and resolve any errors generated by the
database engine. '.

Paul Ibison

unread,
Nov 27, 2009, 4:31:34 AM11/27/09
to
Pls use logging as per this article and then post up any additional
messages: http://support.microsoft.com/?id=312292
HTH,
Paul Ibison

Gregor

unread,
Nov 30, 2009, 3:12:01 AM11/30/09
to
I have send you complete log file to mail.

Paul Ibison

unread,
Nov 30, 2009, 11:07:59 AM11/30/09
to
OK have a look at what changes are failing at the article 'aor_blago'.
You could run profiler on the subscriber to see what is being applied, or
use a variation of this script :
http://www.replicationanswers.com/Script9.asp
to find the change being applied.
HTH,
Paul Ibison

0 new messages