You receive an error message when you try to upgrade to Microsoft Operations Manager 2005 (885722)

SYMPTOMS

When you try to upgrade Microsoft Operations Manager (MOM) 2000 with Service Pack 1 (SP1) to MOM 2005, you receive the following error message:

All the queries in a query expression containing a UNION operator must have the same number of expressions in their select lists.

CAUSE

This issue can occur if the database schema is changed before you upgrade to MOM 2005. The database schema can change if one of these conditions is true:

You added or removed columns or tables from the database.

Note Modifying the OnePoint database schema may cause unwanted behavior, and is not supported.
You used Microsoft SQL Server replication on the OnePoint database. SQL Server replication adds the msrepl_tran_version column to the EventConsolidated table.

RESOLUTION

To resolve this issue, use one of the following methods.

You used SQL Server replication

If you used SQL Server replication, you must remove the msrepl_tran_version column. To do this, follow these steps.

Warning If you manually modify the OnePoint database, you may cause serious problems that may require that you reinstall MOM or Microsoft SQL Server. We cannot guarantee that you can solve problems that result from modifying the database incorrectly. Manually modify the database at your own risk. We recommend that you back up the OnePoint and Master databases before you follow these steps.

Start SQL Server Enterprise Manager.
Expand Microsoft SQL Servers\SQL Server Group\(local)(Windows NT)\Databases\OnePoint.
Click Tables, right-click EventConsolidated, and then click Design Table.
Right-click the msrepl_tran_version column, and then click Delete Column.
Close the Design Table window, and then click Yes to save the changes to the table.

You manually modified the OnePoint database

If you manually modified the OnePoint database, you must restore the database to a time before you made the modifications. If you do not have a backup that contains the default MOM 2000 schema, you must perform a new installation of MOM 2005.