Friday, March 30, 2012

rsExecutionNotFound

Hello:

We are using Reporting Services 2005 as our production reporting portal. Sometimes our business users get similar messages to the following message (intermittently ) when running reports.

Execution 'ahk2v0rhpeaj3e45lkrf2ine' cannot be found (rsExecutionNotFound)

I have researched online and forums but could not find a solution to this problem. I know it has something to do with sessions dying and loss of session id. Once the user reruns the report it works fine. What is the way to resolve this from happening at all? We don't want the users to see this on production. Has Microsoft already fixed this problem?

Thanks.

Here is one 'hack' for the problem. It appears to be related to caching. Another way to fix if you are using a custom app is to specify a unique 'fake' parameter guid. rc:guid=<guid>

http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

You may want to try using SQL Profiler against ReportServerTempDB to determine if it is deleting sessions in the same manner as the url above. See the help file to check rsreportserver.config settings.

http://www.samspublishing.com/articles/article.asp?p=469625&seqNum=6&rl=1

cheers,

Andrew

No comments:

Post a Comment