ConfigMgr 2007 Component: Policy Provider failed to get new software update policies from the SMS Site Database

SMSv4_Component__Policy_Provider_failed_to_get_new_software_update_policies_from_the_SMS_Site_Database__19_Rule (Rule)

Knowledge Base article:

Summary

The policy provider failed to read new software update policies from the Configuration Manager site database. The software distribution of these policies is blocked.

Causes

Consult the Policypv.log on the provider system for information about this event. Verify that the SQL Server Account for the Configuration Manager database is properly configured.

Additional

This alert is best handled by Configuration Manager administrators.

External

For more assistance, see the list of additional support options in the support section of the Configuration Manager Web site at Support for Configuration Manager 2007.

Element properties:

Target	Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Servers_Installation
Category	EventCollection
Enabled	True
Alert Generate	False
Remotable	True
Comment	Mom2005ID='{02E53FDE-457E-4B47-9995-76585D926D2D}';MOM2005ComputerGroupID={D0741372-F3F6-43EB-8B8B-965F937BCC65}

Member Modules:

ID	Module Type	TypeId	RunAs
_7DC47213_EF6B_429F_A551_809358541FFE_	DataSource	System.Mom.BackwardCompatibility.GenericLogProvider2	Default
CollectEventData	WriteAction	Microsoft.SystemCenter.CollectEvent	Default
CollectEventDataWarehouse	WriteAction	Microsoft.SystemCenter.DataWarehouse.PublishEventData	Default
GenerateAlert	WriteAction	System.Mom.BackwardCompatibility.AlertResponse	Default

Source Code:

<Rule ID="SMSv4_Component__Policy_Provider_failed_to_get_new_software_update_policies_from_the_SMS_Site_Database__19_Rule" Target="Microsoft.SystemCenter.ConfigurationManager.2007.Microsoft_SMSv4_Site_Servers_Installation" Enabled="true" ConfirmDelivery="false" Comment="Mom2005ID='{02E53FDE-457E-4B47-9995-76585D926D2D}';MOM2005ComputerGroupID={D0741372-F3F6-43EB-8B8B-965F937BCC65}">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="_7DC47213_EF6B_429F_A551_809358541FFE_" Comment="{7DC47213-EF6B-429F-A551-809358541FFE}" TypeID="System.Mom.BackwardCompatibility.GenericLogProvider2">

      <PublisherName>ConfigMgr 2007 Policy Provider Log</PublisherName>

      <DirectoryRecords>

        <DirectoryRecord>

          <Directory>%SMS_INSTALL_DIR_PATH%\Logs</Directory>

          <Patterns>

            <Pattern>policypv.log</Pattern>

          </Patterns>

        </DirectoryRecord>

      </DirectoryRecords>

      <Expression>

        <RegExExpression>

          <ValueExpression>

            <XPathQuery Type="String">EventDescription</XPathQuery>

          </ValueExpression>

          <Operator>ContainsSubstring</Operator>

          <Pattern>CPolicySource::CreateSoftwareUpdatePolicy: could not execute SQL cmd </Pattern>

        </RegExExpression>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

    <WriteAction ID="GenerateAlert" TypeID="System.Mom.BackwardCompatibility.AlertResponse">

      <GenerateAlert>true</GenerateAlert>

      <Owner/>

      <Description>

            $Data/LoggingComputer$

           - ConfigMgr 2007 Component: Policy Provider failed to get new software update policies from the SMS Site Database.





            $Data/EventDescription$

          </Description>

      <AlertLevel>40</AlertLevel>

      <ResolutionState/>

      <Source>

            $Data/PublisherName$

          </Source>

      <Name>ConfigMgr 2007 Component: Policy Provider failed to get new software update policies from the SMS Site Database </Name>

      <InvokerType>0</InvokerType>

    </WriteAction>

    <WriteAction ID="CollectEventData" TypeID="SystemCenterLibrary!Microsoft.SystemCenter.CollectEvent"/>

    <WriteAction ID="CollectEventDataWarehouse" TypeID="DataWarehouseLibrary!Microsoft.SystemCenter.DataWarehouse.PublishEventData"/>

  </WriteActions>

</Rule>