Management Configuration service could not connect to the database in the last 15 min.(Warning Level)

Microsoft.ServiceManager.ConfigurationService.DatabaseConnectivityWarningLevel (UnitMonitor)

The Management Configuration service can not receive any configuration changes from the database in this state.

Knowledge Base article:

Summary

This monitor detects when the Management Configuration service has continuing problems connecting to the Service Manager database that for a period of time.

Causes

This is usually caused by some problem with network connectivity or database integrity problem.
The default configuration is to generate a critical state when the Management Configuration service could not completely verify connectivity to the database or receive any configuration change in the last 15 minutes.

Resolutions

Check connectivity from the Management Server to the Service Manager Database server. Note that you need to monitor the ongoing network connectivity since intermittent network problems may hide the problem.
If state remains critical and Health Services in your Service Manager infrastructure are not getting updated Management Packs or configuration, contact Customer Support Services (CSS) with the name of this rule and information from the context of the state change event.

Element properties:

Target	Microsoft.SystemCenter.ServiceManager.ManagementServer
Parent Monitor	Microsoft.ServiceManager.ConfigurationService.DatabaseConnectivityHealthRollup
Category	System
Enabled	True
Alert Generate	False
Alert Auto Resolve	True
Monitor Type	Microsoft.Windows.MissingCorrelatedEventLogSingleEventLog2StateMonitorType
Remotable	True
Accessibility	Public
RunAs	Default

Source Code:

<UnitMonitor ID="Microsoft.ServiceManager.ConfigurationService.DatabaseConnectivityWarningLevel" Accessibility="Public" Enabled="true" Target="SM!Microsoft.SystemCenter.ServiceManager.ManagementServer" ParentMonitorID="Microsoft.ServiceManager.ConfigurationService.DatabaseConnectivityHealthRollup" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.MissingCorrelatedEventLogSingleEventLog2StateMonitorType" ConfirmDelivery="false">

  <Category>System</Category>

  <OperationalStates>

    <OperationalState ID="Healthy" MonitorTypeStateID="EventRaised" HealthState="Success"/>

    <OperationalState ID="NotHealthy" MonitorTypeStateID="MissingCorrelatedEventRaised" HealthState="Warning"/>

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>

    <LogName>Operations Manager</LogName>

    <Expression>

      <Or>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="UnsignedInteger">29201</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">OpsMgr Config Service</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="UnsignedInteger">29000</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">OpsMgr Config Service</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </Or>

    </Expression>

    <FirstMissingCorrelatedComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</FirstMissingCorrelatedComputerName>

    <FirstMissingCorrelatedLogName>Operations Manager</FirstMissingCorrelatedLogName>

    <FirstMissingCorrelatedExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

              <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="UnsignedInteger">29200</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">OpsMgr Config Service</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </FirstMissingCorrelatedExpression>

    <SecondMissingCorrelatedComputerName>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</SecondMissingCorrelatedComputerName>

    <SecondMissingCorrelatedLogName>Operations Manager</SecondMissingCorrelatedLogName>

    <SecondMissingCorrelatedExpression>

      <Or>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="UnsignedInteger">29201</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">OpsMgr Config Service</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

        <Expression>

          <And>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

                  <XPathQuery Type="UnsignedInteger">EventDisplayNumber</XPathQuery>

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="UnsignedInteger">29000</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

            <Expression>

              <SimpleExpression>

                <ValueExpression>

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

                </ValueExpression>

                <Operator>Equal</Operator>

                <ValueExpression>

                  <Value Type="String">OpsMgr Config Service</Value>

                </ValueExpression>

              </SimpleExpression>

            </Expression>

          </And>

        </Expression>

      </Or>

    </SecondMissingCorrelatedExpression>

    <Correlator>

      <CorrelationExpression>

        <Expression/>

      </CorrelationExpression>

      <Count>1</Count>

      <Interval>900</Interval>

      <CorrelationOrder>InSequence</CorrelationOrder>

      <CorrelationItemPolicy>Last</CorrelationItemPolicy>

    </Correlator>

  </Configuration>

</UnitMonitor>