Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
The "Last Contacted" column is not updated for MOM agents after you install Microsoft Operations Manager 2005 Service Pack 1
| Article ID | : | 920735 |
| Last Review | : | November 27, 2007 |
| Revision | : | 1.3 |
SYMPTOMS
Consider the following scenario:
| • | You apply Microsoft Operations Manager (MOM) 2005 Service Pack 1 (SP1) to a computer that is running MOM. |
| • | You push MOM 2005 SP1 to all the MOM agents. |
In this scenario, the date and the time in the MOM 2005 Administrator Console are no longer updated.
Note The date and the time are displayed in the
Last Contacted column of the
Agent-managed Computers node in the MOM 2005 Administrator Console.
Back to the top
CAUSE
This problem occurs if the MOM database is hosted on a computer other than the computer that is running MOM 2005.
When you apply MOM 2005 SP1, the service pack installation makes many changes to the MOM database. If MOM 2005 is installed on the same computer on which the MOM database is hosted, the service pack installation program automatically runs the Microsoft SQL Server database updates. However, if the MOM database is hosted on a remote computer, the SQL Server updates are not successfully applied to the MOM database.
If you run a network monitor program, you notice that the MOM 2005 SP1 agents send heartbeat information to the MOM server. However, because the MOM database is not successfully updated, these heartbeats are not processed. In this scenario, the MOM agents still receive new rules, and therefore the MOM agents can provide event data and performance data. However, the MOM agent heartbeat information is discarded.
Back to the top
RESOLUTION
To resolve this problem, manually apply the MOM 2005 SP1 SQL Server script to the MOM database. To do this, follow these steps.
Important Before you perform this procedure, you must perform a full backup of the MOM database.
| 1. | Locate the following file from the MOM 2005 SP1 installation source: build_mom2005_sp1.sql This file is located in the SP1UpdateCDImage\Support Tools\x86 folder and in the SP1UpdateCDImage\Support Tools\ia64 folder. Use the version of the file that corresponds to the operating system on which SQL Server is installed. |
| 2. | Run this script in SQL Query Analyzer on the computer that is running SQL Server. |
Back to the top
MORE INFORMATION
To obtain MOM 2005 SP1, visit the following Microsoft Web site:
Back to the top
APPLIES TO
| • | Microsoft Operations Manager (MOM) 2005 Service Pack 1 |
Back to the top
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
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please
