Symptoms
After upgrading a Presentation Server installation to a newer version or installing a service pack, hotfix, or hotfix rollup pack, there may be an issue with Resource Manager and the Summary Database.
You might see a "Database connection error" message in the Management Console.
The Resource Manager server log might show “System - Resource Manager summary database schema update for version “X” failed.”
Note: “X” is a schema version value explained in the More Information section of this article.
Resource Manager server log error example:
"Message [IDispatch error #3127].
Source [Microsoft OLE DB Provider for ODBC Drivers].
Description [[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the procedure 'AddMetric_V21', because it does not exist in the system catalog.].
18 April 2008 09:28:10 - System - Failed to create summary database.
18 April 2008 09:28:10 - System - Resource Manager summary database schema update for version 44 failed.
18 April 2008 09:28:11 - System - Error 0x80040E37."
Cause
The summary file schema version from one of the upgraded or patched servers is newer than the Resource Manager Summary Database schema version. This summary file has been generated and sent to the Database Connection Server. The Summary Database, not the summary file, has a value less than “X”.
A newer server could have been added to the farm, thus updating the schema. If the newer server is removed from the farm, the value for the schema version in the Resource Manager Summary Database might not be lowered. Therefore the current Database Connection Server value is lower than the current value for “X”.
To determine the “current” schema version value, run the following command through the SQL Query Analyzer under the RM, Resource Manager, Summary Database:
Select * from schemaversion
Note: As a best practice, the Resource Manager Summary Database schema version should match the schema version of the most updated/patched server in your farm. In addition, the most updated server in your farm should be the farm metric server and Database Connection Server.
Best Practice for Upgrading a Farm to Maintain Summary Data Integrity
The Data Connection Server must be the first server upgraded in the farm.
Below are the steps required to migrate a MetaFrame XP Enterprise Edition Feature Release 3 server farm using a Resource Manager Summary Database to MetaFrame Presentation Server 3.0 Enterprise Edition:
1. Click Update Now in the Management Console to send all pending summary files to the existing Feature Release 3 Summary Database.
2. Clear the Summary Database Enabled check box to disable the Summary Database.
3. Update the Database Connection Server to MetaFrame Presentation Server 3.0 first and re-enable the Summary Database. This should update the schema in the Summary Database.
4. Point the Database Connection Server to a valid MetaFrame Presentation Server 3.0 license server.
5. Update the Farm Metric Server to MetaFrame Presentation Server 3.0.
6. Update any remaining servers in the farm to MetaFrame Presentation Server 3.0.
Note: In certain cases when the Database Connection Server had RME103W007 or Service Pack 4 for MetaFrame XP applied, the server log may contain the following error message after you complete this procedure:
“System - Resource Manager summary database schema update for version “X” failed.”
In these cases, use the following workaround:
Workaround
Ensure you have a good backup of the Resource Manager Summary Database.
Important: Do not attempt to modify/upgrade the schema version using any of the update scripts before manually changing the schema value.
Set the schemaversion to “X” by running the following command in Query Analyzer under the RM, Resource Manager, Summary Database:
UPDATE SCHEMAVERSION SET VERSION = “X”
This action allows the Summary Database to update to the correct schema version. You should then be able to confirm that the schema version updates to “X” by running the “select * from schemaversion” command again.
The Summary Database has a table called SCHEMAVERSION.
This table stores the version of the summary database schema. The version number is queried by the Database Connection Server during a connection to determine if the Database Connection Server and the Summary Database schema are compatible.
A SCHEMA is a description of a database to a Database Management System (DBMS) in the language provided by the DBMS. A schema defines aspects of the database, such as attributes (fields) and attribute parameters. The DBMS is the SQL or Oracle server hosting the summary database.
Below is the schema version for each updated schema release for the Summary Database:
• MF XP FR2: RM Summary Database Update for Schema Version : (18)
• RME102W007: RM Summary Database Update for Schema Version : (21)
• RME102W011: RM Summary Database Update for Schema Version : (22)
• MF XP FR3: RM Summary Database Update for Schema Version : (24)
• RME102W013: RM Summary Database Update for Schema Version : (25)
• RME103W006: RM Summary Database Update for Schema Version : (26)
• RME103W011: RM Summary Database Update for Schema Version : (27)
• MPS 3.0: RM Summary Database Update for Schema Version : (40)
• CPS 4.0: RM Summary Database Update for Schema Version : (41)
• CPS 4.0 R03: RM Summary Database Update for Schema Version : (43)
• CPS 4.0 R04: RM Summary Database Update for Schema Version : (44)
• CPS 4.5: RM Summary Database Update for Schema Version : (60)
• CPS 4.5 R01: RM Summary Database Update for Schema Version : (60)
• CPS 4.5 R02: RM Summary Database Update for Schema Version : (61)
