How to Upgrade a Replicated SQL 2000 MetaFrame XP Feature Release 3 Environment

RoyATokeshi
August 2, 2006 10:58 am

Citrix states in their article: CTX110738

Document ID: CTX110738, Created on: Aug 1, 2006, Updated: Aug 1, 2006

Products: Citrix MetaFrame Presentation Server 3.0 for Microsoft Windows 2000, Citrix MetaFrame Presentation Server 3.0 for Microsoft Windows 2003, Citrix MetaFrame XP 1.0 for Microsoft Windows 2000, Citrix MetaFrame XP 1.0 for Microsoft Windows 2003, Citrix Presentation Server 4.0 for Microsoft Windows 2000, Citrix Presentation Server 4.0 for Microsoft Windows 2003

Summary

This article describes the process of upgrading a replicated SQL 2000 MetaFrame XP Feature Release 3 environment to a MetaFrame Presentation Server 3.0 or a Citrix Presentation Server 4.0 environment.

Background

See CTX101739 – Microsoft SQL Server 2000 Data Store Replication.

Citrix Systems supports transactional replication with immediate updating subscribers because of the design of the data store database. The MetaFrame XP database is initially published with that version of the schema. When MetaFrame Presentation Server 3.0 was introduced, the data store schema was modified to make queries to the database more efficient. The schema was further modified with the addition of a new index on the Indextable which indexes Microsoft hotfix information. The schema modifications are as follows:

On MetaFrame Presentation Server 3.0:

New table: DELETETRACKER
New triggers: OnKeyTableDelete, OnKeyTableInsertUpdate
New column on the KEYTABLE: changestamp
On Citrix Presentation Server 4.0:

MetaFrame Presentation Server 3.0 schema
New index on the INDEXTABLE: INDEXTABLEINDEX2
Symptoms

When a MetaFrame XP server configured to point to the publisher database is upgraded to MetaFrame Presentation Server 3.0 or Citrix Presentation Server 4.0, it successfully modifies the existing schema of the publisher (also referred to as the master) data store database to the current version. These changes are not replicated to the subscriber database.

When a server that is configured to point to the subscriber database is upgraded to 3.0 or 4.0, it successfully upgrades the subscriber (also referred to as the replica) schema to the newest version.

When replication is reinitialized for any reason, the original publication schema is replicated out to all of the subscribers. This modifies the existing schema with the one contained in the publication (MetaFrame XP Feature Release 3) since it is not modified during the upgrade process.

At this point the subscription data store schema has now been reverted back to the original MetaFrame XP Feature Release 3 schema.

When any MetaFrame Presentation Server 3.0 or Citrix Presentation Server 4.0 server that has been configured to point to this subscriber either has the IMA Service restarted or the server is rebooted, the IMA Service fails to start because it cannot find the changestamp column on the KEYTABLE.

Resolution

Caution! Before beginning the upgrade process, replication must be disabled between all replicated sites by deleting the publication and its corresponding subscriptions.

Upgrade the data collector that is configured to point to the SQL server designated as the publisher to MetaFrame Presentation Server 3.0 or Citrix Presentation Server 4.0.
Have the database administrator (DBA) verify that the updated schema articles have been created in the upgraded database.
Re-publish the updated Presentation Server database and reconfigure replication to the previous subscription sites following the steps documented in CTX101739 – Microsoft SQL Server 2000 Data Store Replication.
Ensure that the updated schema is replicated to the new subscription sites.
More Information

See CTX109394 – Upgraded MetaFrame XP Servers to Presentation 3.0 or 4.0 using SQL Replication Fail to Replicate New Schema Changes.



Primary links

Custom Search

User login

Who's new

  • Choodogek
  • zepsleltpap
  • layersepavy
  • moneytome12
  • maczugaher

Who's online

There are currently 0 users and 3 guests online.

KrissysCorner.com RuthSwensonLaw.com CreativeLizardProductions.com

DISCLAIMER:

None of this has anything to do with us, someone else is responsible for the entire thing, and we have no idea who or why. We do not know anything about it. It may be alien life forms for all we know: we haven't a clue. You cannot blame us for anything that may result from your visit. That was entirely your own personal choice, made by you of your own volition, and without our knowledge. We do not, after all, have any control over you and cannot by any stretch of the imagination be expected to accept or acknowledge, be it legally or morally, any accountability for decisions made by you on an independent basis, utilizing your own free will, and without our intervention. We are therefore in no way, shape, or form answerable to anyone for any consequences arising from the aforementioned or indeed any other actions, similar or otherwise, because it was not us that did, or did not do anything. It is not even remotely our fault, and we are in no way prepared or willing to accept any liability, not even slightly, ever. We are, in fact completely and utterly blameless, in that it is definitely not our concern, and no blame can possibly be laid at our doorstep, even if we had one, the possession of which we hereby reserve as being entirely our own free choice. The onus is not on us at all, and furthermore, never has been. The entire matter is wholly beyond our control, and completely out of our hands, each of which are washed scrupulously clean of the whole business. We are not accountable for anything at all, and we hereby categorically deny all responsibility for all that has ever, or will ever happen. Our innocence is therefore wholly beyond doubt and absolutely unimpeachable, and so cannot, under even the remotest or unlikeliest circumstances, be brought into question. By clicking either on a link on this site, clicking on a link that leads to this site, or by arriving at this site by natural or supernatural means, you are in effect accepting responsibility for the fact that it is all entirely your own fault, down to the most miniscule detail, and that you are wholly accountable for whatever outcome may arise as a consequence of the aforementioned action or actions insofar as they were undertaken personally by you on an entirely voluntary basis and without any persuasion, coercion or influence from any party or parties other than yourself. Don't come sniveling to us, we are only figments of your imagination. I also agree that if I am ever with a contributor to this website during mealtimes I agree to pay for any super-sizing of their meal, or at least a nice dessert or one of those foo-foo drinks with an umbrella or a monkey. By admitting to have seen the worthless spineless drivel on this website (also known as content)

I Agree Wholeheartedly and Without Reservation to the above. (Except maybe for that part about the monkey.)

All Your Base Are Belong To Us.

Soylent Green Is People!

Never make a bet with a Sicilian when Death is on the Line!

No. Really, I do agree.