SSRS Data-Driven Subscription: How to find error details
Posted on 2014-02-27
I have a client that's running 2008R2, and an SSRS Data-Driven Subscription that is generating an error when executed, meaning on the Subscriptions tab, the Status for this subscription shows 'Done: 1 processed of 1 total; 1 errors.
Problem is the UI doesn't show details of this error afaik, and I don't know where to get them.
Looking through blogs I see views ExecutionLog (and ..2, and ..3), but don't see anything with this subscription name in it.
I'm also seeing in blogs a text log file at the below path, working on that as I don't have privs on this test server.
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles