Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS report subscription ended with an error

I hate to cross post, but I wasn't getting any progress with this on serverfault and there appears to be a lot more activity with regard to reporting services here.

I've created a simple report in SSRS, and then tried my hand out with a data driven subscription. I can verify that the subscription runs on the 'My Subscriptions' page. Under Status it says Done: 1 processed of 1 total; 1 errors.

How do I find out what this error is?

I've looked in the Windows Event Logs and haven't found anything. I also checked the SQL Server Logs and nothing is there either.

like image 918
earthling Avatar asked Nov 24 '10 19:11

earthling


1 Answers

You need to look in the "Report Server Execution Log" which is a particular SQL Reporting Services log file.

See Reporting Services Log Files for details.

like image 164
John Sansom Avatar answered Oct 16 '22 01:10

John Sansom