We are doing a Load Testing for SSRS Server. SSRS Reports are executing through Report Viewer Control from ASP.NET Application. But the No of Users exceeds to 160 Users. We are receiving the below error message 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.; I have tried to change the MemorySafetyMargin to 60. Nothing workout so far. Your Help is really appreciated...

Hi Ganesh, Based on the error message, it might be timeout issue due to heavy workload of Report Server that time. By default, the timeout value is 120 second when connect to Report Server database. You can refer to Jinchun’s solution to increase the timeout value in the following thread, please see: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/db4ca6c2-5445-4ff9-9f63-e20f3859cc70 If you have any more questions, please feel free to ask. Regards, Bin LongPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Bin, I have already increased the DatabaseQueryTimeout to 600 Seconds. But Still we are receiving the same error.Ganesh.K

Hi, Can you change the ReportServerTempDb Size and check again ?Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Rakesh, Our Currenct ReportServerTempdb size is 1.5 GB and it is set to AutoGrow = true. We are seeing above error even when we run a Single Report also. Regards Ganesh.KGanesh.K

Hi Ganesh, May be true it is 1.5 GB but can you check whats the log file and datafile size of the same database ?Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Hi Rakesh, Please see the details below and advise. Thank you. the data file is set to grow at 512000 KB for unlimited growth and log file size right now is 1024000 KB and the max size for that log file is 2147483648 KB and its set to grow at 512000 KB both the data and log file reside on the same drive but the drive itself has about 129G free space Ganesh.K

Hi Team, Please see the detail error message and advise. Your Help is really appreciated.. Thank you. library!ReportServer_0-1!a40!10/04/2011-10:43:21:: 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.; session!ReportServer_0-1!a40!10/04/2011-10:43:21:: e ERROR: Error in getting session data: Expired Session: 45h12s45zattkg45buixeqyi session!ReportServer_0-1!a40!10/04/2011-10:43:21:: i INFO: LoadSnapshot: Item with session: 45h12s45zattkg45buixeqyi, reportPath: , userName: LTCFISWPRSDB01\PDSRptUser not found in the database library!ReportServer_0-1!a40!10/04/2011-10:43:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution 45h12s45zattkg45buixeqyi has expired or cannot be found.; Regards Ganesh.KGanesh.K