Async Client Message Database Connectivity

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

Monitors whether Async Client can connect to the message database.

Knowledge Base article:

Summary

Monitors the connection between Async Client and the message database.

Causes

The server that hosts the message database is unreachable or has been shut down.
The service account for Async Server does not have appropriate permissions in the message database.
The 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 that Async Server is configured to use the correct service account, and that the service account has the correct permissions in SQL Server for the message database.
Make sure the message database was provisioned correctly during installation. Reprovision the database following the installation guide if necessary.

For more information:

Async Client Configuration

View Online Content

Element properties:

Target

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

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 Client Message Database Connectivity

Async Client failed to connect to the channel message database.

This may cause data in the channel database to be out of date. Any unsynchronized changes to entities will not be visible at the dependent channels in that database. Entities that may be affected include:
* Products
* Prices
* Discounts
* Worker permissions

Customer transactions will not be uploaded to Retail headquarters. This type of disruption by itself does not prevent simple transactions from being processed at the dependent channels.

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.CdxSynchServiceClientMessageDBConnectivity" Accessibility="Public" Enabled="true" Target="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceClient" 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.CdxSynchServiceClientMessageDBConnectivity_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">10241</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 Client $Target/Property[Type="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceClient"]/ServiceName$</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">10240</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 Client $Target/Property[Type="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.CdxSynchServiceClient"]/ServiceName$</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>