From: JoeAZ on
We recently had our 3 year old server decide to take a vacation so we
migrated ReportingServices to a new machine. This machine is running in an AD
domain and everything is working fine except the following. Reporting
Services will generate a FileNotFound exception occasionaly. This can be
between 1-3 days and the problem was much more frequent when we dropped the
Application Pool recycle time to 60 minutes. Below is the output from one of
the log files located at C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\LogFiles.

urceutilities!17d0!6/17/2008-18:51:47:: i INFO: Running on 2 physical
processors, 4 logical processors
w3wp!resourceutilities!17d0!6/17/2008-18:51:47:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!17d0!6/17/2008-18:51:47:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!17d0!6/17/2008-18:51:47:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!17d0!6/17/2008-18:51:47:: i INFO: Running Requests DB timer
enabled: Next Event: 120 seconds. Cycle: 120 seconds
w3wp!runningjobs!17d0!6/17/2008-18:51:47:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!crypto!17d0!06/17/2008-18:51:47:: i INFO: Initializing crypto as user:
OURDOMAIN\OURUSER
w3wp!crypto!17d0!06/17/2008-18:51:47:: i INFO: Exporting public key
w3wp!webserver!17d0!06/17/2008-18:51:47:: e ERROR: Internal error:
System.IO.FileNotFoundException: The system cannot find the file specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()
at Microsoft.ReportingServices.Library.Storage.get_Connection()
at
Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String
storedProcedureName)
at
Microsoft.ReportingServices.Library.DBInterface.GetOneConfigurationInfo(String key)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String name)
at Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String
name)
at
Microsoft.ReportingServices.Library.CachedSystemProperties.GetParameter(String name)
at Microsoft.ReportingServices.Library.RSService.get_MyReportsEnabled()
at Microsoft.ReportingServices.Library.RSService.PathToInternal(String
source)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path, Boolean validate, Boolean convert, Boolean translate)
at
Microsoft.ReportingServices.Diagnostics.CatalogItemContext.SetPath(String
path)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!17d0!06/17/2008-18:51:47:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. ---> System.IO.FileNotFoundException: The system cannot find the
file specified.

The fix is always the same, log onto the server and go to the application
pool that ReportingServices runs under and perform a Recycle. We're not
seeing any entries in the Application or System logs and the user sees the
generic FNF error above. The application pool is running under a user that is
an admin on the box and again reports run file for long periods and then, at
some point, generate the following error and no other things we've tried fix
the problem except for a App Pool recycle.

Server Specs:
4GB RAM
Windows Server 2003 SP2
Sql Server 2000 SP4
Sql Server 2000 Reporting Services SP2