Retail POS Offline Database Connectivity

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

Monitors whether Retail POS can connect to the Offline Database.

Knowledge Base article:

Summary

Monitors the connection between Retail POS and offline database.

Causes

The server that hosts the offline database is unreachable or has been shut down.
The user account which runs Retail POS does not have appropriate permissions in the offline database.
The offline 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 user which runs Retail POS application has the correct permissions in SQL Server for the offline database.
Make sure the offline database was provisioned correctly during installation. Reprovision the database following the installation guide if necessary.

View Online Content

Element properties:

Target

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

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

Retail POS Offline Database Connectivity

Retail POS failed to connect to the offline database.

This will prevent Retail POS from functioning if the channel database is not available and Retail POS is in offline mode.

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.RetailPosOfflineDatabaseConnectivity" Accessibility="Public" Enabled="true" Target="Base!Microsoft.Dynamics.Retail.AX2012.R2.FP.Base.Class.RetailPos" 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.RetailPosOfflineDatabaseConnectivity_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">10710</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 : Retail POS</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">10709</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 : Retail POS</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>