SSRS 2012: "The report execution has expired or cannot be found. (rsExecutionNotFound)"

Question

I am using SQL Server Reporting Services 2012 and received this error without any known cause: The report execution eqaiekfzmk2snc55y0zrow55 has expired or cannot be found. (rsExecutionNotFound).

While I have found other posts describing problem through Google searches, the resolutions did not help me:

• Restarting SQL Server, SQL Server Agent, and SQL Server Reporting services
• Increasing the Execution Timeout through SQL Server Management Studio when connected to the Reporting server
• Adding rs:ClearSession to the URL querystring (and trying IE, Chrome, and Firefox)
• Redeploying after each troubleshooting step and retesting
• I looked in the Reporting Services log file folder C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\LogFiles but I see the datestamp is over two months old and I could see nothing related to the symptom.
• I looked looked in ExecutionLog3 and did not see anything related to the symptom. use ReportServer; select * from ExecutionLog3;

To find out what did work, I verified that:

• The query and results are sound, as seen in Management Studio
• I can preview the report in Data Tools on the server
• I can view the report when remoting into the server

I only see the error when viewing the page from outside the server. This is a relatively lightweight query and result set, so I cannot believe that this problem has anything to do with execution timeouts.

I changed the name of the file and redeployed. I am able to see that report now, but this isn't a true resolution because I still don't know what is truly causing the problem and how to fix it. If the symptom appears again, I can't keep changing the filename and redeploy.

Is there a way to get a better idea of what is happening? A specific log file or a property I need to change?

Update:

I thought I had this problem worked out, but apparently not. I found nothing useful in the error logs: only a restatement of the same error message visible in the browser. When I redeploy (using SQL Server Data Tools), the error goes away... for a few hours or until the next day, when I need to redeploy to make the error go away.

Answer 1

As stated in a different answer you can clear the session which usually resolves this issue.

If you have a question mark in your URL already then add the following to the end.

&rs:Command=ClearSession

If you do not have one then you need to add the following to the end.

?rs:Command=ClearSession

Answer 2

I've added &rs:Command=ClearSession to the end of my url and works fine with me.

Answer 3

For us, the error appeared trying to run a report on an SSRS 2016 server using Internet Explorer 11. The user had created a bookmark that linked directly to the report. What may have happened: IE preserves cookies and temporary internet files for favorites to "help them load faster". The user may have initially ran the report, then created the bookmark to the report which contained session information.

To fix: Delete the bookmark, then cleared browser history in IE (CTL+SHIFT+DEL) being sure to uncheck "Preserve Favorites website data".

Answer 4

I just had this problem, it was for an existing report that had been working correctly. However, the Report Builder had been open for some time in another window while I was working on something else, and I hadn't saved my work (I was applying a filter, and didn't want to save my changes with my test filter). It occurred to me that since the report HAD been working, but it had been sitting idle, it might have gone stale. I opened the Dataset Properties, clicked Query Designer, then "Run Query". The Query Designer then got a fresh request from the data source. I closed the Dataset Properties window and clicked "Run", and my report was again displayed.

Answer 5

I know this is an old question but I had this problem recently and it turned out to be a bad session cookie. The cookies session-id matched the guid in the error message and once I deleted the cookie all worked fine after that. The report at one point had been configured to cache a temporary copy

but that had since been turned off (however, the problem existed before that had been turned off so it may not be relevant).

Hopefully this answer will help someone else save the hour I spent figuring it out in my environment :)

Answer 6

For me, I had no trailing space.

Some people had luck with clearing Session.Keys of "Microsoft.Reporting.WebForms.ReportHierarchy"

I solved it by Session.Clear in the global.asax

Answer 7

This might help someone.

In my case, The report url had trailing spaces (a silly mistake) which caused this.