Microsoft KB Archive/249121
Article ID: 249121
Article Last Modified on 10/27/2006
- Microsoft Systems Management Server 2.0 Standard Edition
- Microsoft Systems Management Server 2.0 Service Pack 1
- Microsoft Systems Management Server 2.0 Service Pack 2
This article was previously published under Q249121
The following status message may appear sporadically in the Systems Management Server (SMS) site database at the central site in a large site hierarchy:
Thousands of these messages may occur per day, and status summaries for site systems may be incomplete temporarily, depending on whether the table involved (Summarizers_Status) in the deadlock was updated in the last attempt.
A deadlock occurs between the Site System Status summarizer and the Component Status summarizer.
To resolve this problem, obtain the latest service pack for Systems Management Server version 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
288239 SMS: How to Obtain the Latest Systems Management Server 2.0 Service Pack
This condition does not necessarily cause issues with site functionality, but does cause a large number of status messages to be generated. To work around this behavior, use either of the following methods.
Reduce the frequency of replication for the site system status from each of the child sites:
- In the Administrator console, for each site in your hierarchy, expand Site Hierarchy,
Site Name, Site Settings, and Status Summarizers.
- Right-click Site System Status Summarizer, and then click Properties.
- Click the Schedule button, and then assign a summarization schedule that occurs less often than once an hour. For example, assign a summarization schedule that occurs once every eight hours or once each day.
- Commit the changes.
Prevent the status messages from being loaded in the site database or forwarded to the summarizers with a Status Filter rule:
- In the Administrator console, for each site where the error message is reported, expand Site Hierarchy,
Site Name, Site Settings, and Status Filter Rules.
- Right-click the Status Filter Rules node, point to New, and then click Status Filter Rule.
- Type a name for the Status Filter rule (for example, "Exclude SMS_COMPONENT_STATUS_SUMMARIZER 620 Messages").
- Click to select the Message ID check box. Type 620 in the box to the right.
- Click the Action tab.
- Click the following options:
- Do not forward to status summarizers
- Do not process lower-priority status filter rules
- Click OK.
- Right-click the new Status Filter rule, point to All Tasks, and then click Increment Priority. Repeat this step until the Status Filter rule appears at the top of the list. This causes the rule to be processed first, discarding any status messages with an ID of 620 before writing them to the database or passing them on to the Component Status summarizer.
NOTE: This procedure prevents all messages with an ID of 620 from being written to the database or tallied by the Component Status summarizer. Use caution when you configure Status Filter rules to exclude status messages because you may inadvertently exclude important information.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Systems Management Server 2.0 Service Pack 3.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
264378 SMS: Site System Summarizer May Deadlock
Additional query words: prodsms
Keywords: kbbug kbconfig kbdatabase kbfix kbserver kbsms200presp3fix kbstatsum KB249121