当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server - SSRS ramdomly stops working

问题描述:

Hopefully someone has seen this. When I google I see this error back in 2009/2010 with SQL Server 2008, but nothing recent. I also don't see any solutions that work.

I'm using IIS8, SQL Server 2014, Reporting Services 2014.

Reports will be working fine, then they just stop. I don't see any pattern yet to when they fail. At least every morning I have to restart, sometimes as much as 3 times a day. When it stops the only way I can get them to start working is to:

  1. Restart the service.
  2. Before trying to run a report or anything else, browse to localhost/reports and make sure the folders show up.

If I try and run a report from our app before doing the above two steps, it will not work and I need to repeat those two steps.

When it stops working, I can not even browse to localhost/reports. Will not even give me a folder list. Once I go through the steps above everything works great. Sometimes all day, sometimes until evening.

Here is the error in the log. Again, reports work great after restarting, sometimes all day.

library!ReportServer_0-3!1e9c!07/09/2015-21:24:54:: e ERROR: Throwing

Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:

,

Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:

An internal error occurred on the report server. See the error log for

more details. ---> System.IO.FileLoadException: Could not load file or

assembly 'Microsoft.ReportingServices.UpgradeScripts,

Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or

one of its dependencies. Access is denied. File name:

'Microsoft.ReportingServices.UpgradeScripts, Version=12.0.0.0,

Culture=neutral, PublicKeyToken=89845dcd8080cc91' at

Microsoft.ReportingServices.Library.ConnectionManager.get_ReportingServicesVersionNumber()

at

Microsoft.ReportingServices.Library.ConnectionManager.IsUpToDateDatabaseVersion(String

storedDBVersion) at

Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()

at

Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage(VersionVerificationOptions

option) at

Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()

at

Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String

storedProcedureName) at

Microsoft.ReportingServices.Library.CachedSystemProperties.GetSystemProperty(String

name) at

Microsoft.ReportingServices.Library.CachedSystemProperties.Get(String

name, Boolean noThrow) 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, String editSessionID, ItemPathOptions options) at

Microsoft.ReportingServices.Library.RSService.ConstructItemContext(String

path, Boolean allowEditSession, String parameterName) at

Microsoft.ReportingServices.Library.SessionStarterAction.CreateNew(SessionfulClientRequest

session, RSService service, String reportPath, String historyId)

WRN: Assembly binding logging is turned OFF. To enable assembly bind

failure logging, set the registry value

[HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There

is some performance penalty associated with assembly bind failure

logging. To turn this feature off, remove the registry value

[HKLM\Software\Microsoft\Fusion!EnableLog].

--- End of inner exception stack trace ---;

library!ReportServer_0-3!145c!07/09/2015-21:25:51:: e ERROR: Throwing

Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException:

,

Microsoft.ReportingServices.Library.ReportServerDatabaseUnavailableException:

The report server cannot open a connection to the report server

database. A connection to the database is required for all requests

and processing. ---> System.IO.FileLoadException: Could not load file

or assembly 'Microsoft.ReportingServices.UpgradeScripts,

Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or

one of its dependencies. Access is denied. File name:

'Microsoft.ReportingServices.UpgradeScripts, Version=12.0.0.0,

Culture=neutral, PublicKeyToken=89845dcd8080cc91' at

Microsoft.ReportingServices.Library.ConnectionManager.get_ReportingServicesVersionNumber()

at

Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage(VersionVerificationOptions

option) at

Microsoft.ReportingServices.Library.ConnectionManager.get_Connection()

at

Microsoft.ReportingServices.Library.RunningJobsDb.GetMyRunningJobs(JobTypeEnum

runningJobType)

分享给朋友:
您可能感兴趣的文章:
随机阅读: