Windows Azure Pack SQL Error Restoring Existing Database Monitor

WindowsAzurePack.Monitor.ErrorRestoringExistingDatabase.SqlServers (UnitMonitor)

Error restoring existing database.

Element properties:

Source Code:

<UnitMonitor ID="WindowsAzurePack.Monitor.ErrorRestoringExistingDatabase.SqlServers" Accessibility="Public" Enabled="true" Target="WindowsAzurePack.ResourceProvider.SqlServers" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Windows!Microsoft.Windows.2SingleEventLog2StateMonitorType" ConfirmDelivery="false" Comment="WAP Monitor Event for MySQL Resource Provider">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="WindowsAzurePack.Monitor.ErrorRestoringExistingDatabase.AlertMessage.SqlServers">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="FirstEventRaised" MonitorTypeStateID="FirstEventRaised" HealthState="Error"/>

    <OperationalState ID="SecondEventRaised" MonitorTypeStateID="SecondEventRaised" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

    <!-- Computer name for the first event.  We will use a variable to get the target computer name. -->

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

    <!-- Name of the log containing the first event. -->

    <FirstLogName>Microsoft-WindowsAzurePack-MgmtSvc-SQLServer/Operational</FirstLogName>

    <!-- Expression for the first event -->

    <FirstExpression>

      <And>

        <!-- Expression for the first event number -->

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <!-- Expression for the first event source -->

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft-WindowsAzurePack-MgmtSvc-SQLServer</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </FirstExpression>

    <!-- Computer name for the second event.  We will use a variable to get the target computer name. -->

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

    <!-- Name of the log containing the first event. -->

    <SecondLogName>Microsoft-WindowsAzurePack-MgmtSvc-SQLServer/Operational</SecondLogName>

    <!-- Expression for the second event -->

    <SecondExpression>

      <And>

        <!-- Expression for the second event number -->

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <!-- Expression for the second event source -->

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft-WindowsAzurePack-MgmtSvc-SQLServer</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </SecondExpression>

  </Configuration>

</UnitMonitor>