Home
  •  

Temporary database accessible

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

The monitor raises an alert if the deployment watcher fails to connect to Reporting Services Temporary Database.

Knowledge Base article:

Summary

The monitor raises an alert if the deployment watcher fails to connect to Reporting Services Temporary Database.

Causes

There are various causes why a reportServertempDb does not behave as expected. The following article talks and walks through some of the troubleshooting steps that can help with the situation.

http://technet.microsoft.com/en-us/library/ms159093.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.

900

Synchronization Time

 

 

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.2012.ReportingServices.DeploymentWatcher
Parent MonitorSystem.Health.AvailabilityState
CategoryPerformanceHealth
EnabledTrue
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.2012.ReportingServices.MonitorType.Instance.DBConnectionMonitor
RemotableTrue
AccessibilityPublic
Alert Message
SSRS 2012: Deployment watcher cannot connect to Reporting Services Temporary Database
Deployment watcher cannot connect to Reporting Services Temporary Database. Received error message:
{0}
RunAsDefault

Source Code:

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

  <Category>PerformanceHealth</Category>

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

    <AlertOnState>Error</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>Error</AlertSeverity>

    <AlertParameters>

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

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

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

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

  </OperationalStates>

  <Configuration>

    <DatabaseServerName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher"]/ServerFQDN$</DatabaseServerName>

    <DatabaseInstanceName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher"]/DBInstanceName$</DatabaseInstanceName>

    <DatabaseName>$Target/Property[Type="SQLRS!Microsoft.SQLServer.2012.ReportingServices.DeploymentWatcher"]/TDBName$</DatabaseName>

    <TimeOut>300</TimeOut>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

  </Configuration>

</UnitMonitor>