OS: Windows Server 2008 R2 SQL Server SSRS 2008 R2 with SP1 and latest updates library!WindowsService_8!e0c!:: e ERROR: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 97) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. schedule!WindowsService_8!e0c!:: Error processing event 'CacheInvalidateSchedule', data = 5cb2b02d-7442-4688-9b53-f6b93346e4e3, error = Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 97) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. library!WindowsService_8!b1c!:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.; Any ideas? dudes?http://garsy.cntask.net/

any idea? no one know this ? http://garsy.cntask.net/

Hi NEWTON.L, Sorry for the delay. Based on the error message, it seems to be a deadlock issue while calling FlushReportFromCacheh. In the RSreportserver.config file, the MaxQueueThreads configuration specifies the number of threads used by the Report Server Windows service for concurrent processing of subscriptions and notifications. To avoid the issue, I suggest that you set the "MaxQueueThreads" value to 1. For more information, please see: RSReportServer Configuration File Hope this helps. Regards, Mike YinMike Yin TechNet Community Support