473,320 Members | 1,867 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Replication gone crazy

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

Oct 20 '06 #1
1 1800
"John" <Jo**@nospam.infovis.co.ukwrote in
news:La******************************@pipex.net:
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?
Between synchs, a record was updated in one replica and deleted in
another.

This oughtn't be a problem, but something has gone wrong.

Check the records involved in the replicas identified and see what
you can see. Should the record have been deleted? If so, you can
discard the updated version and leave it alone. You can confirm this
by checking the conflict table for the table in question (it will be
called MyTable_Conflicts, and will be marked HIDDEN, so you'll need
to go to TOOLS | OPTIONS and turn on display of hidden objects;
while there, you might as well display system objects, because you
may need to use the replication system tables, as well). Using the
RowGUIDValue, you can check to see if the record was in fact deleted
from MyTable. If it was, there won't be any row with s_GUID set to
that value. If there *is* a row with that value, it means the record
was *not* deleted.

The log file most likely has two entries because you have synched
twice (either with the same replica or with two different replicas)
-- both entries refer to the same record (the GUID is the same) and
the same error type.

Now, if the record should *not* have been deleted, then you'll need
to add it back by appending the version of the record in conflict
table to the main table, but ignoring all the replication fields.
That will create a new record with the same data but it will be a
new record from Jet replication's point of view.

Once you've resolved this issue, you can delete the conflict record
from the conflict table (or the whole conflict table if there are no
other conflicts).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 20 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: k.tragant | last post by:
Hello list, I'm in the phase of upgrading mysql from 3.23(.58) to 4.0(.23). I have some replication setups. Following the manual, the upgrade process went very smooth. Now I have some...
10
by: Daven Thrice | last post by:
I have a database that needs to be replicated over the Internet. I was hoping it would be a simple task, but apparently it is not. I've started browsing the msdn article on the topic. In the...
6
by: sat | last post by:
Hi Everybody ! I want to know about REPLICATION in DB2 UDB in detail.As i'm going to work on this i would like to know about it.I want to do it on my PC (if possible) before i can implement it...
2
by: tech101 | last post by:
Can I get the master (or slaves) to automatically remove the binary logs once they are processed by all slaves? It says in the mysql manual : If you are using replication, you should not delete...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.