SSRS 2008 Execution cannot be found error when accessing report via Report Manager
I have found a bug in SSRS 2008. I need this resolved. Thanks in advancefor your time.
I can recreate this issue at will.
I have a reporton the Home page for all users of SSRS 2008. When 2 users (user A, user B)access the report at the same time, and user A clicks the single page advance button of the web report view. User B will get the following error message if he attempts to click the single page advance button immediatly after.
Server Error in '/Reports' Application.
Execution '2wpoherjsischv45m2dxb0rt' cannot be found (rsExecutionNotFound) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution '2wpoherjsischv45m2dxb0rt' cannot be found (rsExecutionNotFound)Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
[ReportServerException: Execution '2wpoherjsischv45m2dxb0rt' cannot be found (rsExecutionNotFound)]
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +444
Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad) +191
Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad) +112
Microsoft.Reporting.WebForms.ReportDataOperation..ctor() +385
Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType) +462
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +67
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +599
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171
Version Information:Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053
November 7th, 2008 12:37pm
Anyone have any idea about this issue?
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2008 1:50pm
Hi baaron,
I cannot reproduce this issue. Can you be more specific in your repro?
http or https?
Parameters used in the report?
None default settings on the server?
Any other details you might think relevant.
November 10th, 2008 2:36pm
Sure,
1. http or https? [http]
2. Parameters used in the report? [no]
3. None default settings on the server? [default settings]
This is the first time I have used SSRS. Surely SSRS is designed so that more than one user may access a report at the same time. Right? It is almost behaving like it is designed for one at a time access.
Thanks for the reply.
Free Windows Admin Tool Kit Click here and download it now
November 10th, 2008 2:41pm
Baaron - I cannot reproduce your issue. I havemachines configured and running as different users. Product is working fine without that error.
However, in the past I have seen a similar issue when your session expires. John Gallardo talks a bit about this on his blog: http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
If youcannot figure out what iscausing the problem,you can contact CSS or file an issue at http://connect.microsoft.com.
November 10th, 2008 7:13pm
In order to produce the problem. You must logon as userA as an administrator, and userB as a user.
The problem does not appear to be soley on the paging button. If you both browse to a report at the same time, the user that got there last can use the paging buttons, but the user that got there first will be given the error.
Free Windows Admin Tool Kit Click here and download it now
November 11th, 2008 11:13am
Did anyone found a solution to this problem? I have the same issue, having the exact same conditions as baaron.
March 5th, 2009 11:14am
Are you guys using basic authentication?
Free Windows Admin Tool Kit Click here and download it now
March 5th, 2009 7:48pm
Yes,Ido.
March 6th, 2009 4:33am
Ok, you may be experiencing a bug in basic authentication when different users make concurrent requests. The workaround is to set <EnableAuthPersistence> in rsreportserver.config to False. Or if you installed SSRS2008 latest service pack it should take care of this issue.
Free Windows Admin Tool Kit Click here and download it now
March 6th, 2009 7:45pm
Thanks James, settingEnableAuthPersistence to false fixed the problem.Not sure what "SSRS2008 latest service pack" means, I installed cumulative update package 3 (http://support.microsoft.com/default.aspx/kb/960484) 2 weeks ago, that obviously didn't fix this one :-) I'm not aware of any other service packs for 2008 at this moment.
March 7th, 2009 5:05am
SSRS2008 SP1 should contain the fix. I am actually not sure if it is available right now, but once you apply SP1 the problem should go away.
Free Windows Admin Tool Kit Click here and download it now
March 8th, 2009 10:58pm
You can encrease the limit in "Reporting Services Server Default" if you run SSRS in SharePoint integrated mode.
Central Administration > Configure Reporting Services Integration
Reporting Services Server Defaults
Use this page to view or modify the default server settings for Reporting Services.
Report History Default
Select the default number of snapshots to keep in report history.
Do not limit the number of snapshots
Limit number of snapshots to:
Please enter a valuePlease enter a whole number greater than 0.
Report Processing Timeout
You can limit the amount of time that a report will execute before being stopped.
Do not time out report processing
Limit report processing (in seconds):
Please enter a valuePlease enter a whole number greater than 0.
Report Processing Log
The report processing log keeps a record of when every report is processed as well as information about when it was run and by which user.
Enable report processing log
Remove log entries older than this many days
Please enter a whole number greater than 0.Please enter a value
Enable Windows Integrated Security
Determines whether integrated security is supported for report data source connections.
Enable Windows integrated security for report data sources
Enable Ad Hoc Reporting
The Report Builder Launch URL property allows you to specify the launch URL for the Report Builder ships with SQL Server 2008 or ReportBuilder 2.0.
Enable ad hoc report executions
Custom Report Builder launch URL
Specify a custom URL for this property when the report server does not use the default Report Builder URL.
April 15th, 2009 8:18am
Well, I still have this problem when accessing any report from inside my portal. When accessing them directly thru the webservice using http://<reportservername>/ReportServerI have no problems. I just applied SP1 with CU2 released just a couple of days ago.Ideas?
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2009 9:02am
I get this too. but heres the thing - i have multi tenancy and one organisation works fine, the other throws up this error. Anyone any thoughts - need this fixing asap.CheersDavid
June 24th, 2009 4:56am
Hi,
In my case, this error ocurred only in the Browsers Internet Explorer 8 and Internet Explorer 9 with reports that takes more than 20 minutes for execute.
I solved this problem optimizing the sql query procedure ( before optimize took 30 minutes to execute ) and now takes 3 minutes.
I tried to configure increasing the session timeout in ReportManager configuration but anything solve the problem.
This error is weird because in Google Chrome and Firefox works fine!
Ricardo PrattiRicardo G. Pratti
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2012 4:20pm