SSRS 2005 Error: The Item “/” cannot be found

Couple of months back, one of our SSRS 2005 staging server became inaccessible. When we opened the report manager, it had thrown a message

The item “/” cannot be found

After repeated attempts, the report server opened up. But when we tried to access a report it erred with a message

The server failed to resume the transaction. Desc:4200000061.
The transaction active in this session has been committed or aborted by another session.

We checked the log files but could not see anything other than the above message. The DBA had restarted the Reporting Services but of no use. Then recycled the IIS server. This helped us and the issue got resolved, at-least temporarily.

This week, we faced the issue again. I requested the DBA to recycle the Reporting Services and IIS. But this time it did not help. The DBA could see a lot of dump files generated by the Reporting Server. In the associated log file (dump’s) we could see that Reporting Server could not find a particular report

w3wp!library!8!09/05/2011-14:04:37:: i INFO: Call to RenderFirst( ‘/main/Dashboard6’ )
w3wp!library!8!09/05/2011-14:04:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/main/Dashboard6’ cannot be found., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item ‘/main/Dashboard6’ cannot be found.

w3wp!library!8!09/05/2011-14:04:37:: e ERROR: Transaction rollback failed. Exception thrown: System.NullReferenceException: Object reference not set to an instance of an object.
   at System.Data.SqlClient.SqlInternalTransaction.GetServerTransactionLevel()
   at System.Data.SqlClient.SqlInternalTransaction.CheckTransactionLevelAndZombie()
   at System.Data.SqlClient.SqlInternalTransaction.Rollback()
   at System.Data.SqlClient.SqlTransaction.Rollback()
   at Microsoft.ReportingServices.Library.ConnectionManager.AbortTransaction()

Though we could find that report in the Report Server. Also we could see that the report worked fine in BIDS. But for some reason Report Server did not recognize this particular report. We just deleted the file and replaced it with a new file. Though this fixed the issue, we could not understand the reason behind the strange behaviour of the report server.

Advertisements

About Suresh Kumar D

Hardcore SQL Developer and aspiring Database Architect.
This entry was posted in SSRS and tagged . Bookmark the permalink.

4 Responses to SSRS 2005 Error: The Item “/” cannot be found

  1. Kevin Forney says:

    I need to know what report was deleted and replaced with a new report

    • Hi Kevin,

      I deleted the report “Dashboard6” and replaced it with another report (same name). I did this because, if you see the above report server log, it says that ‘/main/Dashboard6′ could not be found eventhough the report exists in the report server.

      I could not figure out why it did not recognize the report ‘Dashboard6’ but after deleting and uploading again (with same name), the crash had stopped.

      • Kevin Forney says:

        Where do I find this file?

      • The SSRS log files are usually placed in

        \Program files\Microsoft SQL Server\MSSQL.X\Reporting Services\LogFiles

        Check whether any dump (.dmp) files are created. If yes, you will also find a log file for the dump. Open that and carefully review. You will get to know the offending report, if your issue is same as mine.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s