Home
  •  

System Center Orchestrator Management Server Database Connection Error

Microsoft.SystemCenter.2016.Orchestrator.ManagementServerDatabaseError.Alert (Rule)

This rule generates an alert if a database connectivity error is logged by the Management Server.

Knowledge Base article:

Summary

This rule generates an alert when a database connectivity error is logged by the System Center Orchestrator Management Server.

Causes

Resolutions

To resolve this Alert, perform the following procedures:

Element properties:

TargetMicrosoft.SystemCenter.2016.Orchestrator.Role.ManagementServer
CategoryAlert
EnabledTrue
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
RemotableTrue
Alert Message
System Center Orchestrator Management Server Database Connection Error

The System Center Orchestrator Management Server has logged a database connectivity error. Check the status of the SQL database.
Event Description: {0}

Member Modules:

ID Module Type TypeId RunAs 
LogDS DataSource Microsoft.SystemCenter.Orchestrator.LogFileParser.DataSource Default
Filter ConditionDetection System.ExpressionFilter Default
Alert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.SystemCenter.2016.Orchestrator.ManagementServerDatabaseError.Alert" Enabled="true" Target="Microsoft.SystemCenter.2016.Orchestrator.Role.ManagementServer" ConfirmDelivery="false" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>Alert</Category>

  <DataSources>

    <DataSource ID="LogDS" TypeID="SCO!Microsoft.SystemCenter.Orchestrator.LogFileParser.DataSource">

      <Interval>600</Interval>

      <Directory>%ProgramData%\Microsoft System Center 2012\Orchestrator\ManagementService.exe\Logs</Directory>

      <StringToMatch>Cannot open DB Connection</StringToMatch>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="Filter" TypeID="System!System.ExpressionFilter">

    <Expression>

      <SimpleExpression>

        <ValueExpression>

          <XPathQuery Type="String">Property[@Name='LogMatch']</XPathQuery>

        </ValueExpression>

        <Operator>Equal</Operator>

        <ValueExpression>

          <Value Type="String">True</Value>

        </ValueExpression>

      </SimpleExpression>

    </Expression>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="Alert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>1</Severity>

      <AlertMessageId>$MPElement[Name="Microsoft.SystemCenter.2016.Orchestrator.ManagementServerDatabaseError.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/Property[@Name='Messages']$</AlertParameter1>

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

    </WriteAction>

  </WriteActions>

</Rule>