SQL Server Reporting Services – Timeout Settings
来源:互联网 发布:淘宝上口碑好的家具店 编辑:程序博客网 时间:2024/06/06 09:29
http://www.avyuktasolutions.com/blog/sql-server-reporting-services-timeout-settings/
You can try out the below setting to Troubleshoot the Timeout Errors.
1) Query Execution Timeout
You can increase the Query Execution Timeout by opening report into the BI studio
For SQL 2008, follow below step
Go to Report Data Explorer.
You will see the List of the DataSets
Right click on the Appropriate Dataset
Select appropriate the Data Set and click on property. You will find the Timeout Setting. Time out is in the seconds.
In New window Click on the Query tab,You will see the Timeout drop down at bottom
For SQL 2005, follow below step
Goto Data Tab.
Choose Dataset from Dropdown and click on “…” to open the Property
On Query Tab you will find the Timeout Text Box at the bottom left corner.
2)Â Report Execution Timeout
You can set the report to never timeout  by setting the processing time out setting to  ‘Do not timeout report execution’
If timeout is caused by length of the execution of the report then you change the Processing Option.
By default, the value is set to 1800 seconds
Either you can set for specific report or you can  set value for all reports.
Follow this step to set value for specific report
Go to http://localhost/reports
Select the appropriate report and click on the report and choose “Manage” option.
Click on the tab “Processing Options” and choose the option “Report Timeout”.
Follow this step for global setting
Go to http://localhost/reports
Click on “Site Settings” links at top
On the Site Setting Page, choose the “General” tab and choose the Report Timeout to “Do not timeout report”
3)Â Â HTTP Timeout
You can set the httpruntime to run the large report,
You can alter the value of attribute executionTimeout  of tag httpRuntime, default value if 9000 and value is in the seconds.
<system.web> <httpRuntime executionTimeout = "9000" /></system.web>
- Open the Report Server’s Web.config file generally located at <Drive>:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
- Locate the HttpRuntime parameter and alter the value. If it doesn’t exist, you will have to create it within the section.
Â
4)Â Â DatabaseQueryTimeout
You can alter the value for DatabaseQueryTimeout in the RSReportServer.config located at
<Drive>:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
The value of timeout is in seconds and default value is 120.
This value is passed to the System.Data.SQLClient.SQLCommand.CommandTimeout property.
5) SessionTimeout and SystemReportTimeout
This the settings controlling the SSRS user session.
The default value of “SessionTimeout” is in seconds and default value is 600 and 1800 for “SystemReportTimeout”.
You can edit this value from ConfigurationInfo  table of report server.
select * from ConfigurationInfo
where Name in (‘SessionTimeout’,'SystemReportTimeout’)
 6)  RecycleTime
This specifies the recycling period for the Reporting Web Service.
this setting has been found in RSReportServer.config, If it doesn’t exist, you will have to create it within the section.
The default is 720 and it is in minutes.
7)
SessionState Timeout
You can alter this setting in the web.config located at <Drive>\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager
default value is 20 minutes.
this require iis restart.
7)
executionTimeout
this setting is asp.net related.
this setting found in the machine.config file located at <Drive>:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG
<httpRuntime executionTimeout = “1800” maxRequestLength = “4096” >
executiontimeout is in second and default value is 110 seconds.
report might be timeout from asp.net due to the large volume of the data, you can increase the value of maxRequestLength. size is in the mb.
this doesn’t require system reboot.
I’ve consider the 64 bit version of SQL Server .
Hope this will help you.
References
My close friend MSDN and google.com
http://social.technet.microsoft.com/wiki/contents/articles/23508.sql-server-reporting-services-timeout-settings.aspx
- SQL Server Reporting Services – Timeout Settings
- SQL Server 2008 Reporting Services
- 微软SQL Server 2000 Reporting Services
- 微软SQL Server 2000 Reporting Services介绍
- SQL Server Reporting Services 相关资源
- SQL Server Reporting Services 相关资源
- Microsoft SQL Server 2005 Reporting Services 2005
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- 书评 -- Professional SQL Server 2005 Reporting Services
- Sort List
- embed遮挡div层,无法显示
- ------------------Android中对GridView, ListView等滚动控件的Touch事件onInterceptTouchEvent,onTouchEvent了解
- 一些必不可少的Sublime Text 2插件
- oracle计算年龄和找回时间段的数据
- SQL Server Reporting Services – Timeout Settings
- 性能提高:(二)资源来自本地
- Java ClassLoader深入讲解
- 自己封装js的ArrayList类
- 一步一步开发自己的Openfire插件(IOS推送插件APNS)
- ---------------------http://www.cnblogs.com/jisheng/archive/2011/12/16/2290348.html
- ORACLE--Connect By、Level、Start With的使用(Hierarchical query-层次查询)
- nodejs简介
- 阿里实习生2014二面总结