SQL Server Performance Forum – Threads Archive
rsExecutionNotFound
I am using microsoft sql server 2005 workgroup edition and SP2. I tried to run web embeded report, I have received an error that says: Execution ‘w4rn0keq0xu5se455avqjez5’ cannot be found (rsExecutionNotFound) Also, when I running second web embeded report, I have received an error that says: Execution ‘3ejd1fzbyft3xz55wykjkhuf’ cannot be found (rsExecutionNotFound) Those report running fine in the SQL reporting tool please give me some idea for fix those problems!
When you execte a report against the server, a "session" is created for that user. These sessions eventually timeout and are cleaned up. Generally, the sessions are managed by the viewer control, so it is somewhat odd that you are seeing this error. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
would increase the session timeout work for this case?
May be, but check these:
John Garlardo’s Weblog: Session Timeout during execution –http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx John Garlardo’s Weblog: Careful when using rc:Toolbar=false – http://blogs.msdn.com/jgalla/archive/2007/01/31/careful-when-using-rc-toolbar-false.aspx The latter gives a fix on changing the report timeout.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Is there any way to work around this "rsExecutionNotFound"? I have changed the parts of my code according to the suggestions made from those two sites, the problem still there. Thank you,
Liang
I believe this is a live problem with RS 2005, see the https://connect.microsoft.com/feedback/viewfeedback.aspx?FeedbackID=124525&wa=wsignin1.0&siteid=68 feedback here and may wait until it is reported back. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>