rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

sql

rsExecutionNotFound

I wrote a Custom Web App using ASP.NET for reports built using SSRS 2005. The web application uses report viewer control to display the reports. The Report Viewer processing mode is set to "Remote". The session timeout for web application is 30 minutes.

Reports autorefresh property is set to 15 minutes. when the web page thats displaying the reports is running continously, I am occassionally seeing "rsExecutionNotFound" error. The error is not going away even if I refresh the page.

Thanks for u'r help.

Dear NR01,

There could be a possibility that the session of reporting services is timing out.

Try this post

HTH,

Suprotim Agarwal

|||

Hi,

I tried the post you mentioned. when I run the reports continously, still I am seeing rsExecutionNotFound error but not as frequent as before.

I set the timeout to 30 min.

rs -i sessionTimeout.rss -s http://localhost/reportserver -v timeout="1800"

I am refreshing the reports every 15min.

Thanks for u'r help.

-NR01

|||

I also did the same and set the timeout=1800.

I still get many of these failures. I didn't notice any changes going from 600 to 1800.

This is a typical error:

w3wp!ui!7!7/23/2007-04:52:49:: Unhandled exception: Microsoft.Reporting.WebForms.ReportServerException: Execution 'c14v5l45yikbbo55d5vk1jj3' cannot be found (rsExecutionNotFound)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ServerReport.LoadFromUrlQuery(NameValueCollection requestParameters, Boolean fullReportLoad)
at Microsoft.Reporting.WebForms.ReportDataOperation..ctor()
at Microsoft.Reporting.WebForms.HttpHandler.GetHandler(String operationType)
at Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

I can't imagine that people are sitting on a page for more than 30 minutes. Could there be another cause?

Neil

|||

I've solved the same issue.

I'm viewing reports with asp.net reportviewer; on production server, my aspx load correctly the report at first time, but any postback returns "rsExecutionNotFound" error.

I realized my aspx code contains hard-coded reportserverurl and reportpath values, which are different for development and production envs. So when I dynamically set up thoses settings in my page, reportviewer kill its client session since I'm changing the report path from one server to another.

So change :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport ReportServerUrl="http://DEVSERVER/ReportServer" ReportPath="/MyPath" />

</rsweb:ReportViewer>

To :

<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" Height="600px" Width="996px">

<ServerReport />

</rsweb:ReportViewer>

rsDataSourceNotFound error in SSRS 2005

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occurred during report processing. (rsProcessingAborted)

The data source 'xxx' cannot be found. (rsDataSourceNotFound)

This error occurs irrespective of electing to re-deploy or not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

How do I get around this error?

Pl let me know if anyone has encountered this error?

rsDataSourceNotFound error in SSRS 2005

As soon as a report is re-deployed a refresh of the report in the viewer shows the following error message:

An error has occurred during report processing. (rsProcessingAborted)

The data source 'xxx' cannot be found. (rsDataSourceNotFound)

This error occurs irrespective of electing to re-deploy or not re-deploy the datasource, and the only solution seems to be to close the report viewer down and restart it.

Under RS2000 any changes that were made to a report, would automatically be shown to the user if the report was refreshed, without having to close the browser/application down and restart it.

How do I get around this error?

Pl let me know if anyone has encountered this error?

rsAccessDenied when accessing Report Server

