Solved

SSRS Data-Driven Subscription:  How to find error details

Posted on 2014-02-27
3
6,061 Views
Last Modified: 2014-03-07
Hi All

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

Thanks.
Jim
0
Comment
Question by:Jim Horn
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39894549
Hey Jim,

Afaik the SSRS trace log file is the place where you need to look.  If they don't want to give you access to the server, perhaps you can ask them for a copy of the file?

Here's a detailed blog post on how to locate the appropriate lines in the files, working from the Schedule ID of the subscription: Troubleshooting Subscriptions: Part II, Using the Reporting Services Trace Log File

V
0
 
LVL 65

Author Closing Comment

by:Jim Horn
ID: 39912795
The gig has ended, so I can't verify this solution led to success, but I suspect it does.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
TSQL XML Namespaces 7 24
Migration from SQL server to oracle (XML input) 4 27
query linked sql table field from access 4 22
Parse this column 6 27
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question