Can't solve replication conflict

User avatar
Peter Kinross
5StarLounger
Posts: 962
Joined: 09 Feb 2010, 00:33
Location: Patterson Lakes, Victoria, Australia

Can't solve replication conflict

Post by Peter Kinross »

My main Db is replicated on 2 other computers. A couple of weeks ago, I had problem editing a record and had to rebuild one of the 80 or so tables. Now when I open the Design Master I get a conflict error, yet the Replication Conflict Viewer shows ‘<No conflict tables>’.
Anyone have any idea on how I can resolve the conflict?
Avagr8day, regards, Peter

User avatar
HansV
Administrator
Posts: 78474
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Can't solve replication conflict

Post by HansV »

Best wishes,
Hans

User avatar
Peter Kinross
5StarLounger
Posts: 962
Joined: 09 Feb 2010, 00:33
Location: Patterson Lakes, Victoria, Australia

Re: Can't solve replication conflict

Post by Peter Kinross »

Unfortunately one of the computers is a laptop, so replication is the only solution.
I solved the problem. I manually resolved any conflicts, deleting each conflict table as I went - which worked - sort of. But one replication table was left, 'MSysRepInfo_Conflict'. And that table can't be touched. Neither rows deleted nor the table itself deleted. While that was still around, although there were now no conflicts, the problem persisted.
So I un-replicated the Design Master using Pacific Database's Unreplicate. Pretty painless. Then I made it replicable, and created 2 replicas. Now it all works just fine again (until next replication error).
So, thanks for the input.
Avagr8day, regards, Peter