Home
  •  

An error occurred during execution of a SSAS 2012 MP managed module

Microsoft.SQLServer.2012.AnalysisServices.AlertRule.Seed.ModuleError (Rule)

The rule oversees the Event Log and watches for error events submitted by SSAS 2012 management pack. If one of the workflows (discovery, rule or monitor) fails, an event is logged and a critical alert is reported.

Knowledge Base article:

Summary

The rule oversees the Event Log and watches for error events submitted by SSAS 2012 management pack. If one of the workflows (discovery, rule or monitor) fails, the event is logged and a critical alert is reported.

Causes

Workflow may fail due to the number of reasons, including (but not limited to):

Resolutions

The resolution(s) depend upon the root causes, which must be investigated in each case when the issue occurs. The remediation action depends on the root cause. General recommendations are as follows:

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow

Yes

Priority

Defines Alert Priority

2

Severity

Defines Alert Severity

2

Element properties:

TargetMicrosoft.SQLServer.2012.AnalysisServices.EventLogCollectionTarget
CategoryAlert
EnabledTrue
Event_ID6200
Event SourceSSAS 2012 MP
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
RemotableTrue
Alert Message
SSAS 2012: An Error occurred during execution of a SSAS 2012 MP managed module
{0}
Event LogOperations Manager

Member Modules:

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

Source Code:

<Rule ID="Microsoft.SQLServer.2012.AnalysisServices.AlertRule.Seed.ModuleError" Target="SQLAS!Microsoft.SQLServer.2012.AnalysisServices.EventLogCollectionTarget" Enabled="true" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">

  <Category>Alert</Category>

  <DataSources>

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

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

      <LogName>Operations Manager</LogName>

      <Expression>

        <And>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

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

              </ValueExpression>

            </SimpleExpression>

          </Expression>

          <Expression>

            <SimpleExpression>

              <ValueExpression>

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

              </ValueExpression>

              <Operator>Equal</Operator>

              <ValueExpression>

                <Value Type="String">SSAS 2012 MP</Value>

              </ValueExpression>

            </SimpleExpression>

          </Expression>

        </And>

      </Expression>

    </DataSource>

  </DataSources>

  <WriteActions>

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

      <Priority>2</Priority>

      <Severity>2</Severity>

      <AlertName/>

      <AlertDescription/>

      <AlertOwner/>

      <AlertMessageId>$MPElement[Name="Microsoft.SQLServer.2012.AnalysisServices.AlertRule.Seed.ModuleError.AlertMessage"]$</AlertMessageId>

      <AlertParameters>

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

      </AlertParameters>

      <Suppression>

        <SuppressionValue/>

      </Suppression>

      <Custom1/>

      <Custom2/>

      <Custom3/>

      <Custom4/>

      <Custom5/>

      <Custom6/>

      <Custom7/>

      <Custom8/>

      <Custom9/>

      <Custom10/>

    </WriteAction>

  </WriteActions>

</Rule>