Post reply

Data Driven subscription gives errors - how can we get the error message

  • January 27, 2012 at 9:16 am

    #255565

    I have a DATA DRIVEN SUBSCRIPTION.

    When I visit "My Subscriptions" page I see an messages about an error under the status column. How do I find details of the error.

  • January 27, 2012 at 2:13 pm

    #1439617

    There is a view (at least in 2008) in the SSRS database called ExecutionLog or ExecutionLog2 that may help.

    There are also text based trace (log) files on the Reporting server. The path to these files in 2008 is Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\LogFiles. It may be something like Program Files\Microsoft SQL Server\MSRS9.MSSQLSERVER\Reporting Services\LogFiles or some other minor variation. These log files can be very helpful, but very difficult to work your way through. Make sure you have the last time the report tried to run, and the name of the report to help you find the entries you need.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply