I am having an issue with viewing any reports that are created with sql reporting services 2008 R2 integrated with SharePoint 2010. I am getting a error like the following:
The report execution xo5wqt55jpybwcugepmovkrn has expired or cannot be found. (rsExecutionNotFound)
I am using the following configuration
Windows Server 2008 R2 SQL Server 2008 R2 Exchange Server 2010 SharePoint Server 2010
This appears to be some kind of conflict with the exchange server. Probably an old bug that used to occur in sql 2005, that Microsoft "fixed".
As this is going to come up, let me mention that this errors comes up immediately after executing the report. There is no loading time, the loading message flashes then the error happens.
Edit 1 This may be related to the problem I am having, if I try to create a data source with "Windows authentication (integrated) or SharePoint user" it throws the following error:
System.Web.Services.Protocols.SoapException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InvalidDataSourceCredentialSettingException: The current action cannot be completed. The user data source credentials do not meet the requirements to run this report or shared dataset. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.TestConnectForDataSourceDefinition(DataSourceDefinition DataSourceDefinition, String UserName, String Password, String& ConnectError) at Microsoft.ReportingServices.WebServer.ReportingService2010.TestConnectForDataSourceDefinition(DataSourceDefinition DataSourceDefinition, String UserName, String Password, String& ConnectError)
Edit I believe this is a permissions problem with the sharepoint app pool. I read something somewhere, that said you had to give it permissions to do something when setting report services to sharepoint integration mode. I cannot find any guide that tells you that, and I've forgotten where I originally heard it. The log is showing the follow, that leads me to believe this.
library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e 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.; session!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Error in getting session data: Session tp15sp4515l3seqqo4do3e45 does not belong to TESTDOMAIN\spweb
Edit I keep running into this possible fix which fixes it if your using sql 2005 and exchange. I'm using sql 2008 r2 and I do have exchange installed. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_24708495.html, and then support page: http://support.microsoft.com/kb/972328. I suppose I will go edit that file, even thought the support article says it doesn't apply to sql 2008
