Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 885722 - Last Review: October 25, 2006 - Revision: 1.1
You receive an error message when you try to upgrade to Microsoft Operations Manager 2005
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.
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.
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.
APPLIES TO
- Microsoft Operations Manager (MOM) 2005
| kbopmaninterop kbopmaninstall kbopman2005bug kbtshoot kbdatabase kberrmsg kbupgrade kbsetup kbinterop KB885722 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate