I am receiving the following error. Around that same time my IE sessions throw timeouts, the ReportServer databases all show deadlocks in a circular loop between 3-5 SPIDS and my SSRS logs start filling up with these errors (all stack traces and logs are below) RSException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> 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.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. Environment Configuration Web/SSRS Server Windows Server 2008 R2 SP1 Standard 64bit SQL Server 2008 R2 SP1 Standard Virtual machine - 24gb RAM, 4 processors Report databases stored on 30gb drive with 10gb free. ReportServerDB is 4gb in size, ReportServerTempDB is 4gb in size Production Database Server Windows Server 2008 R2 SP1 Enterprise 64bit SQL Server 2008 R2 SP1 Enterprise Physical machine - 128gb RAM, 4-4core processors Software is used as a BI solutionSome reports take 15-30 minutes to buildSSRS databases do NOT use more space that what is defined above (never grows but is set to autogrow as needed)RAM on both machines stays constant at about 80% utilizationAll drives are fast spin Several times a day, and at night, when attempting to access a report IE attempts to connect to SSRS to run the report but an error is thrown with connection timeout. At that same time looking in the SSRS log files I see the "This may be due to a connection failure, timeout or low disk condition within the database" error message. This error will be thrown during the day while reports are attempting to be accessed AND ALSO at night when nothing is going on. Stack trace when report is attempting to run: chunks!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: Decompressed segment 8bab1101-b1a5-e111-88c3-005056985944, original size = 1787, decompressed size = 32320 processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: ScalabilityCache Processing|Standard Done. AuditedHeapSerialized: 0 KB. Serialization Time 0 s. AvgSpeed NaN KB/s. StreamSize 0 MB. FinalAuditedHeapSize 382 KB. LifetimeFreedHeapSize 0 KB. processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: e ERROR: An exception has occurred in data set 'Sh13MthTrendBalanceRange'. Details: System.Threading.ThreadAbortException: Thread was being aborted. at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 ) at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteReader>b__1() at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) at Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.Library.SegmentChunkDbInterface.ReadChunkSegment(Guid chunkId, Boolean isPermanent, Guid segmentId, Int32 dataIndex, Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.SegmentStorageLayer.CompressedStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.CacheStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Read(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.FillBuffer(Int32& bytesRead) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.ReadByte() at System.IO.BinaryReader.ReadByte() at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.PersistenceBinaryReader.ReadBoolean() at Microsoft.ReportingServices.ReportIntermediateFormat.RecordField.Deserialize(IntermediateFormatReader reader) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.DataReaderRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadArrayOfRIFObjects[T](Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadArrayOfRIFObjects[T]() at Microsoft.ReportingServices.ReportIntermediateFormat.RecordRow.Deserialize(IntermediateFormatReader reader) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.DataReaderRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ChunkManager.DataChunkReader.ReadNextRow() at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ChunkManager.DataChunkReader.GetNextRow() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessRows() at Microsoft.ReportingServices.OnDemandProcessing.TablixProcessing.RuntimeOnDemandDataSet.Process() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet) processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: Processing of data set 'Sh13MthTrendBalanceRange' completed. processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: e ERROR: Data source ' Data source for shared dataset': An error has occurred. Details: System.Threading.ThreadAbortException: Thread was being aborted. at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 ) at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteReader>b__1() at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) at Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.Library.SegmentChunkDbInterface.ReadChunkSegment(Guid chunkId, Boolean isPermanent, Guid segmentId, Int32 dataIndex, Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.SegmentStorageLayer.CompressedStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.CacheStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Read(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.FillBuffer(Int32& bytesRead) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.ReadByte() at System.IO.BinaryReader.ReadByte() at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.PersistenceBinaryReader.ReadBoolean() at Microsoft.ReportingServices.ReportIntermediateFormat.RecordField.Deserialize(IntermediateFormatReader reader) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.DataReaderRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadArrayOfRIFObjects[T](Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadArrayOfRIFObjects[T]() at Microsoft.ReportingServices.ReportIntermediateFormat.RecordRow.Deserialize(IntermediateFormatReader reader) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.DataReaderRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ChunkManager.DataChunkReader.ReadNextRow() at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ChunkManager.DataChunkReader.GetNextRow() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessRows() at Microsoft.ReportingServices.OnDemandProcessing.TablixProcessing.RuntimeOnDemandDataSet.Process() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process() processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: e ERROR: An exception has occurred in data source ' Data source for shared dataset'. Details: System.Threading.ThreadAbortException: Thread was being aborted. at SNIReadSync(SNI_Conn* , SNI_Packet** , Int32 ) at SNINativeMethodWrapper.SNIReadSync(SafeHandle pConn, IntPtr& packet, Int32 timeout) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteReader>b__1() at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) at Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ReportingServices.Library.SegmentChunkDbInterface.ReadChunkSegment(Guid chunkId, Boolean isPermanent, Guid segmentId, Int32 dataIndex, Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.SegmentStorageLayer.CompressedStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.CacheStorageLayer.Read(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Read(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Read(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.FillBuffer(Int32& bytesRead) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.ReadByte() at System.IO.BinaryReader.ReadByte() at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.PersistenceBinaryReader.ReadBoolean() at Microsoft.ReportingServices.ReportIntermediateFormat.RecordField.Deserialize(IntermediateFormatReader reader) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.DataReaderRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadArrayOfRIFObjects[T](Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadArrayOfRIFObjects[T]() at Microsoft.ReportingServices.ReportIntermediateFormat.RecordRow.Deserialize(IntermediateFormatReader reader) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.DataReaderRIFObjectCreator.CreateRIFObject(ObjectType objectType, IntermediateFormatReader& context) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatReader.ReadRIFObject(Boolean verify) at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ChunkManager.DataChunkReader.ReadNextRow() at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.ChunkManager.DataChunkReader.GetNextRow() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessRows() at Microsoft.ReportingServices.OnDemandProcessing.TablixProcessing.RuntimeOnDemandDataSet.Process() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet) at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process() at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessConcurrent(Object threadSet) processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: Processing of data source ' Data source for shared dataset' completed. library!ReportServer_0-1!15c8!05/24/2012-10:45:35:: 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.; chunks!ReportServer_0-1!15c8!05/24/2012-10:45:35:: 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.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteNonQuery>b__0() at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e) at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) at Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.SegmentChunkDbInterface.CreateChunkSegment(Guid snapshotId, Boolean isPermanent, Guid chunkId, Int64 startByte, Int32 logicalByteCount, Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.SegmentStorageLayer.CompressedStorageLayer.CreateSegment(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.CreateSegmentInStorageLayer(ReadWriteParameters& wp, ReadWriteStatistics& stats) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Write(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Write(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.WriteBuffer() at Microsoft.ReportingServices.Library.BufferedReadWriteStream.Dispose(Boolean disposing) chunks!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: Closing segmented chunk (55561ce6-c215-49d2-99ef-121ef5006c2e, False, 'PaginationInfo') processing!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: ScalabilityCache Processing|GroupTree Done. AuditedHeapSerialized: 0 KB. Serialization Time 0 s. AvgSpeed NaN KB/s. StreamSize 0 MB. FinalAuditedHeapSize 0 KB. LifetimeFreedHeapSize 0 KB. chunks!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: ### ID=c0663688-03fe-471c-a974-1b4d806b00c3, Length=0, CompressedLength=0, TimeCompressing=0, TimeUncompressing=0, Ratio=0, Buffering=0, Permanent=True chunks!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: Closing segmented chunk (55561ce6-c215-49d2-99ef-121ef5006c2e, False, 'DataChunkx12') chunks!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: ### ID=55561ce6-c215-49d2-99ef-121ef5006c2e, Length=5511011762, CompressedLength=316157605, TimeCompressing=1204, TimeUncompressing=0, Ratio=0.05736834, Buffering=0.6275551, Permanent=False library!ReportServer_0-1!15c8!05/24/2012-10:45:35:: w WARN: Transaction rollback was not executed connection is invalid library!ReportServer_0-1!15c8!05/24/2012-10:45:35:: v VERBOSE: Transaction rollback. library!ReportServer_0-1!15c8!05/24/2012-10:45:35:: w WARN: 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.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteNonQuery>b__0() at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e) at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) at Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.SegmentChunkDbInterface.CreateChunkSegment(Guid snapshotId, Boolean isPermanent, Guid chunkId, Int64 startByte, Int32 logicalByteCount, Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.SegmentStorageLayer.CompressedStorageLayer.CreateSegment(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.CreateSegmentInStorageLayer(ReadWriteParameters& wp, ReadWriteStatistics& stats) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Write(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Write(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.WriteBuffer() at Microsoft.ReportingServices.Library.BufferedReadWriteStream.Dispose(Boolean disposing) at System.IO.Stream.Close() at Microsoft.ReportingServices.OnDemandReportRendering.RenderingChunkManager.CloseAllChunks() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.FinallyBlockForProcessingAndRendering(RenderingContext odpRenderingContext, ExecutionLogContext executionLogContext) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition) at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result) at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult) library!ReportServer_0-1!15c8!05/24/2012-10:46:03:: v VERBOSE: Transaction commit. library!ReportServer_0-1!15c8!05/24/2012-10:46:03:: v VERBOSE: Transaction begin. library!ReportServer_0-1!15c8!05/24/2012-10:46:03:: v VERBOSE: Transaction commit. library!ReportServer_0-1!15c8!05/24/2012-10:46:03:: v VERBOSE: Disposing StreamFactory:66a1cb2b-a94a-401b-a03f-b5bab526c98b bufferedresponse!ReportServer_0-1!15c8!05/24/2012-10:46:03:: v VERBOSE: HttpResponseStream suppressed one and only flush bufferedresponse!ReportServer_0-1!15c8!05/24/2012-10:46:03:: v VERBOSE: Closed HttpResponseStream webserver!ReportServer_0-1!15c8!05/24/2012-10:46:03:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. ---> 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.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.<ExecuteNonQuery>b__0() at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Library.Storage.WrapAndThrowKnownExceptionTypes(Exception e) at Microsoft.ReportingServices.Library.SqlBoundaryWithReturn`1.Invoke(Method m) at Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Library.SegmentChunkDbInterface.CreateChunkSegment(Guid snapshotId, Boolean isPermanent, Guid chunkId, Int64 startByte, Int32 logicalByteCount, Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.SegmentStorageLayer.CompressedStorageLayer.CreateSegment(SegmentChunkDbInterface storage, ReadWriteParameters parameters, ReadWriteStatistics& statistics) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.CreateSegmentInStorageLayer(ReadWriteParameters& wp, ReadWriteStatistics& stats) at Microsoft.ReportingServices.Library.SegmentedChunkStorage.Write(Int64 position, Byte[] buffer, Int32 offset, Int32 length) at Microsoft.ReportingServices.Library.StorageStream.Write(Byte[] buffer, Int32 offset, Int32 count) at Microsoft.ReportingServices.Library.BufferedReadWriteStream.WriteBuffer() at Microsoft.ReportingServices.Library.BufferedReadWriteStream.Dispose(Boolean disposing) at System.IO.Stream.Close() at Microsoft.ReportingServices.OnDemandReportRendering.RenderingChunkManager.CloseAllChunks() at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.FinallyBlockForProcessingAndRendering(RenderingContext odpRenderingContext, ExecutionLogContext executionLogContext) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition) at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result) at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult) at Microsoft.ReportingServices.Library.ReportExecutionBase.InternalExecuteReport() at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute() at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper() at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport() at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution() at Microsoft.ReportingServices.Library.RenderReportAction.Render() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation) at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage() library!ReportServer_0-1!15c8!05/24/2012-10:46:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: The request has been aborted., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeException: An error occurred in the HTTP Runtime object for application domain ReportServer_MSSQLSERVER_0-1-129823435804188969. Most likely, the HTTP request contains an unsupported verb or invalid syntax. ---> System.Web.HttpException: Request timed out. --- End of inner exception stack trace ---; rshost!rshost!1820!05/24/2012-10:46:03:: v VERBOSE: HttpPipeline::DisconnectCallback: releasing pipeline=0x000000000061F7F0. rshost!rshost!15c8!05/24/2012-10:46:03:: v VERBOSE: HttpPipelineCallback::CloseConnection: pipeline=0x000000000061F7F0. rshost!rshost!15c8!05/24/2012-10:46:03:: v VERBOSE: HttpPipelineCallback::EndOfRequest(): releasing pipeline=0x000000000061F7F0. rshost!rshost!15c8!05/24/2012-10:46:03:: v VERBOSE: HttpPipeline::ReleaseOnce: releasing pipeline=0x000000000061F7F0. rshost!rshost!15c8!05/24/2012-10:46:03:: v VERBOSE: Destroying pipeline=0x000000000061F7F0, callback=0x000000000061C440 ... Ttrace when SSRS is sitting idle: library!WindowsService_10!a44!05/22/2012-19:58:08:: 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.; library!WindowsService_10!a44!05/22/2012-20:03:08:: i INFO: Call to CleanBatch() library!WindowsService_10!a44!05/22/2012-20:08:08:: 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.; library!WindowsService_10!a78!05/22/2012-21:28:08:: 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.; library!WindowsService_10!2e0!05/22/2012-21:33:08:: i INFO: Call to CleanBatch() library!WindowsService_10!2e0!05/22/2012-21:38:08:: 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.; library!WindowsService_10!13fc!05/22/2012-21:43:08:: i INFO: Call to CleanBatch() library!WindowsService_10!13fc!05/22/2012-21:48:08:: 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.; library!WindowsService_10!a44!05/22/2012-21:53:08:: i INFO: Call to CleanBatch() library!WindowsService_10!a44!05/22/2012-21:58:08:: 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.; library!WindowsService_10!13fc!05/22/2012-22:03:08:: i INFO: Call to CleanBatch() library!WindowsService_10!13fc!05/22/2012-22:08:08:: 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.; library!WindowsService_10!a44!05/22/2012-22:13:08:: i INFO: Call to CleanBatch() library!WindowsService_10!a44!05/22/2012-22:18:08:: 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.; library!WindowsService_10!a78!05/22/2012-22:23:08:: i INFO: Call to CleanBatch() library!WindowsService_10!a78!05/22/2012-22:28:08:: 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.; library!WindowsService_10!a78!05/22/2012-22:33:08:: i INFO: Call to CleanBatch() library!WindowsService_10!a78!05/22/2012-22:38:08:: 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.; library!WindowsService_10!2e0!05/22/2012-22:43:08:: i INFO: Call to CleanBatch() library!WindowsService_10!2e0!05/22/2012-22:48:08:: 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.; library!WindowsService_10!13fc!05/22/2012-22:53:08:: i INFO: Call to CleanBatch() library!WindowsService_10!13fc!05/22/2012-22:58:08:: 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.; library!WindowsService_10!2e0!05/22/2012-23:03:08:: i INFO: Call to CleanBatch() library!WindowsService_10!2e0!05/22/2012-23:08:08:: 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.; library!WindowsService_10!a44!05/22/2012-23:13:08:: i INFO: Call to CleanBatch() Attempted Fixes Set the DefaultAppPool to recycle every 720 sec (12 hours)RSReportServer.Config file - added this <Add Key="DailyCleanupMinuteOfDay" Value="120" />RS web.config file altered these and also our application web.config <httpRuntime executionTimeout="900000" maxRequestLength ="2097151"/>Ran the following on the ReportServerTempDB TRUNCATE TABLE SnapshotData TRUNCATE TABLE ChunkData TRUNCATE TABLE SessionDataWill resolve itself after several minutes, or sometimes hours. OR I can restart the SSRS service I'm not sure where else to look at this point. I did see on MS site that there are 6 CU's available for SQL 2008R2SP1 and I am considering applying them even though none of the fixes are directly related to my issue. I am also considering rebuilding my SSRS databases but that would be tricky due to our custom reports being built directly through ReportBuilder on top of the stock ones we use for our product. Has anyone else seen this issue and been able to correct it? HELP!

Hi JAllenD, I did have the same problem with a couple of reports and the problem was the stored procedures were taking way too long to finished executing so SSRS lost the session id for the reports. I improved the preformance issue related to stored procedure and problem went away. I wouldn't do any TRUNCATE TABLE on tables you listed, SSRS will clearout those tables. Thanks! Gonzalo