rsExecutionNotFound error

Hello,

I am developing a report viewer application in ASP.NEt 2.0 and in that I have a page called ReportViewer.aspx page which has a report viewer control. The processing mode is remote and it is a SQL Server 2005. There are a couple of dropdownlists one which defines the names of the different reports and the other the reporting periods. Depending on the selection made by the user, the call is made to the reporting server and reporst are displayed. Initially when the page loads, the reports show up without any problems. But if a user is inactive for a while, and the user tries to the view the report, I get the following error

"Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound) "

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'tmf3wgqtzuasux3trzliwx25' cannot be found (rsExecutionNotFound).

I did some research and came across this post which is the exact error which i am getting.

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124525

The above link is not working for some reason but if you click on the link below, it says that the issue has been fixed. But there is no information as to how to fix this. Does anybody have any idea as to what the solution is?This is the exact same error which I am getting and any help to resolve this error would be great.

http://64.233.183.104/search?q=cache:H2UEJj42ypcJ:connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx%3FFeedbackID%3D124525+rsExecutionNotFound+%2B+2005&hl=en&ct=clnk&cd=1&gl=us

There are some posts which advise to add the a guid at the end of the url but if you are using a viewer you cannot add anything else to the .ServerReport.ReportURL property other than the path to the report or else it returns an error.

As per my knowledge, the report veiwer control should be keeping the session alive using keep alive messages. There is also the possibility of IE caching and one can disable it by going to Tools -> Options and disabling the caching. But this is not something which I can tell my customers to do.

Any help would be greatly appreciated.

Regards,

arpan

Arpan,

My team came across this error a while ago, and found that Reporting Services has it's own session that is timing out. In the ReportServer database, there is a table called ConfigurationInfo. In this table there are values for a SessionTimeout and SessionAccessTimeout. I think the default is set to '600'. This value corresponds to the number of seconds that the report session will be open.

Our solution was to bump this number way up, say to a couple of hours or more. The problem with this is then you get a lot of data in the ReportServerTempDB, which may cause headaches. It's not a perfect solution, and this property should be more easily editable.

The other way to set this property is to use some Reporting Service Scripting, .rss files, and run them using the rs.exe utility that was installed with Reporting Services. There is a Good blog about this by John Gallardo (?) I think.

Good Luck,

Mac

blog url: http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

|||

Mac.

Thanks for the quick reply. I shall try it out tomorrow and see if that helps.

Regards.

arpan

RS Layout and Preview Tab - SLOW

Hello, I have been working with Reporting Services for several months and really like it. I am using Visual Studio .net for developing reports. I have noticed a long delay when changing between the 'Layout Tab' and the 'Preview Tab'. The delay is between 10 and 15 seconds which may not seem like much but adds up over time. Does anyone know if this is an issue with RS or the .net environment? Are there settings to change to make this change quicker? I know each time you change from one tab to another a new .rdl file has to be built but I have witnessed several demos from Microsoft and their setups appear to be instantaneous. Any ideas would be helpful!!! Thanks, Dave
--
Message posted via http://www.sqlmonster.comIf you report has paramters then you are just seeing building the report, no
parameters then it is also executing the report. Once it has executed it
though, it then caches the data (look in your directory and you will see
reportname.rdl.data). Even a pretty complicated report takes only a couple
of seconds to build the report. Ususally a second or less. How much RAM do
you have. It seems to me like you might be getting some thrashing going on.
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:b664fdd433c94909a44639deb1c12d91@.SQLMonster.com...
> Hello, I have been working with Reporting Services for several months and
really like it. I am using Visual Studio .net for developing reports. I
have noticed a long delay when changing between the 'Layout Tab' and the
'Preview Tab'. The delay is between 10 and 15 seconds which may not seem
like much but adds up over time. Does anyone know if this is an issue with
RS or the .net environment? Are there settings to change to make this
change quicker? I know each time you change from one tab to another a new
.rdl file has to be built but I have witnessed several demos from Microsoft
and their setups appear to be instantaneous. Any ideas would be helpful!!!
Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com|||Thank you for your response. My client station is a 3Ghz Pentium with 256 megs of ram. I consistently see this delay regardless of whether the report has parameters or not. The delay occurs before the 'Processing Report...' dialogue appears. The same query in query analyzer takes fractions of a second to complete. Any additional insight would be greatly appreciated. Thanks, Dave
--
Message posted via http://www.sqlmonster.com|||That is faster than my machine but I have 512MB more RAM than you. Besides
adding RAM if you can, how do you have your data source setup, is it a
shared datasource or are you doing it per report. I use shared data source.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8c91c4a235784ec4b6a9e8de4b04f06d@.SQLMonster.com...
> Thank you for your response. My client station is a 3Ghz Pentium with 256
megs of ram. I consistently see this delay regardless of whether the report
has parameters or not. The delay occurs before the 'Processing Report...'
dialogue appears. The same query in query analyzer takes fractions of a
second to complete. Any additional insight would be greatly appreciated.
Thanks, Dave
> --
> Message posted via http://www.sqlmonster.com|||I am using a shared datasource. I wish I knew if increasing memory would solve this problem before upgrading. Thanks for your responses. Dave
--
Message posted via http://www.sqlmonster.com|||I don't know what else it could be. I have a slower computer and don't see
this. Do you have SQL Server and IIS locally as well? If so then SQL Server,
IIS, VS is a lot in 256 MB. Bring up task manager and see what is going on,
you should be able to see memory usage.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David Cymbala via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:d3fba556874c4760b739831eb8e33089@.SQLMonster.com...
> I am using a shared datasource. I wish I knew if increasing memory would
solve this problem before upgrading. Thanks for your responses. Dave
> --
> Message posted via http://www.sqlmonster.com

