Solved

SSRS Data-Driven Subscription:  How to find error details

Posted on 2014-02-27
3
5,717 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

895 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now