An error occurred during execution of a SSRS MP managed module

Microsoft.SQLServer.ReportingServices.Core.Rule.EventLogCollectionTarget.ModuleError (Rule)

The rule oversees the Event Log and watches for error and warning events submitted by SQL Server Reporting Services 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 and warning events submitted by SQL Server Reporting Services management pack. If one of the workflows (discovery, rule or monitor) fails, an event is logged, and a critical alert is reported.

Causes

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

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.ReportingServices.Core.EventLogCollectionTarget
CategoryAlert
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityHigh
RemotableTrue
Alert Message
SSRS: An error occurred during execution of a SSRS 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.ReportingServices.Core.Rule.EventLogCollectionTarget.ModuleError" Target="Microsoft.SQLServer.ReportingServices.Core.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">4221</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<SimpleExpression>
<ValueExpression>
<XPathQuery Type="UnsignedInteger">EventLevel</XPathQuery>
</ValueExpression>
<Operator>LessEqual</Operator>
<ValueExpression>
<Value Type="UnsignedInteger">2</Value>
</ValueExpression>
</SimpleExpression>
</Expression>
<Expression>
<RegExExpression>
<ValueExpression>
<XPathQuery Type="String">PublisherName</XPathQuery>
</ValueExpression>
<Operator>MatchesWildcard</Operator>
<Pattern>SQL Server Reporting *</Pattern>
</RegExExpression>
</Expression>
<Expression>
<RegExExpression>
<ValueExpression>
<XPathQuery>Params/Param[1]</XPathQuery>
</ValueExpression>
<Operator>MatchesRegularExpression</Operator>
<Pattern>^Management Group: "$Target/ManagementGroup/Name$"</Pattern>
</RegExExpression>
</Expression>
</And>
</Expression>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="Alert" TypeID="Health!System.Health.GenerateAlert">
<Priority>2</Priority>
<Severity>2</Severity>
<AlertName/>
<AlertDescription/>
<AlertOwner/>
<AlertMessageId>$MPElement[Name="Microsoft.SQLServer.ReportingServices.Core.Rule.EventLogCollectionTarget.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>