Access Services 2010: Cannot Create Session Cache

Microsoft.SharePoint.2016.SPServiceInstance.Access.AccSrv14CannotCreateSessionCache (UnitMonitor)

A critical state of this Monitor indicates that the back end application server Access Data Services machine was not able to create an in memory cache for a user session. Users may be unable to use that specific machine for querying data for Access Services applications.

Knowledge Base article:

Summary

To get the most current Knowledge Article from the Microsoft TechNet site, visit:

http://go.microsoft.com/fwlink/?LinkId=244842

Causes

View all current alerts from this object using this link:

View Alerts

Element properties:

Target

Microsoft.SharePoint.2016.SPServiceInstance.Access

Parent Monitor

System.Health.AvailabilityState

Category

AvailabilityHealth

Enabled

False

Alert Generate

True

Alert Severity

Error

Alert Priority

High

Alert Auto Resolve

True

Monitor Type

Microsoft.Windows.SingleEventLogTimer2StateMonitorType

Remotable

True

Accessibility

Public

Alert Message

Access Services 2010: Cannot Create Session Cache

A critical incident has occurred where the Excel Calculation Services portion of Access Data Services is down. Due to this issue, access service is not able to create session cache.

Event ID: {0}
Event Description: {1}

RunAs

Default

Source Code:

<UnitMonitor ID="Microsoft.SharePoint.2016.SPServiceInstance.Access.AccSrv14CannotCreateSessionCache" Accessibility="Public" Enabled="false" Target="MOSS16Core!Microsoft.SharePoint.2016.SPServiceInstance.Access" ParentMonitorID="Health!System.Health.AvailabilityState" Priority="High" TypeID="Windows!Microsoft.Windows.SingleEventLogTimer2StateMonitorType">

  <Category>AvailabilityHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SharePoint.2016.SPServiceInstance.Access.AccSrv14CannotCreateSessionCache_AlertMessageResourceID">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>High</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/EventDisplayNumber$</AlertParameter1>

      <AlertParameter2>$Data/Context/EventDescription$</AlertParameter2>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <ComputerName>$Target/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">11</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

        <Expression>

          <SimpleExpression>

            <ValueExpression>

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

            </ValueExpression>

            <Operator>Equal</Operator>

            <ValueExpression>

              <Value Type="String">Microsoft-SharePoint Products-Access Services 2010</Value>

            </ValueExpression>

          </SimpleExpression>

        </Expression>

      </And>

    </Expression>

    <TimerWaitInSeconds>86400</TimerWaitInSeconds>

  </Configuration>

</UnitMonitor>