RS Forms Authentication

I am currently developing an asp.net web application that uses reporting
services within it. I have the web app running on one machine and reporting
services running on another server with sql server 2000. Pretty much the
forms authentication and role-based membership to log into report manager and
to view reports within the asp.net application works flawlessly.
Currently, a user logs into my application. When they select a report to
view, they are forced to login to report server since they have not been
authenticated by report server. What I am trying to do is to combine both
login process into one. Basically, when a user logs into the application, it
should also automatically authenticate and log them into report server as
well. That way, when they go to view a report, they would not have to log in
again. I have tried copying and using the same code that the forms
authentication for reporting services uses into my web app but it doesn't
work -> no authentication cookie is generated. Anyone have any ideas.
Thanks in advance.Anyone?|||James,
Did you get this working? I am in a similar situation and RS always
prompts for login as well.
Michael
James wrote:
> I am currently developing an asp.net web application that uses reporting
> services within it. I have the web app running on one machine and reporting
> services running on another server with sql server 2000. Pretty much the
> forms authentication and role-based membership to log into report manager and
> to view reports within the asp.net application works flawlessly.
> Currently, a user logs into my application. When they select a report to
> view, they are forced to login to report server since they have not been
> authenticated by report server. What I am trying to do is to combine both
> login process into one. Basically, when a user logs into the application, it
> should also automatically authenticate and log them into report server as
> well. That way, when they go to view a report, they would not have to log in
> again. I have tried copying and using the same code that the forms
> authentication for reporting services uses into my web app but it doesn't
> work -> no authentication cookie is generated. Anyone have any ideas.
> Thanks in advance.|||Actually, yes I did...all I basically did was add a reference to the assembly
file that I created for the reporting services custom security and just
called the server.LogonUser(...) method within my own application login.
"Michael Thorne" wrote:
> James,
> Did you get this working? I am in a similar situation and RS always
> prompts for login as well.
> Michael
> James wrote:
> > I am currently developing an asp.net web application that uses reporting
> > services within it. I have the web app running on one machine and reporting
> > services running on another server with sql server 2000. Pretty much the
> > forms authentication and role-based membership to log into report manager and
> > to view reports within the asp.net application works flawlessly.
> >
> > Currently, a user logs into my application. When they select a report to
> > view, they are forced to login to report server since they have not been
> > authenticated by report server. What I am trying to do is to combine both
> > login process into one. Basically, when a user logs into the application, it
> > should also automatically authenticate and log them into report server as
> > well. That way, when they go to view a report, they would not have to log in
> > again. I have tried copying and using the same code that the forms
> > authentication for reporting services uses into my web app but it doesn't
> > work -> no authentication cookie is generated. Anyone have any ideas.
> >
> > Thanks in advance.
>

RS Custom Toolbar

Hi
We are developing a custom toolbar with the export, zoom,find and
previous/next page browsing functionalities. How can we go about developing
the page browsing functionality?
ThanksCreate
MyQueryDesigner : Microsoft.ReportDesigner.Interfaces.IQueryDesigner
where
public Control ToolBar
from IQueryDesigner
"Priya" <Priya@.discussions.microsoft.com> wrote in message
news:123D3CC1-2ED9-4BF2-A742-E7D1FA3470DB@.microsoft.com...
> Hi
> We are developing a custom toolbar with the export, zoom,find and
> previous/next page browsing functionalities. How can we go about
developing
> the page browsing functionality?
> Thanks