Home
  •  

Temporary database accessible

Microsoft.SQLServer.ReportingServices.Core.Monitor.DeploymentWatcher.TempDBConnection (UnitMonitor)

The monitor alerts if the deployment watcher fails to connect to Reporting Services Temporary Database.

Knowledge Base article:

Summary

The monitor alerts if the deployment watcher fails to connect to Reporting Services Temporary Database.

Causes

There are many issues causing a monitoring workflow failure to connect to the database.

Some of them are as follows:

Resolutions

External

Configure a Report Server Database Connection (SSRS Configuration Manager)

Troubleshooting Server and Database Connection Problems

Administer a Report Server Database (SSRS Native Mode)

Overridable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

Yes

Interval (seconds)

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

900

Synchronization Time

The synchronization time specified by using a 24-hour format. May be omitted.

 

Timeout for database connection (seconds)

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

200

Timeout (seconds)

Specifies the time the workflow is allowed to run before being closed and marked as failed.

300

Element properties:

TargetMicrosoft.SQLServer.ReportingServices.Core.DeploymentWatcher
Parent MonitorSystem.Health.AvailabilityState
CategoryPerformanceHealth
EnabledFalse
Alert GenerateTrue
Alert SeverityError
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor TypeMicrosoft.SQLServer.ReportingServices.Core.MonitorType.DeploymentWatcher.DBConnection
RemotableTrue
AccessibilityPublic
Alert Message
SSRS: Deployment watcher cannot connect to Reporting Services Temporary Database
Deployment watcher cannot connect to Reporting Services Temporary Database. Error message is received:
{0}
RunAsDefault

Source Code:

<UnitMonitor ID="Microsoft.SQLServer.ReportingServices.Core.Monitor.DeploymentWatcher.TempDBConnection" Accessibility="Public" Enabled="false" Target="Microsoft.SQLServer.ReportingServices.Core.DeploymentWatcher" ParentMonitorID="Health!System.Health.AvailabilityState" Remotable="true" Priority="Normal" TypeID="Microsoft.SQLServer.ReportingServices.Core.MonitorType.DeploymentWatcher.DBConnection" ConfirmDelivery="false">

  <Category>PerformanceHealth</Category>

  <AlertSettings AlertMessage="Microsoft.SQLServer.ReportingServices.Core.Monitor.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>

    <DBMachineName>$Target/Property[Type='Microsoft.SQLServer.ReportingServices.Core.DeploymentWatcher']/DBServerName$</DBMachineName>

    <DBInstanceName>$Target/Property[Type='Microsoft.SQLServer.ReportingServices.Core.DeploymentWatcher']/DBInstanceName$</DBInstanceName>

    <DBConnectionString>$Target/Property[Type='Microsoft.SQLServer.ReportingServices.Core.DeploymentWatcher']/DBConnectionString$</DBConnectionString>

    <DBName>$Target/Property[Type='Microsoft.SQLServer.ReportingServices.Core.DeploymentWatcher']/TempDBName$</DBName>

    <SqlTimeoutSeconds>15</SqlTimeoutSeconds>

    <TimeoutSeconds>300</TimeoutSeconds>

    <IntervalSeconds>900</IntervalSeconds>

    <SyncTime/>

  </Configuration>

</UnitMonitor>