Solved

SSRS: The selected report is not ready for viewing.

Posted on 2011-02-23
5
2,362 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
Comment Utility
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
Comment Utility
Tried that, too. They've been working without caching for months, anyway.

0
 
LVL 17

Expert Comment

by:dbaSQL
Comment Utility
0
 
LVL 1

Accepted Solution

by:
kwebster7327 earned 0 total points
Comment Utility
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
Comment Utility
Fixed problem.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

7 Experts available now in Live!

Get 1:1 Help Now