469,090 Members | 1,103 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

Synchronise problems with merge publication under SQL Server 2000

Hello NG,

we have created a database for our schedules on the SQL server 2000.
As we have many satellite stations, we created a merge publication.
The aim of this merge publication is to provide the satellite stations
with their "own" databases, in which they can alter their data and are
able to synchronise with the main server thereafter. At the same time
it is possible to enter data into the main server (in our main
office). The subscribers (the satellite stations) have been
prioritised. The main database, of course, has 100%, and the
subscribers are put into hierarchical order (i.e. subscriber 1=99%,
subscriber 2=95% etc.). For conflict resolution I use the standard
conflict solver. Now, this is my problem:

If I alter data on one of the satellite stations and synchronise it
with the main server, the synchronisation is successful. However, if I
change the same data again on the main server and synchronise it with
the satellite station, I get conflicts. But that shouldn't happen. My
understanding of "conflict" is that if I change data set 1 on the
satellite station, then change the same data set on the main server
and synchronise it, a conflict should emerge. But this is not the case
with me. Why could that be? Does anyone have any suggestions? Could is
be a fault with the SQL server 2000?

Attached you can find a txt-doc, which I created from the standard
conflict solver. Maybe it can help you to understand my problem.

Thank you in advance for your help!

Regards,
Kaan Öcgün
ATTACHEMENT:
DatumZeit,Benutzeraktion,Datumenbank,Publikation,T abelle,UrsprungsDatumenquelle,RowGuid_Wert,Konflik ttyp,Ursache_Text,SQL
30.6.2003 15:49:37,"Konfliktverlierer","TAB1","(Alle
Mergepublikationen)","[dbo].[DF1]","Rechner1.TAB1","{6EBD7418-8158-42DB-A615-B8B758284DD5}","9","Die
Zeile wurde auf 'Rechner1.TAB1' aktualisiert, konnte jedoch auf
'Server1.TAB1' nicht aktualisiert werden. Verletzung der PRIMARY
KEY-Einschränkung 'PK_DF1'. Ein doppelter Schlüssel kann in das
DF1-Objekt nicht eingefügt werden.","SET DatumEFORMAT dmy
UPDatumE [dbo].[DF1] SET [dbo].[DF1].[ID] = [conflict_TAB1_DF1].[ID],
[dbo].[DF1].[Datum] = [conflict_TAB1_DF1].[Datum], [dbo].[DF1].[ATime]
= [conflict_TAB1_DF1].[ATime], [dbo].[DF1].[Endezeit] =
[conflict_TAB1_DF1].[Endezeit], [dbo].[DF1].[Feld1] =
[conflict_TAB1_DF1].[Feld1], [dbo].[DF1].[Anmerkungen] =
[conflict_TAB1_DF1].[Anmerkungen], [dbo].[DF1].[ÄnderungsDatum] =
[conflict_TAB1_DF1].[ÄnderungsDatum], [dbo].[DF1].[Geändert_von_ID] =
[conflict_TAB1_DF1].[Geändert_von_ID] FROM [dbo].[DF1],
[conflict_TAB1_DF1] WHERE [dbo].[DF1].[rowguid] =
'{6EBD7418-8158-42DB-A615-B8B758284DD5}' AND [dbo].[DF1].[rowguid] =
[conflict_TAB1_DF1].[rowguid]
",
Jul 20 '05 #1
0 1461

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Peter A. | last post: by
4 posts views Thread by Andreas Kasparek | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.