SSRS Reportviewer control returns no data

Question

User756353548 posted

I have a web forms web app that uses SSRS report viewer control 2010, which works individually. The app has two web instances, each of which hosts the SSRS report. The app uses load balancer and asp.net Windows state cache.

The problem is that the SSRS report randomly return data when two instances are turned on (ie, sometimes returns data, sometimes returns no data), but works individually. Tthe report viewer control on the web forms page return the exception below:

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

Any idea?

Answer 1

User1140095199 posted

Hi,

   Greetings!

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

Enabled the remote error property of SSRS (Using SSMS , log into to Report Services. Right click on the instance and select Property -> Advanced) to true

See if the above solution helps!

Also refer to the following articles:

http://skamie.wordpress.com/2010/10/28/ssrs-2008-r2-error-the-report-execution-has-expired-or-cannot-be-found-rsexecution_not_found/

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/bfec7a4d-4a50-4b24-bb50-09093ccd8682/rsexecutionnotfound-error-on-ssrs2008-r2-in-sharepoint-integrated-mode-on-sharepoint2010?forum=sqlreportingservices

Hope it Helps!

Best Regards!

Answer 2

User756353548 posted

The first link helps, which I found too. I need to post a different post because it is related to a slightly different topic. Thanks.