ConfigMgr 2007 Consolidated Status: PXE Service Point failed to look up a device in the database

SMSv4_Consolidated_Status__PXE_Service_Point_failed_to_look_up_a_device_in_the_database_1_Rule (Rule)

Knowledge Base article:

Summary

The PXE service point failed to look up a device in the database. The PXE service point could not connect to the database to perform a query.

The PXE service point must query the database to find whether a given device is known. If the device is known, a small network boot program that handles the PXE process is downloaded to the device.

Causes

This condition could occur because:

Resolutions

Ensure that the PXE service point can communicate with the database server.

Element properties:

TargetMicrosoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation
CategoryEventCollection
EnabledFalse
Alert GenerateFalse
RemotableTrue
CommentMom2005ID='{21A868EE-860F-4CCD-8AC0-AF979A1CDBF5}';MOM2005ComputerGroupID={15348338-2E39-4B34-9DFF-4719AE7F1CCE}

Member Modules:

ID Module Type TypeId RunAs 
_F320DA51_13BF_11D3_B2CD_00A0C92A28B4_ DataSource System.Mom.BackwardCompatibility.FilteredEvent.DataProvider Default
ConsolidatedEventWriteAction WriteAction System.Mom.BackwardCompatibility.ConsolidatedEventResponse Default

Source Code:

<Rule ID="SMSv4_Consolidated_Status__PXE_Service_Point_failed_to_look_up_a_device_in_the_database_1_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Database_Servers_Installation" Enabled="false" ConfirmDelivery="false" Comment="Mom2005ID='{21A868EE-860F-4CCD-8AC0-AF979A1CDBF5}';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>6307</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="ConsolidatedEventWriteAction" TypeID="MomBackwardCompatibility!System.Mom.BackwardCompatibility.ConsolidatedEventResponse">
<ConsolidationProperties>
<PropertyXPathQuery>EventDisplayNumber</PropertyXPathQuery>
<PropertyXPathQuery>PublisherName</PropertyXPathQuery>
<PropertyXPathQuery>EventDescription</PropertyXPathQuery>
</ConsolidationProperties>
<Interval>3600</Interval>
</WriteAction>
</WriteActions>
</Rule>