Monday 10 September 2018

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

Steps today are
1. httpRuntime executionTimeout
added executionTimeout to ...\Reporting\web.config Line now reads
<httpRuntime executionTimeout = "10800" maxRequestLength="51200" />
2. ASP Script timeout
increased this from 00:01:30 to 00:05:00
IIS Manger -> server -> sites -> Sharepoint Web Services. find the reporting service by right click -> Manage Application -> Advanced Settings -> Physical Path. Then open ASP in right pane, expand Limits properties, Script Time-Out click apply (top right pane)
3. Changed processing options on individual reports
5.45am Report - processing timeout changed to 3600 (was previously default value)
5.53am Report - processing timeout changed to never (was previously default value)
4. Stopped and Restarted IIS
__________________________
Browse the reporting service -> site setting -> general tab -> change the time out value

No comments:

Post a Comment