User Services: Update Maintenance Health

Microsoft.LS.2013.Monitoring.UnitMonitor.TimerResetEvent.Registrar.ES_E_UPDATE_ESSETTINGS_SPROC_FAILED (UnitMonitor)

Knowledge Base article:

Summary

Failed to execute the stored procedure DbSetMultipleConfigValue on the back-end. The global user settings were not updated in the database. An attempt to retry the update has been scheduled.

Causes

Typically occurs when the back-end is down or not reachable.

Resolutions

Verify the back-end is up and this server has connectivity to it.

Element properties:

Target

Microsoft.LS.2013.Component.Registrar

Parent Monitor

System.Health.AvailabilityState

Category

AvailabilityHealth

Enabled

True

Alert Generate

True

Alert Severity

Error

Alert Priority

Normal

Alert Auto Resolve

True

Monitor Type

Microsoft.LS.2013.MonitorType.TimerResetEvent.Repeated

Remotable

True

Accessibility

Public

Alert Message

[LYNC] Failed to execute the stored procedure DbSetMultipleConfigValue on the back-end. The global user settings were not updated in the database. An attempt to retry the update has been scheduled.

{0}

Please see the 'Product Knowledge' and the 'Alert Context' tab on Alert Properties view for more information.

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.LS.2013.Monitoring.UnitMonitor.TimerResetEvent.Registrar.ES_E_UPDATE_ESSETTINGS_SPROC_FAILED" Accessibility="Public" Enabled="true" Target="Microsoft.LS.2013.Component.Registrar" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.LS.2013.MonitorType.TimerResetEvent.Repeated" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Alert_Failed_to_execute_the_stored_procedure_DbSetMultipleConfigValue_on_the_back_end._The_global_user_settings_were_not_updated_in_the_database.__An_attempt_to_retry_the_update_has_been_scheduled.">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Context/DataItem/EventDescription$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Microsoft.LS.2013.Monitoring.UnitMonitor.TimerResetEvent.Registrar.ES_E_UPDATE_ESSETTINGS_SPROC_FAILED.Timer" MonitorTypeStateID="TimerEventRaised" HealthState="Success"/>

    <OperationalState ID="Microsoft.LS.2013.Monitoring.UnitMonitor.TimerResetEvent.Registrar.ES_E_UPDATE_ESSETTINGS_SPROC_FAILED.Repeated" MonitorTypeStateID="RepeatedEventRaised" HealthState="Error"/>

  </OperationalStates>

  <Configuration>

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

    <LogName>Lync Server</LogName>

    <ErrorExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">LS User Services</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </ErrorExpression>

    <AutoResolveInterval>3600</AutoResolveInterval>

    <TimerWindowInSeconds>1800</TimerWindowInSeconds>

    <RepeatCount>10</RepeatCount>

  </Configuration>

</UnitMonitor>