SQL Server Performance

rsExecutionNotFound

Discussion in 'SQL Server 2005 Reporting Services' started by LiangZhu1, Apr 24, 2007.

  1. LiangZhu1 New Member


    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!
  2. satya Moderator

    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.
  3. LiangZhu1 New Member


    would increase the session timeout work for this case?
  4. satya Moderator

    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.
  5. LiangZhu1 New Member

    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
  6. satya Moderator

    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.

Share This Page