Async Server Message Database Connectivity

Microsoft.Dynamics.Retail.AX2012.R2.FP.Monitoring.Monitor.CdxSynchServiceServerMessageDBConnectivity (UnitMonitor)

Monitors whether Async Server can connect to the message database.

Knowledge Base article:

Summary

Monitors the connection between Async Server and the head office message database.

Causes

The instance of SQL Server that hosts the head office database is unreachable or has been shut down.
The application pool identity does not have permission to access the head office message database.
The head office message database has not been provisioned.

Resolutions

Make sure the SQL Server is running and that the SQL Server can be reached through the network. Specifically, check for incorrect firewall settings or network configuration issues.
Make sure the application pool has the correct identity and the identity has the correct permissions on SQL Server for the head office message database.
Make sure the head office message database was provisioned correctly during installation. Reprovision the database following the installation guide if necessary.

For more information:

Async Server Configuration

View Online Content

Element properties:

Target

Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceServer

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.Windows.RepeatedEventLogSingleEventLog2StateMonitorType

Remotable

False

Accessibility

Public

Alert Message

Async Server Message Database Connectivity

Async Server failed to connect to the headquarters message database.

All uploads and downloads between Async Server and the Async Clients that depend on it will be affected. Any data changes initiated at Retail headquarters will not be available at any of the dependent channels. Recent transactions will also not be uploaded to Microsoft Dynamics AX. However, when connectivity is restored, any new jobs will include data that previously failed to upload or download.

Additional event information for this disruption:

Time first: {0}
Time last: {1}

Count: {2}

Event description: {3}

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.Dynamics.Retail.AX2012.R2.FP.Monitoring.Monitor.CdxSynchServiceServerMessageDBConnectivity" Accessibility="Public" Enabled="true" Target="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceServer" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="false" Priority="Normal" TypeID="Windows!Microsoft.Windows.RepeatedEventLogSingleEventLog2StateMonitorType" ConfirmDelivery="true">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.Dynamics.Retail.AX2012.R2.FP.Monitoring.Monitor.CdxSynchServiceServerMessageDBConnectivity_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/TimeFirst$</AlertParameter1>

      <AlertParameter2>$Data/Context/TimeLast$</AlertParameter2>

      <AlertParameter3>$Data/Context/Count$</AlertParameter3>

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

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

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

    <LogName>Application</LogName>

    <Expression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft Dynamics AX Retail Monitoring : Async Server $Target/Property[Type="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceServer"]/WebApplicationName$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </Expression>

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

    <RepeatedLogName>Application</RepeatedLogName>

    <RepeatedExpression>

      <And>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

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

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft Dynamics AX Retail Monitoring : Async Server $Target/Property[Type="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceServer"]/WebApplicationName$</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </RepeatedExpression>

    <Consolidator>

      <ConsolidationProperties/>

      <TimeControl>

        <WithinTimeSchedule>

          <Interval>86400</Interval>

        </WithinTimeSchedule>

      </TimeControl>

      <CountingCondition>

        <Count>2</Count>

        <CountMode>OnNewItemTestOutputRestart_OnTimerSlideByOne</CountMode>

      </CountingCondition>

    </Consolidator>

  </Configuration>

</UnitMonitor>