SQL Server Performance

sql report 2005 error: The report is still being rendered or a report snapshot is not available. (rsReportNotReady)

Discussion in 'SQL Server 2005 Reporting Services' started by aaron, Jan 28, 2010.

  1. aaron New Member

    The error I am getting the error in sql report service 2005 is 'The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)'.
    There are lots of answers on the web and I have tried alot of them including obtaining extract space.

    The error I am getting is: " The report is still being rendered or a report snapshot is not available. (rsReportNotReady)".

    I am using using windows-authentication to the datasource, and I am wondering if I am not setting up the pass-through properly on the
    web-service.?

    Thus to correct the problem can you tell me what to do and/or point to some urls that solve the problem?
    Thanks!
  2. satya Moderator

    Did you try:
    ALTER DATABASE ReportServerTempDB SET ALLOW_SNAPSHOT_ISOLATION OFF;
    and
    ALTER DATABASE ReportServer SET ALLOW_SNAPSHOT_ISOLATION OFF;
    See this http://blogs.msdn.com/jgalla/archive/2006/08/30/live-reports-and-rsreportnotready-error.aspx refers:
    After a bit of troubleshooting, we eventually narrowed the problem down to the fact that Snapshot Isolation was enabled on the ReportServer and ReportServerTempDB databases. Snapshot Isolation changes the locking semantics of the ReadCommitted isolation level, which broke some of our synchronization mechanisms -- we basically use the database as a distributed lock coordinator since we support scale-out by adding Report Server instances which don't directly communicate with each other. Snapshot Isolation changes the locking semantics in such a way as that we cannot do this with the current implementation.

Share This Page