I have SQLServer 2005 with reporting services running on win 2003 server.
I'm trying to configure SSRS with Anonymous access configured on
ReportServer Web Site and verified NTFS security on ReportServer folder
include Iusr and Iwam with read/execute permmisions
Does ReportServer stand on its own or does the ReportManager Web Site also
need Anonymous access?
Are there any config files that need to be updated?
What am I missing?
IE Message when accessing http://<Server>/ReportServer
The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation. (rsAccessDenied)
ReportServer Log File
w3wp!library!1!02/15/2006-11:54:17:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!1!02/15/2006-11:54:17:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
insufficient for performing this operation.
ReportServerService_Main Log File
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration
file.
ReportingServicesService!servicecontroller!9!2/15/2006-08:54:31:: Total
Physical memory: 685219840
ReportingServicesService!servicecontroller!4!2/15/2006-08:54:31:: i INFO:
RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
ReportingServicesService!library!d!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
Evaluation copy: 0 days left
ReportingServicesService!library!e!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!library!f!2/15/2006-08:57:45:: i INFO: Catalog SQL
Server Edition = Developer
ReportingServicesService!crypto!d!2/15/2006-08:57:45:: i INFO: Initializing
crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Exporting
public key
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Performing
sku validation
ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Importing
existing encryption key
Thanks
Marc BumgarnerNo a good idea (anonymous access). As soon as you do this you will find out
that you have lost all admin rights even when you are an administrator on
the box. Why? Because it is anonymous, RS does not know who you are.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Marc Bumgarner" <mbumgarner@.ecomponentstech.com> wrote in message
news:8P6dnaUqm6P1Gm7enZ2dnUVZ_sidnZ2d@.mt.net...
>I have SQLServer 2005 with reporting services running on win 2003 server.
> I'm trying to configure SSRS with Anonymous access configured on
> ReportServer Web Site and verified NTFS security on ReportServer folder
> include Iusr and Iwam with read/execute permmisions
> Does ReportServer stand on its own or does the ReportManager Web Site also
> need Anonymous access?
> Are there any config files that need to be updated?
> What am I missing?
>
> IE Message when accessing http://<Server>/ReportServer
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation. (rsAccessDenied)
>
> ReportServer Log File
> w3wp!library!1!02/15/2006-11:54:17:: i INFO: Catalog SQL Server Edition => Developer
> w3wp!library!1!02/15/2006-11:54:17:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException:
> The permissions granted to user 'VWIN2003SERVER\IUSR_VWIN2003SERVER' are
> insufficient for performing this operation.
>
> ReportServerService_Main Log File
>
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WindowsServiceUseFileShareStorage to 'False' as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing IsWebServiceEnabled to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
> in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DailyCleanupMinuteOfDay to default value of '120' minutes
> since midnight because it was not specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonFlags to '1064' as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonDumpOnExceptions to
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WatsonDumpExcludeIfContainsExceptions to
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> as specified in Configuration file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!4!2/15/2006-08:54:25:: i INFO:
> Initializing WebServiceUseFileShareStorage to 'False' as specified in
> Configuration file.
> ReportingServicesService!servicecontroller!9!2/15/2006-08:54:31:: Total
> Physical memory: 685219840
> ReportingServicesService!servicecontroller!4!2/15/2006-08:54:31:: i INFO:
> RPC Server started. Endpoint name ='ReportingServices$MSSQL.3'
> ReportingServicesService!library!d!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!resourceutilities!d!2/15/2006-08:57:45:: i INFO:
> Evaluation copy: 0 days left
> ReportingServicesService!library!e!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!library!f!2/15/2006-08:57:45:: i INFO: Catalog
> SQL Server Edition = Developer
> ReportingServicesService!crypto!d!2/15/2006-08:57:45:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Performing
> sku validation
> ReportingServicesService!crypto!d!2/15/2006-08:57:46:: i INFO: Importing
> existing encryption key
>
> Thanks
> Marc Bumgarner
>

RS2000 on multiple websites, customize look and feel, turn off admin

I'm brand new to SSRS and just installed RS2000. I have seen numerous posts/articles about how to set up RS2000 on the non-default website, but haven't been able to figure out if you can install it on multiple websites on the same server.

Here's my situation: we have multiple clients who run our software on the same server. Each client has their own db and their own website in IIS. I'd like to provide each client with access to reports through their own website that report on their own database. Is this possible at all? From what I'm finding, I don't think it is (it seems SSRS can only be installed on one site), but figured I would ask to determine whether I should explore the use of SSRS any further. If it isn't possible in RS2000, is it possible in RS2005?

I also have two other questions that I would need to figure out an answer to if it is possible to run RS2000 on multiple websites. First, is there a way to customize the look and feel of the reports? In other words, is there a way to add a header/leftnav/footer? It seems that I could use a frameset to load my header, footer, and leftnav, and then just point my main frame to the /reports/ or /reporserver virtual dirs. Is there a better way than that?

Secondly, is there a way to turn off access to most of the admin features available through the /reports/ directory. For example, we wouldn't want our clients to have access to "New Data Source", "Site Settings", etc. We'd just want them to access the reports we generate. It seems we could point them to the /reportserver/ directory and just put some custom pages in there to point at the reports (I just get a directory listing by default). Is there another way to do this?

Thanks,

Dave

This helps:

http://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/default.aspx