Execution '' not found
I have this annoying error and I cannot find a solution yet. Please help!I'm generating some reports from a SQL Server 2005 database. I know these reports work fine because I've seen them working, but, sometimes, appearently random, it doesn't create the report, instead, it gives me this error:Execution '' not foundWith nothing inside the ''. Another case is when I try to refresh the report: I generate the report, I see it, and I press F5 to refresh, I get the same error again.Could anybody help me please? I'm desperate.
September 7th, 2007 11:27am
Are you using the Report Viewer Control to populate the reports ?
-- Deepak
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2007 11:31am
Yep
September 7th, 2007 11:33am
I used to get this quite often until I executed this command:
rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"
See this blog:
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2007 11:57am
I'll try to point you in the right direction...Lets see
1.) I had the same issue with the defalut parameters caching and the ReportViewer.Reset() method solved it. Thanks to Lukaz.
To reevaluate default parameter values, you need to call the Reset method on the control. The control (& the underlying server) do not have a way to reevaluate defaults without starting a new session; the Reset method does that for you.
http://blogs.msdn.com/lukaszp/archive/2007/08/24/report-viewer-control-reset-method.aspx
2.) Once I had the execution not found issue and this site pointed me to the rigt direction.
http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx
http://blogs.msdn.com/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx
Hope this helps...
September 7th, 2007 11:57am
Thanks to both of you.I ran the script and I got a "The command completed succesfully" message, but I was getting the same freaking error: Execution '' not foundBut finally, I added a ReportViewer.Reset() in the Page_Load. Now it seems to work perfectly.Thanks fellas!
Free Windows Admin Tool Kit Click here and download it now
September 10th, 2007 10:40am
When I try to runrs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000"I get an error:Could not connect to server: http://localhost/reportserver/ReportService2005.asmxI have tried replacing localhost with the actual name of the server. I have also tried using the username and password on the server that I also use to successfully deploy reports, still the same error. I have verified I can also view the above ReportService2005.asmx, and the wsdl as well. I can also view the http://localhost/ReportServer directory, and have verified in IIS that both the Reports and ReportServers are using ASP.NET 2.0 in the ASP.NET properties. Several people have posted this error online, but I have yet to find a solution. I just used textpad to create the sessionTimeout.rss file from John Gallardo's blog, with nothing else in the file.I am running Windows XP Pro on my local machine, and when I add -t to the above command, I get the error "The referenced account is currently locked out and may not be logged on to." On the development server, the error is "Object reference not set to an instance of an object."Thanks in advance for any help,Steve
February 11th, 2010 11:28am
I have been getting this error recently.Although I never get it on my machine,users complain that they have to run the reports 4-5 and then only they can get the data. 50% of the time users get
Execution '1lf4qtiqhmh5zb555tuyulbp' cannot be found (rsExecutionNotFound) . I tried everything from changing the timeout to all comments i could find over the internet. Has anyone solved this issue. Please do not respond with any of the above
solutions. I have already tried those. Thanks in advance
Free Windows Admin Tool Kit Click here and download it now
February 22nd, 2011 6:38pm
Hello,
Please remove any old versions of Report Viewer (from Control Panel) and install 'Microsoft Report Viewer 2008
SP1 Redistributable' on
BOTH server and workstations.
The link is
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=bb196d5d-76c2-4a0e-9458-267d22b6aac6
or a even more recent Report Viewer patch from:
http://www.microsoft.com/downloads/en/details.aspx?familyid=6aaa74bd-a46e-4478-b4e1-2063d18d2d42&displaylang=en
It seemed to work in my case.
Important note: you may have to modify web.config file if you currently have older ReportViewer versions on the server. The above link installs ver. 9.0.0.0
Regards,
M.R.
April 21st, 2011 4:01pm
Sorry, the solution I posted above does not solve the problem, the error just happens less frequently but it still there...
Regards,
M.R.
Free Windows Admin Tool Kit Click here and download it now
April 27th, 2011 9:47am
Apparently fixed. I did the following:
1. On the server, edit C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config
2. Set <EnableAuthPersistence> in rsreportserver.config to False:
<EnableAuthPersistence>False</EnableAuthPersistence>
Regards,
M.R.
May 17th, 2011 11:47am
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 22nd, 2012 4:23pm