We help IT Professionals succeed at work.

Microsoft, Access, 2003 Two Design Master Entries in MSysReplica

StevenPMoffat
on
250 Views
Last Modified: 2011-10-19
I have two entries in my replica table for Design Master with the same pathname.  I am interested in how this might have happened, but more concerned that it might be causing other problems that I am experiencing.  See Spreadsheet dump.  How can I remove one of them?
MSysReplicasOne.xls
Comment
Watch Question

There should only ever bee one design master.  While one is being promoted and another demoted there can for a brief time exist two copies that think they are the design master and if design changes are made and then propagated with synchronization problems can occur.

If you have two copies that believe themselves to be the design master synchronize them ASAP.  They should resolve the issue between them and emerge with one global replica and one design master.  The next step would be to pass that synchronization on to all other copies ASAP so the hierarchy is understood among all its children.

Author

Commented:
Thanks Rick.  I realize this as you have pointed out.   The problem I am facing is that the pathname for both of these Design Masters is the same.  I had tried what you said, but I was effectively trying to sync the file with itself.  I really don't have two copies of files that believe they are design masters, but rather two entries in MSysReplica that point to the same file?  Since I am currently having problems creating partial replicas (submitted as another question) I was wondering if this situation might be the cause of that problem.
OK, well that makes more sense.  I think you'll find this problem clean itself up in time.  For whatever reason replication seems to have this little quirk (it's especially glaring if you use the Replication Manager to do something like Internet Replication).  In short it seems to take note of the location of each replica, (I used to see this a lot).  When one of my users moved their replica to another location the replication manager would display the new file and location as if it were a new replica when in fact it was merely the old one places somewhere else.  Eventually the replication manager does purge these old entries after a period of inactivity (although it's annoying to see them and know they do not belong there).

As long as your replicas aren't confused into thinking there are two design masters you should be fine.  I wouldn't sweat a double entry like this because of the kinds of things I've seen before (as previously described).  Even so if you're concerned you could spawn a new global replica from the master that you have, promote the new global replica as the new design master and then deprecate the original design master.  I've had problems with my design masters before and this has a way of leaving them behind, although in this case I wouldn't be surprised if the end product becomes the list you're reviewing claiming that you now have 3 design masters instead of two.  If so, I don't believe it's indicitive of a problem more than it is a frayed in in the replication design.

Rick

Author

Commented:
Rick,

In your original recommendation, you stated "Even so if you're concerned you could spawn a new global replica from the master that you have, promote the new global replica as the new design master and then deprecate the original design master."   I understand all but the last part.  Once I have created a new design master, how do I 'deprecate' the original design master?
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
I probably should have used a different word as the word 'Deprecate' usually means to express disapproval of, urge against, protest, etc. but when speaking of software it takes on a different meaning, more like rendering obsolete, which in this case is exactly what you're doing to a Design Master when one of the other Global Replicas assumes that role.

http://www.techweb.com/encyclopedia/defineterm.jhtml?term=deprecate

Author

Commented:
Thanks.  Worked
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.