Merge replication - conflicts

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Replication » Merge replication - conflicts

Merge replication - conflicts

Rate Topic

Display Mode

Topic Options

Author

Message

rubinasd

Posted Monday, March 16, 2009 2:39 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, July 24, 2011 2:19 AM
Points: 10, Visits: 120

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.

Post #676314

vijaysingh

Posted Monday, March 16, 2009 4:03 AM

SSC-Addicted

Group: General Forum Members
Last Login: Saturday, May 29, 2010 5:42 AM
Points: 412, Visits: 149

Hi,

Refer the below link for information about conflicts.

http://msdn.microsoft.com/en-us/library/aa256310(SQL.80).aspx

Post #676340

umarrizwan

Posted Wednesday, February 08, 2012 5:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 02, 2013 9:57 AM
Points: 9, Visits: 24

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.

Post #1249413

« Prev Topic | Next Topic »

Permissions