Troubleshooting Timeout errors in Reporting Services
来源:互联网 发布:淘宝上口碑好的家具店 编辑:程序博客网 时间:2024/06/06 08:45
http://blogs.msdn.com/b/mariae/archive/2009/09/24/troubleshooting-timeout-errors-in-reporting-services.aspx
Working with reports in Reporting Services, you can face timeout errors. This situation might happen when using very heavy reports. I will show bellow a list of different timeouts that could be affecting reports execution in Reporting Services and how you can adjust their values.
1. If the timeout is produced by the query execution of the report, you can modify this value in the Report Designer. To find this setting:
· Open the report using the report designer (Business Intelligence)
· Select the Data tab
· Select the dataset properties
· Increase the value of the timeout box (or put the number in minutes for the query duration if empty)
2. If the timeout is caused by the length of the execution of the report, you can change the Report Execution Timeout property by selecting the 'Do not timeout report execution' option
More info in:
http://msdn2.microsoft.com/en-us/library/ms179924.aspx
http://msdn2.microsoft.com/en-us/library/ms183733.aspx
3. If the timeout is caused by the session, you can change the setting of the sessionState in the web.config file in the folder “C:\Programme\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager”
<sessionState mode="InProc" cookieless="false" timeout="180" />
Restart IIS (Start - Run…, type in iisreset and then click OK).
ON THE SERVER
4. If the timeout is caused by the connection, you can change web site Connection Timeout to 7200 sec (default is 120 sec)
· Open IIS Manager.
· Right click the web site where Report Server is running.
· Select Properties.
· What is the setting for Connection timeout?
· If it is less than 7200 you could change to the value 7200.
5. In RSReportServer.config you could set the following values (theses are sample values, you can adjust your own):
<Add Key="ProcessRecycleOptions" Value="1"/> <!--Disabled-->
<Add Key="CleanupCycleMinutes" Value="36000"/> <!--10 Hours-->
<Add Key="SQLCommandTimeoutSeconds" Value="0"/> <!--None-->
<Add Key="MaxActiveReqForOneUser" Value="100"/>
<Add Key="DatabaseQueryTimeout" Value="0"/> <!--None-->
<Add Key="RunningRequestsScavengerCycle" Value="36000"/> <!--10 Hours-->
<Add Key="RunningRequestsDbCycle" Value="36000"/> <!--10 Hours-->
<Add Key="RunningRequestsAge" Value="30"/>
6. Check the ExecutionTimeout setting within the web.config
\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportManager\
and
\Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportServer)
Default is 9000 seconds, which is 2.5 hours.
In both web.config files check to see what the values are
(e.g., <httpRuntime executionTimeout = "9000" /> ).
You can alter this to 36000.
Maria Esteban
Reporting Services Support Engineer
- Troubleshooting Timeout errors in Reporting Services
- SQL Server Reporting Services – Timeout Settings
- Microsoft Reporting Services in Action
- Troubleshooting HTTP 401 errors in IIS
- Troubleshooting ORA-1652 Errors in RAC
- How to: Enable Remote Errors (Reporting Services Configuration)
- SQL Server 2005 Reporting Services in Action
- timeout in a C# WCF services
- Reporting Services
- Reporting Services
- Reporting Services
- Reporting services
- Microsoft Reporting Services in Action:用自定义代码扩展 Microsoft SQL Server 2000 Reporting Services
- Microsoft Reporting Services in Action:用自定义代码扩展 Microsoft SQL Server 2000 Reporting Services
- Using Reporting Services SharePoint Web Parts in SQL Server 2000 Reporting Services Service Pack 2
- Microsoft Reporting Services in Action:用自定义代码扩展 Microsoft SQL Server 2000 Reporting Services
- Introduction To Role-Based Security In SQL Server Reporting Services
- Using Reporting Services SharePoint Web Parts in SQL Server
- cocos2dx android 真机调试时Logcat不显示日志信息
- asdf
- msyql connnector/c++ , to change connect port
- 深入探讨在集群环境中使用 EhCache 缓存系统
- hdoj 1254 推箱子(BFS + BFS)
- Troubleshooting Timeout errors in Reporting Services
- 正则大全
- PHP 仿百度文库,实现Word文档在线预览功能
- Android中使用ALSA声卡
- 基于r-Kernel的LiteOS操作系统
- IOS应用之间调用
- 餐饮首富的成功创业之路
- MongoDB学习之旅三十:Replica Sets + Sharding
- UML中的依赖