Group:  Microsoft Access ยป microsoft.public.access.replication
Thread: Conflict resolution window won't open

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Conflict resolution window won't open
"Nick" <nickmirro[ at ]spamarrest.com> 12.09.2006 15:38:52
Our developer just added a couple of new tables to the back end design
master. This was done by copying the design master to an ftp site, which he
subsequently downloaded, worked on and then re-uploaded to the ftp site. I
then copied it back to the original folder.

Unfortunately, he sent back a replica (for a yet unknown reason) instead of
a design master. I initially missed that. When the back end was finally in
the original folder, I then synched with one of the members of the rep set.
The conflict message box opened. Strange since no new data was entered in
the interim by any end user.

Anyway, when I clicked 'yes' to resolve, the message box closed and no
conflict resolution window appeared. On compact and reopen, the message box
appears again but no window results when 'yes' is clicked.

Of note, after reopening the db - following the first conflict message - the
size jumped from 17.9 to 21.6 mb in that instant.

Nick



Re: Conflict resolution window won't open
"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 13.09.2006 01:12:38
"Nick" <nickmirro[ at ]spamarrest.com> wrote in
news:ejuJHGo1GHA.4648[ at ]TK2MSFTNGP04.phx.gbl:

[Quoted Text]
> Our developer just added a couple of new tables to the back end
> design master. This was done by copying the design master to an
> ftp site, which he subsequently downloaded, worked on and then
> re-uploaded to the ftp site. I then copied it back to the
> original folder.

You just cannot do this. Any replica (and the DM is just a special
replica) as to remain in place to maintain its ReplicaID. Once it
was moved and opened in the new location, it changed ReplicaID and
then could not be the DM any longer.

> Unfortunately, he sent back a replica (for a yet unknown reason)
> instead of a design master. I initially missed that. When the
> back end was finally in the original folder, I then synched with
> one of the members of the rep set. The conflict message box
> opened. Strange since no new data was entered in the interim by
> any end user.

Are there conflict tables?

> Anyway, when I clicked 'yes' to resolve, the message box closed
> and no conflict resolution window appeared. On compact and
> reopen, the message box appears again but no window results when
> 'yes' is clicked.
>
> Of note, after reopening the db - following the first conflict
> message - the size jumped from 17.9 to 21.6 mb in that instant.

You have done something illegal (moving a replica without using the
MOVE REPLICA function in ReplMan, the TSI Synchronizer or JRO), and
this creates "dead replicas." There is no predicting what kind of
problems this will cause over time, and it may not be possible to
correct the error (though I doubt it's unresolvable).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Re: Conflict resolution window won't open
"Nick" <nickmirro[ at ]spamarrest.com> 13.09.2006 03:58:22
I think we will revert to our backup and then start following your
suggestions for handling the DM. What an idiotic oversight on my part.

Nick



"David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> wrote in message
news:Xns983CD7C40D684f99a49ed1d0c49c5bbb2[ at ]127.0.0.1...
[Quoted Text]
> "Nick" <nickmirro[ at ]spamarrest.com> wrote in
> news:ejuJHGo1GHA.4648[ at ]TK2MSFTNGP04.phx.gbl:
>
>> Our developer just added a couple of new tables to the back end
>> design master. This was done by copying the design master to an
>> ftp site, which he subsequently downloaded, worked on and then
>> re-uploaded to the ftp site. I then copied it back to the
>> original folder.
>
> You just cannot do this. Any replica (and the DM is just a special
> replica) as to remain in place to maintain its ReplicaID. Once it
> was moved and opened in the new location, it changed ReplicaID and
> then could not be the DM any longer.
>
>> Unfortunately, he sent back a replica (for a yet unknown reason)
>> instead of a design master. I initially missed that. When the
>> back end was finally in the original folder, I then synched with
>> one of the members of the rep set. The conflict message box
>> opened. Strange since no new data was entered in the interim by
>> any end user.
>
> Are there conflict tables?
>
>> Anyway, when I clicked 'yes' to resolve, the message box closed
>> and no conflict resolution window appeared. On compact and
>> reopen, the message box appears again but no window results when
>> 'yes' is clicked.
>>
>> Of note, after reopening the db - following the first conflict
>> message - the size jumped from 17.9 to 21.6 mb in that instant.
>
> You have done something illegal (moving a replica without using the
> MOVE REPLICA function in ReplMan, the TSI Synchronizer or JRO), and
> this creates "dead replicas." There is no predicting what kind of
> problems this will cause over time, and it may not be possible to
> correct the error (though I doubt it's unresolvable).
>
> --
> David W. Fenton http://www.dfenton.com/
> usenet at dfenton dot com http://www.dfenton.com/DFA/


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net