dbTalk Databases Forums  

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

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss The merge process is retrying a failed operation made to article.. in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Gregor
 
Posts: n/a

Default The merge process is retrying a failed operation made to article.. - 11-26-2009 , 02:49 AM






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. '.

Reply With Quote
  #2  
Old   
Paul Ibison
 
Posts: n/a

Default Re: The merge process is retrying a failed operation made to article.. - 11-27-2009 , 03:31 AM






Pls use logging as per this article and then post up any additional
messages: http://support.microsoft.com/?id=312292
HTH,
Paul Ibison

Reply With Quote
  #3  
Old   
Gregor
 
Posts: n/a

Default Re: The merge process is retrying a failed operation made to artic - 11-30-2009 , 02:12 AM



I have send you complete log file to mail.

"Paul Ibison" wrote:

Quote:
Pls use logging as per this article and then post up any additional
messages: http://support.microsoft.com/?id=312292
HTH,
Paul Ibison

Reply With Quote
  #4  
Old   
Paul Ibison
 
Posts: n/a

Default Re: The merge process is retrying a failed operation made to artic - 11-30-2009 , 10:07 AM



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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.