SSRS 2012 - Report Time out issue when reports run with Auto Refresh (24*7)

Hi All,

We have developed SSRS reports which are displayed in manufacturing plant in big TV screen. We have implemented native SSRS Auto Refresh functionality to refresh the report in every 30 secs. There are around 10 reports which are executing with Auto Refresh (No Manual Intervention). These reports refresh & display the data in 24*7 time. We are using SSRS reportserver URL to show the reports

Now we are facing Timeout issue with all the reports. We have checked the SSRS logs and found the below error for our reports:

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 the below options:

  1.        Setting the report processing to Do not timeout report
  2.        Set the database timeout to 0 in rsreportserver.config
  3.        Changed the recovery model  of ReportServerTempDB to SIMPLE

But still reports will work for few minutes and then it will start failing with timeout error.

Could you please suggest how we can solve this issue.

Thanks,

Vishal Jharwade

June 19th, 2015 2:17pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics