Troubleshooting Failed Reporting Services Subscriptions

Most of the time subscriptions run fine, but what happens when they fail - how you figure out what is going wrong? Profiler might help you figure it out, depending on where in the process the subscription is failing, but it's not the first place to look. It's one of those times when you hope for a cool answer, but in the end it's what you would expect, a log file hidden away on disk that at least gives you a starting point. We'll show you where, and mention an interesting bit of maintenance you should be doing as well.

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Anil Babu on 3/9/2011

nice - thanks

Charlie Bruno on 3/9/2011

Interesting. You mention truncating reporting services log files by putting together a job to do this. It would be interesting to see how that is done.

Michael on 3/9/2011

Amazing, I've been having problems in our subscriptions here at work and resolving to restarting the server to fix the problem which sometimes works and other not has not helped. At least now I can see where the source of the problem is.

Don Weigend on 3/10/2011

Good tip on cleaning up log history!

Maurice Ivory on 3/11/2011

Great tips on how to keep things organized and cleaned up.

Munna Bhai on 3/11/2011

Excellent video. Thanks for sharing it!

Caleb Bell on 3/21/2011

Thanks for giving the pointer to the log files, but it would be more helpful to show how to debug some real-world error messages (like "Error: Cannot read the next data row for the dataset", etc.). Thanks!

Adi on 3/25/2011

very good

Frank Fernandez on 3/27/2011

Like anything from Brian... great work!

Talha on 3/31/2011

Thanks, that really usefult. Did you bring it to Micorsoft's attention so that they can include a feture to removed these logs after certain number of days?

John Smith on 4/14/2011

It would be very helpful if you would post a script(s) along with your videos. Thanks.

Amit on 4/25/2011

Excellent... Thanks for the great tip...

chandan on 5/8/2011

Is there any way to download these video ?

Paul E Richmond on 6/15/2011

I didn't realize that the logs did not clear..... Time to do some maintenance.

app12mrp on 9/23/2011

It is very usefull

rama on 9/23/2011

Good one

subhash on 11/12/2011

good one

Steven Robinson on 2/9/2012

Very good video, use tip!!

Steven Robinson on 2/9/2012

Very good video, use tip!!

David Branscome on 4/18/2012

Very Good

shyam on 6/10/2012

Some what i understand, i need full fedge of subscription