Replication gone crazy

[John]

Hi

When I try to resolve replication conflicts, first of all 'Microsoft
Replication Conflict Viewer' gets stuck for 15-20 seconds then it gives the
error 'There was an error trying to obtain data for a specific conflict
table for 'MyTable'. The viewer can not display this conflict.". In the log
file I get the following two types of entries;

Database Publication Table Origin_DataSource RowGuidValue conflict_type
reason_text

F:\MyDB.mdb (Not Specified) MyTable C:\MyDB.mdb
{1BCC3F03-5972-4F9B-A88E-903B08F86FC0} 3736 Update/delete conflict. This
updated record was deleted at another replica. Either reinsert this conflict
record or delete it.

F:\MyDB.mdb (Not Specified) MyTable {1BCC3F03-5972-4F9B-A88E-903B08F86FC0}
3736 Update/delete conflict. This updated record was deleted at another
replica. Either reinsert this conflict record or delete it.

Any idea what is wrong and how can I fix it?

Thanks

Regards

 

[David W. Fenton]

When I try to resolve replication conflicts, first of all
'Microsoft Replication Conflict Viewer' gets stuck for 15-20
seconds then it gives the error 'There was an error trying to
obtain data for a specific conflict table for 'MyTable'. The
viewer can not display this conflict.". In the log file I get the
following two types of entries;

Database Publication Table Origin_DataSource RowGuidValue
conflict_type reason_text

F:\MyDB.mdb (Not Specified) MyTable C:\MyDB.mdb
{1BCC3F03-5972-4F9B-A88E-903B08F86FC0} 3736 Update/delete
conflict. This updated record was deleted at another replica.
Either reinsert this conflict record or delete it.

F:\MyDB.mdb (Not Specified) MyTable
{1BCC3F03-5972-4F9B-A88E-903B08F86FC0} 3736 Update/delete
conflict. This updated record was deleted at another replica.
Either reinsert this conflict record or delete it.

Any idea what is wrong and how can I fix it?

Sounds like you're trying to resolve conflicts that have already
been resolved at another replica? Dunno why your replica would know
this and not have cleared the conflicts table, though.

Have you checked the records involved to see if the conflict was
correctly resolved already? If so, you can just delete the conflict
record and quite there.

 

[John]

I have run find unmatched queries between dbs and there is no extra/missing
record in any of them. How can I locate the records to delete? Also the
record seems to suggests some missing info, does it have any significance?

Thanks

Regards