Article ID: 249121 - View products that this article applies to.
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.
SMS_COMPONENT_STATUS_SUMMARIZER 620 Microsoft SQL Server reported SQL message 3902, severity 16: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information.
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:
(http://support.microsoft.com/kb/288239/EN-US/ )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.
Method 1Reduce the frequency of replication for the site system status from each of the child sites:
Method 2Prevent the status messages from being loaded in the site database or forwarded to the summarizers with a Status Filter rule:
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:
(http://support.microsoft.com/kb/264378/EN-US/ )SMS: Site System Summarizer May Deadlock
Article ID: 249121 - Last Review: October 27, 2006 - Revision: 2.4