Configuration Manager Collection Evaluator failed to enumerate collections. Configuration Manager status message 2500 was detected.
This condition could occur because of a SQL Server problem.
Refer to the documentation for Configuration Manager status message 2500 for more information about the cause of this problem.
Review the immediately preceding status messages from this component about SQL Server errors.
Verify that this computer can communicate with the computer running SQL Server.
Verify that SQL Server services are running.
Verify that Configuration Manager can access the Configuration Manager site database.
Verify that the Configuration Manager site database, transaction log, and tempdb are not full.
Verify that there are at least 50 SQL Server user connections, plus 5 for each Configuration Manager console.
If the problem persists, check the SQL Server error logs.
This alert is best handled by Configuration Manager administrators.
To investigate status messages:
1. In the Configuration Manager console, navigate to System Center Configuration Manager > Site Database > System Status > Status Message Queries.
2. Right-click All Status Messages from a Specific System, and then select Show Messages.
3. In the All Status Messages from a Specific System dialog box, you can either specify the Machine Name and Time, or you can load existing machine names from the database, and then click OK. The status messages for the appropriate selected parameters are displayed.
For more assistance, see a list of additional support options in the support section of the Configuration Manager Web site at Support for Configuration Manager 2007.
Target | Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation |
Category | EventCollection |
Enabled | True |
Alert Generate | False |
Remotable | True |
Comment | Mom2005ID='{2C11876F-59F8-4237-99FA-B1CCDEBD2787}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE} |
ID | Module Type | TypeId | RunAs |
---|---|---|---|
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_ | DataSource | System.Mom.BackwardCompatibility.FilteredEvent.DataProvider | Default |
GenerateAlert | WriteAction | System.Mom.BackwardCompatibility.AlertResponse | Default |
<Rule ID="SMSv4_Status__Collection_Evaluator_failed_to_enumerate_collections_1_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{2C11876F-59F8-4237-99FA-B1CCDEBD2787}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE}">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_" Comment="{F320DA51-13BF-11D3-B2CD-00A0C92A28B4}" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.FilteredEvent.DataProvider">
<Expression>
<And>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="Integer">EventDisplayNumber</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>2500</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>Equal</Operator>
<ValueExpression>
<Value>ConfigMgr 2007 Monitor SMS Status Messages</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="GenerateAlert" TypeID="System.Mom.BackwardCompatibility.AlertResponse">
<GenerateAlert>true</GenerateAlert>
<Owner/>
<Description>
$Data/Params/Param[1]$
- ConfigMgr 2007 Status: Collection Evaluator failed to enumerate collections.
$Data/EventDescription$
The status message contains message properties
Machine Name:
$Data/Params/Param[1]$
Module Name:
$Data/Params/Param[2]$
Component:
$Data/Params/Param[3]$
Message ID:
$Data/Params/Param[4]$
Win32 Error:
$Data/Params/Param[5]$
Top Level Site Code:
$Data/Params/Param[6]$
Database Record ID:
$Data/Params/Param[7]$
</Description>
<AlertLevel>40</AlertLevel>
<ResolutionState/>
<Source>
$Data/PublisherName$
</Source>
<Name>ConfigMgr 2007 Status: Collection Evaluator failed to enumerate collections</Name>
<InvokerType>0</InvokerType>
</WriteAction>
</WriteActions>
</Rule>