rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?

rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?

rsExecutionNotFound when using ASP State Server

I'm working on an ASP.NET 2.0 project and we are using Reporting Services 2005, the web application is configured to work with a State Server. Our users are getting the following error randomly:

[ReportServerException: No se encuentra la ejecución 'bla bla bla' (rsExecutionNotFound)]

Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() + 367

Microsoft.Reporting.WebForms.ServerReport.SetExecutionId(String executionId) + 117

Microsoft.Reporting.WebForms.ServerReport..ctor(SerializationInfo info, StreamingContext context() + 206

[TargetInvocationException: Exception has been thrown by the target invocation]

System.RuntimeMethodHandle._SerializationInvoke(Object target, SignatureStruct& declaringType, ...

...

System.Web.SessionState.SessionStateItemCollection.DeserializeAllItems() + 88

System.Web.SessionState.SessionStateItemCollection.get_Keys() + 9

System.Web.SessionState.HttpSessionStateContainer.get_Keys() + 10

System.Web.SessionState.HttpSessionState.get_Keys() + 10

...

This exception is thrown in a request when we access the session context to get a variable. After some investigation we have found that the report viewer is storing reports in the session context, we supose that when the report execution expires on server this error is thrown and the user must close Internet explorer and reenter the application.

Is there any way to avoid Report viewer storing reports on session context, if not I think that this is a bug because when using a state server this error is not recoverable and the user must close the Internet explorer. This think doesn' like them much ;-)

Any help would be appreciated

thanks in advance

I'm sorry, I'm not currently bringing a solution to your problem, although:

- I did post the issue on MSDN Labs: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=90396e94-e868-4a33-b784-f43dcd5a7393

- There is a solution, although it's a hack: http://groups.google.fr/group/ReportingServices/browse_thread/thread/685274e5aa25310/bae5e060b65863b0?lnk=st&q=rsexecutionnotfound&rnum=3&hl=fr#bae5e060b65863b0

Trace.axd brings nothing useful session-wise.

If you did find a solution, please post it, as I too need one!

|||Microsoft says that this is solved, but I can't find where, may be in Sql Server 2005 SP1?sql

RS: Cannot create a connection to data source

Hi!

I've created a project includen 3 reports based on following code on 3 server. The report includes 3 different datasources an 3 different report. All 3 reports are grouped on Database and summerizad zise.

SELECT

SD.name [Database],

SMF.name [File],

SMF.size [Size]

FROM

sys.master_files SMF INNER JOIN sys.databases SD

ON SD.database_id = SMF.database_id

I can run all reports in Visual Studio (preview). But I can only run one the reports after depolying the project! I get this message when I raun the other 2 reports:

An error has occurred during report processing.

Cannot create a connection to data source 'uasql02_datasource'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

I tried running the report from an server (where reportingservices is installed) finding that all the reports works as they should. I logged in another server with the same credentials. I got same message on the server as I get on my own camputer, "Cannot create a connection to data source ..."

Is there anybody out there having same problem as I, or someone who has any suggestion?

Thanks for any suggestion!

/*

Fari Sah

*/

Hello, Fari-- I am also getting the "Cannot create a connection to data source..." message, but the rest says "Login failed for user..."

Everything works fine on my production server, but I'm having trouble getting the same reports to work on my development PC and my test server. I'm going to keep hunting, so please post any new information!

RS Execution Logs sample project

Hi,

I was going through the link http://msdn2.microsoft.com/en-us/library/aa964131.aspx for "Monitoring Report Execution Performance with Execution Logs". There is a link (http://datainspirations.com/uploads/rsexecutionlogging.zip) proviced for downloading sample project. It seems that the page no more exists.

Can any one please let me know from where can i download the sample project?

TIA

You can find correct links here:

http://datainspirations.com/Publications.html

|||Even this link doesn't work.If you know the llink,please send me.|||It works for me.

RS Execution Logs sample project

Hi,

I was going through the link http://msdn2.microsoft.com/en-us/library/aa964131.aspx for "Monitoring Report Execution Performance with Execution Logs". There is a link (http://datainspirations.com/uploads/rsexecutionlogging.zip) proviced for downloading sample project. It seems that the page no more exists.

Can any one please let me know from where can i download the sample project?

TIA

You can find correct links here:

http://datainspirations.com/Publications.html

|||Even this link doesn't work.If you know the llink,please send me.|||It works for me.