March 16, 2009 at 2:39 am
I have a merge replication setup, and the replication upon completion on the specific agent of the subscriber gives message:
Merge completed after processing 8 data change(s) (1 insert(s), 0 update(s), 7 delete(s), 78 conflict(s))
While the replication is in process, i saw the messages
The merge process is retrying a failed operation made to article 'Oil Export$Document Mgt Printout Log' - Reason: 'The merge process was unable to synchronize the row.'.
The change for the row with article nickname 8056061 (Oil Export$Document Mgt Printout Log), rowguidcol {6EF18D46-F00F-DE11-BA45-00C09F3D165D} could not be applied at the destination. Further information about the failure reason can be found in the conflict logging tables.
This 78 conflicts is included for every replication thats taking place as per the schedule. Can someone advice
If its critical
What needs to be done to get rid of this conflict.
March 16, 2009 at 4:03 am
Hi,
Refer the below link for information about conflicts.
http://msdn.microsoft.com/en-us/library/aa256310(SQL.80).aspx
February 8, 2012 at 5:43 pm
there will be modification on subscriber and publisher with different data. so thats why you face this issue:-
Run
SELECT * FROM SYSMERGEARTICLES
there will be a column: conflict_table
select * from conflict_table
your conflict will be one of row in conflict table.
more over
go on publisher >>replication>>local publication>> your_publication
then right click on your_publication and click on view conflicts
a window will be shown with conflicts detail for all articles in this publication.
resolve your conflicts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply