July 6, 2006 at 11:02 am
We have one report that is very large. Takes about 1 hour and 15 minutes to refresh. In Visual Studio it refreshes just fine. When trying to refresh in Report Manager it fails after 60 minutes exactly giving a timeout exception. I have looked for setting everywhere and can not find out where a timeout of 60 minutes is set. Any help would be much appreciated.
July 6, 2006 at 2:16 pm
Timeout settings are under Site settings in report manager.
hth
David
P.S you can coonfigure some other options in the xml config files in the report server directory
July 6, 2006 at 2:19 pm
Opps forgot also and this may be more appropriate.
If you look under the properties tab of the report and go to the execution settings you can set it to never time out the report or specify particular seetings for just that report.
hth
David
July 6, 2006 at 3:01 pm
We have both those setting to never timeout. Yet the report bombs at 60 minutes everytime.
September 6, 2006 at 10:19 pm
I use SQL2005/RS/SP1.
I have the same issue. I observe the following in the event log when the report stops:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 9/7/2006 12:26:03 AM
Event time (UTC): 9/6/2006 8:26:03 PM
Event ID: a59fe7cafca54c73a2d324ca575b65cd
Event sequence: 256
Event occurrence: 3
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-1-128020440730312500
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager\
Machine name: SRV
Process information:
Process ID: 2220
Process name: aspnet_wp.exe
Account name: SRV\ASPNET
Exception information:
Exception type: ReportServerException
Exception message: Execution 'xfhl3w45tngzzx553a14sdfp' cannot be found (rsExecutionNotFound)
I checked the report execution log and found out that if a report executes more that 60 min, it generates an error 100%.
What I have done: I played with ASP.NET execution timeout, timeouts in webservice web.config, rsreportserver.config - no changes.
If a report executes for mopre than 1 hour, then it stops with "Page can not be displayed".
Anyone got a solution/ walkaround?
September 11, 2006 at 10:52 am
Anybody! Can you help?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply