Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

On the report Subscriptions page, under "Status" for Last Run, it has the following error:

Failure sending mail: Report processing has been canceled by the user. Mail will not be resent.

It's a subscription, no person canceled this. Maybe there is a problem with a service.

I can run the report fine right now. The only log I can find is here:

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

There are two lines for the report:

notification!WindowsService_508!d24!02/10/2014-05:45:05:: i INFO: Handling subscription 75b94483-618d-4463-b6c0-90916b92cb6 to report ReportName, owner: domain\user, delivery extension: Report Server Email. library!WindowsService_508!d24!02/10/2014-05:45:05:: i INFO: RenderForNewSession('/Reports/ReportName')

These lines don't indicate an error occured. I've been looking through all of the logs I could find and I can't find any sort of description as to what would have caused this.

I would like to find out where this information is logged, so I can create a job that looks for messages like this to alert users of a failed report.

I would also like to know where the logs are in case I do need to troubleshoot something vague like this.

I really would appreciate any help :)

share|improve this question
add comment

2 Answers 2

I'm not 100% sure but you might try and query the execution log tables in the SSRS database. It should tell you everything about the execution of the report and the failure of the subscription I would thin.

share|improve this answer
add comment

You sometimes see this error when the report is cancelled due to a timeout. You can check the current timeout setting in Report Manager > Site Settings.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.