Home
  •  

Async Service Has Problems Accessing Org DB

Microsoft.Dynamics.CRM.4.0.Async_Service_Has_Problems_Accessing_Org_DB (Rule)

Knowledge Base article:

Summary

The Microsoft Dynamics CRM Asynchronous Processes service has encountered multiple errors while attempting to access the CRM database.

Causes

This problem can occur if Microsoft Dynamics CRM Asynchronous Processing Service cannot connect to the CRM database.

Resolutions

Verify that Microsoft SQL Server is running. Also verify that there are no network problems.

Element properties:

TargetMicrosoft.Dynamics.CRM.4.0.Microsoft_CRM_4_Asynchronous_Processing_Service_Server
CategoryEventCollection
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
RemotableTrue
Alert Message
Async service has problems accessing Org DB.
{0}
Event LogSystem

Member Modules:

ID Module Type TypeId RunAs 
DS DataSource Microsoft.Windows.EventProvider Default
ConsolidatedEvent ConditionDetection System.ConsolidatorCondition Default
Alert WriteAction System.Health.GenerateAlert Default

Source Code:

<Rule ID="Microsoft.Dynamics.CRM.4.0.Async_Service_Has_Problems_Accessing_Org_DB" Enabled="true" Target="Microsoft.Dynamics.CRM.4.0.Microsoft_CRM_4_Asynchronous_Processing_Service_Server" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>EventCollection</Category>

  <DataSources>

    <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.EventProvider">

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

      <LogName>System</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

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

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

                <XPathQuery Type="Integer">EventLevel</XPathQuery>

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="Integer">1</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="String">MSCRMAsyncService</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <ConditionDetection ID="ConsolidatedEvent" TypeID="System!System.ConsolidatorCondition">

    <Consolidator>

      <ConsolidationProperties>

        <PropertyXPathQuery>EventDisplayNumber</PropertyXPathQuery>

        <PropertyXPathQuery>PublisherName</PropertyXPathQuery>

      </ConsolidationProperties>

      <TimeControl>

        <WithinTimeSchedule>

          <Interval>3600</Interval>

        </WithinTimeSchedule>

      </TimeControl>

      <CountingCondition>

        <CountMode>OnNewItemNOP_OnTimerOutputRestart</CountMode>

      </CountingCondition>

    </Consolidator>

  </ConditionDetection>

  <WriteActions>

    <WriteAction ID="Alert" TypeID="Health!System.Health.GenerateAlert">

      <Priority>1</Priority>

      <Severity>2</Severity>

      <AlertOwner/>

      <AlertMessageId>$MPElement[Name="Microsoft.Dynamics.CRM.4.0.Async_Service_Has_Problems_Accessing_Org_DB.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

        <AlertParameter1>$Data/EventDescription$</AlertParameter1>

      </AlertParameters>

      <Suppression>

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

      </Suppression>

      <Custom1/>

      <Custom2/>

      <Custom3/>

      <Custom4/>

      <Custom5/>

      <Custom6/>

      <Custom7/>

      <Custom8/>

      <Custom9/>

      <Custom10/>

    </WriteAction>

  </WriteActions>

</Rule>