Solved

SSRS: The selected report is not ready for viewing.

Posted on 2011-02-23
5
2,498 Views
Last Modified: 2012-05-11
This morning, SSRS is suddenly throwing error:

The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)

There are no report snapshots or subscriptions in use.

Before anybody posts a link to it, report execution properties are already set to "Render with most recent data" and "Do not cache temporary copies."

I re-deployed a small test report. It throws the same error.

This is a production machine, so a reboot is a last resort- but I'm starting to lean toward trying that.

Anybody got any good ideas?
0
Comment
Question by:kwebster7327
  • 3
  • 2
5 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 34965457
http://www.experts-exchange.com/Database/Reporting_/Q_22493901.html

I wonder if you need to enable another option:
Cache the report. Expire after (minutes)" is checked.

0
 
LVL 1

Author Comment

by:kwebster7327
ID: 34966129
Tried that, too. They've been working without caching for months, anyway.

0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 34967046
0
 
LVL 1

Accepted Solution

by:
kwebster7327 earned 0 total points
ID: 34970127
Fixed it! See: http://social.msdn.microsoft.com/Forums/en-IE/sqlreportingservices/thread/18314247-b8e5-421c-a456-20b5d3d4d5d7.

Scroll down to Yao-Jie-Tang's entry. He describes recreating the SSRS virtual directories.This is the fix.

How they got corrupted is a mystery (I suspect one of our infrastructure guys did something, but nobody knowns nuthin'). Since my production SSRS is back up and my phone has stopped ringing, I'm happy.
0
 
LVL 1

Author Closing Comment

by:kwebster7327
ID: 35005109
Fixed problem.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Ssrs disable the home lonk 1 98
Ssrs date parameters 12 146
SSRS Calculation of two fields not working 7 69
SSRS Matrix Grand Total 2 70
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

733 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