Monitoring Subscription Status

Individual users can monitor the status of a subscription using the My Subscriptions page or a Subscriptions tab in Report Manager. Subscription pages include columns that indicate when the subscription was last run and the status of the subscription. If an error occurs during delivery, an entry is made in the report server trace log. Errors that occur while a subscription is being processed are indicated in the Status column. The following table describes the status values.

Status Description

New subscription

Appears when you first create the subscription.


Appears when a subscription is cannot be processed. For more information, see "Managing Inactive Subscriptions" later in this topic.

Done: <number> processed of <number> total; <number> errors.

Shows the status of a data-driven subscription execution; this message is from the Scheduling and Delivery Processor.

<number> processed

The number of notifications that the Scheduling and Delivery Processor successfully delivered or is no longer attempting to deliver. When a data-driven delivery completes, the number of processed notifications should equal the total number of generated notifications.

<number> total

The total number of notifications generated for the last delivery for the subscription.

<number> error

The number of notifications that the Scheduling and Delivery Processor could not deliver or is no longer attempting to deliver.

Failure sending mail: the transport failed to connect to the server.

Indicates that the report server did not connect to the mail server; this message is from the e-mail delivery extension.

File <filename> was written to <path>.

Indicates that the delivery to the file share location was successful; this message is from the file share delivery extension.

An unknown error occurred when writing file.

Indicates that the delivery to the file share location did not succeed; this message is from the file share delivery extension.

Failure connecting to the destination folder, <path>. Verify the destination folder or file share exists.

Indicates that the folder you specified could not be found; this message is from the file share delivery extension.

The file <filename> could not be written to <path>. Attempting to retry.

Indicates that the file could not be updated with a newer version; this message is from the file share delivery extension.

Failure writing file <filename>: <message>

Indicates that the delivery to the file share location did not succeed; this message is from the file share delivery extension.

<custom status messages>

Status messages about delivery success and failure, provided by delivery extensions. If you are using a third-party or custom delivery extension, additional status messages may be provided.

Status messages are updated when the subscription is scheduled to process. If the trigger never occurs (for example, a report execution snapshot is never refreshed or a schedule never runs), the status message will not be updated.

Report server administrators can review the reportserverservice_*.log files to determine subscription delivery status. For e-mail delivery, report server log files include a record of processing and deliveries to specific e-mail accounts.

The log file does not include information about whether the report was opened, or whether the delivery actually succeeded. Successful delivery means that there were no errors generated by the Scheduling and Delivery Processor, and that the report server connected to the mail server. If the e-mail resulted in an undeliverable message error in the user mailbox, that information will not be included in the log file. For more information about log files, see Reporting Services Log Files.

Report server administrators can also monitor standard subscriptions that are currently processing. Data-driven subscriptions cannot be monitored. For more information, see Managing a Running Process.

If a subscription cannot be delivered (for example, if the mail server is unavailable), the delivery extension retries the delivery. A configuration setting specifies the number of attempts to make. The default value is no retries. In some cases, the report might have been processed without data (for example, if the data source is offline), in which case text to that effect is provided in the body of the message.

Managing Inactive Subscriptions

If a subscription becomes inactive, you should either delete it or reactivate it by resolving the underlying conditions that prevent it from being processed. Subscriptions can become inactive if conditions occur that prevent processing. These conditions include:

  • Removing or uninstalling the delivery extension specified in the subscription.
  • Changing credential settings from stored to integrated or prompted values.
  • Changing a parameter name or data type in the report definition and then republishing a report. If a subscription includes a parameter that is no longer valid, the subscription becomes inactive. For more information, see Setting Parameters in a Subscription.
  • Changing the execution mode of a report (for example, modifying an on-demand report so that it runs as a report execution snapshot). For more information, see Setting Report Execution Properties.

An inactive subscription is indicated by a message in the subscription itself. The message includes information about the cause and what steps you should take to reactivate the subscription.

When conditions cause the subscription to become inactive, the subscription reflects this fact when the report server runs the subscription. If a subscription is scheduled to deliver a report every Friday at 2:00 A.M., and the delivery extension it uses was uninstalled on Monday at 9:00 A.M., the subscription will not reflect its inactive state until Friday at 2:00 A.M.

See Also


Troubleshooting Subscription and Delivery Problems

Other Resources

Managing Subscriptions
Delivering Reports Through Subscriptions

Help and Information

Getting SQL Server 2005 Assistance