Last post Jul 09, 2014 03:43 AM by Amy Peng - MSFT
Jul 04, 2014 05:14 PM|sxlin|LINK
I have an ASP.NET web forms web app, which uses report viewer control.
The app is hosted in two web instances, and is using F5 load balancer.
The app is using InProc session state.
Report Viewer Control
The report viewer (ver 10) is using remote processing mode.
Reporting services connection is specified via
Access to reporting services is via Active directory user name and passwords.
SQL Server 2008 r2/Reporting services
Settings on two web instances
<appSettings> <add key="ReportViewerServerConnection" value="MyNamespace.MyClass, MyAssembly"/> </appSettings> <system.web> <sessionState mode="InProc" timeout="25" /> </system.webother settings omitted (Machine key is the same on both instances)
The app was working since beginning, but it has a problem recently. The problem is that the report viewer uses machine account from each web instance for its request, rather than the active direction user name/password mentioned at the beginning. Thus, the
reporting service rejects the requests.
The exception found on web instance is below:
The report execution SessionIDXXXXX has expired or cannot be found. (rsExecutionNotFound).
The exceptions found on reporting server is below:
Error in getting session data: Session SessionIDXXXXX does not belong to WebInstance1\AccountName$
INFO: LoadSnapshot: Item with session: SessionIDXXXXX, reportPath: , userName: WebInstance1\AccountName$ not found in the database
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: The report execution SessionIDXXXXX has expired or cannot be found.;
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.;
I would appreciate for any advice.
Jul 09, 2014 03:43 AM|Amy Peng - MSFT|LINK
>>The problem is that the report viewer uses machine account from each web instance for its request, rather than the active direction user name/password mentioned at the beginning. Thus, the reporting service rejects the requests.
For the above, please try to check this thread:
>>The report execution SessionIDXXXXX has expired or cannot be found. (rsExecutionNotFound).
Also for this error information, please try to check the following article for more help:
#Asp.NET ReportViewer “report execution has expired or cannot be found”: