Post reply

rsExecutionNotFound error, some questions after a week of research.

  • October 2, 2012 at 5:18 am

    #282382

    Hello Friends,

    Currently I am running SQL Server Reporting Services 2008 R2 RTM on Production. I am getting the following error:

    Exception has been thrown by the target of an invocation.

    The report execution jdfdqj45j1wmhr55tyhpwr55 has expired or cannot be found. (rsExecutionNotFound)

    So I have been getting this error intermittently. My customers usually have this error when exporting a large report or sometimes when they change the date parameter and re run it again. The only way I can reproduce the error is by paging through the report and it usually errors out on 8th or 9th page. It all happens under 2 minutes for me.

    After researching a lot, found couple of solutions. The most popular one is create a rs.exe and run this command: rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="6000". I couldn't understand what this command does. Does it change the SessionTimeout value in ConfiguationInfo table on ReportServer database? If it does that, can't we change the value directly in the database rather than running the script? This is set to 600 seconds right now.

    2nd thing I found is change the EnableAuthPersistence to False in rsreportserver.config file. This seems to fix a lot of problem, but I don't know what EnableAuthPersistence does. I tried researching a lot, but I couldn't find what this setting does. This is under Authentication, so I would like to know what this does before I change it. I don't want to put my report server on any risk.

    I changed these two settings already in rsreportserver.config, but it didn't fix the problem:

    DatabaseQueryTimeout - change from 120 seconds to 600

    cleanupcycleminutes - change from 10 to 60

    Any more suggestions?

    ------------
    🙂

  • October 2, 2012 at 5:45 am

    #1544318

    So I changed EnableAuthPersistence to False, but still no Luck. Any ideas?

    ------------
    🙂

  • May 13, 2014 at 8:38 am

    #1713094

    Hi Ravi,

    I am also facing the same problem... If you have found solution, can you please post it so that every one will be aware of.

    Thanks

  • May 13, 2014 at 8:45 am

    #1713100

    brainy (5/13/2014)

    Hi Ravi,

    I am also facing the same problem... If you have found solution, can you please post it so that every one will be aware of.

    Thanks

    This is a two year old thread. You might get a response faster by posting a new question.

    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    —Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply