Home
  •  

Number of failed report executions

Microsoft.SQLServer.2012.ReportingServices.UnitMonitor.DeploymentWatcher.NumberOfFailedReportExecutions (UnitMonitor)

The monitor alerts if the number of failed report executions, expressed as a percentage of total number of report executions, is higher than threshold. The monitor will raise an alert and change its state only when several consecutive checks have failed.

Knowledge Base article:

Summary

The monitor alerts if the number of failed report executions, expressed as a percentage of total number of report executions, is higher than threshold. The monitor will raise an alert and change its state only when several consecutive checks have failed.

Causes

Report executions can fail for variety of reasons, some of them can be

Resolutions

The following technet article walks through various troubleshooting steps that can be taken to identify why a report rendering is failing and how to fix the same

http://technet.microsoft.com/en-us/library/ms156290(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/cc879329(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/cc879330(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/cc879331(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/cc879328(v=sql.105).aspx

http://technet.microsoft.com/en-us/library/cc879334(v=sql.105).aspx

Overrideable Parameters

Name

Description

Default Value

Enabled

 

1

Generates Alerts

 

Yes

Interval (seconds)

The recurring interval of time in seconds in which to run the workflow.

300

Number of samples

Indicates how many times a measured value should breach a threshold before the state is changed.

6

Synchronization Time

 

 

Threshold

The monitor alerts if the number of failed report executions, expressed as a percentage of total number of report executions, is higher than threshold.

50

Time out for database connection

The workflow will fail and register an event if it cannot access the database during specified time interval.

200

Element properties:

TargetMicrosoft.SQLServer.2012.ReportingServices.DeploymentWatcher
Parent MonitorSystem.Health.PerformanceState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityWarning
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2012.ReportingServices.MonitorType.DeploymentWatcher.NumberOfFailedReportExecutions
RemotableTrue
AccessibilityPublic
Alert Message
SSRS 2012: Number of failed report executions is too high
Number of failed report executions ({0} \%) is too high.
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.2012.ReportingServices.UnitMonitor.DeploymentWatcher.NumberOfFailedReportExecutions" Accessibility="Public" Enabled="true" Target="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.2012.ReportingServices.MonitorType.DeploymentWatcher.NumberOfFailedReportExecutions" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2012.ReportingServices.UnitMonitor.DeploymentWatcher.NumberOfFailedReportExecutions.AlertMessage">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Warning</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/Property[@Name='ExecutionFailed']$</AlertParameter1>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Warning" MonitorTypeStateID="Warning" HealthState="Warning"/>

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

  </OperationalStates>

  <Configuration>

    <Threshold>50</Threshold>

    <NumSamples>6</NumSamples>

    <IntervalSeconds>300</IntervalSeconds>

    <TimeOut>200</TimeOut>

    <SyncTime/>

  </Configuration>

</UnitMonitor>