Home
  •  

Misconfigured data sources

Microsoft.SQLServer.2008.ReportingServices.UnitMonitor.DeploymentWatcher.MisconfiguredDataSources (UnitMonitor)

The monitor alerts if misconfigured data sources are detected.

Knowledge Base article:

Summary

The monitor alerts if the number of misconfigured data sources is higher than threshold.

Some reports may use shared datasources to retrieve the data. If the shared datasource has been removed or re-deployed, the link between report and shared datasource may become invalid. Report execution may fail in this case.

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.

604800

Synchronization Time

 

 

Threshold

The monitor will change state and register an alert if the number of misconfigured data sources is higher than threshold.

0

Time out for database connection

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

300

Element properties:

TargetMicrosoft.SQLServer.2008.ReportingServices.DeploymentWatcher
Parent MonitorSystem.Health.ConfigurationState
CategoryConfigurationHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2008.ReportingServices.MonitorType.DeploymentWatcher.MisconfiguredDataSources
RemotableTrue
AccessibilityPublic
Alert Message
SSRS 2008: There are misconfigured data sources
There are misconfigured data sources
RunAsDefault

Source Code:

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

  <Category>ConfigurationHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.2008.ReportingServices.UnitMonitor.DeploymentWatcher.MisconfiguredDataSources.AlertMessage">

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters/>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <Threshold>0</Threshold>

    <IntervalSeconds>604800</IntervalSeconds>

    <TimeOut>300</TimeOut>

    <SyncTime/>

  </Configuration>

</UnitMonitor>