all groups > sql server reporting services > february 2007 >
You're in the

sql server reporting services

group:

10 minutes of inactivity cause loadsnapshot error...


10 minutes of inactivity cause loadsnapshot error... Jeje
2/27/2007 4:23:20 PM
sql server reporting services:
Hi,

I have a front end application where I'm using the reportviewer control.
if the user open a report and don't do anything for 10 to 15minutes, and
then try to export the report in PDF, an error is raised:
Execution 'mlgd4355vz5mgouvwv2guz45' cannot be found (rsExecutionNotFound)
on the RS side the log says:
w3wp!session!1!02/27/2007-15:27:30:: i INFO: LoadSnapshot: Item with
session: mlgd4355vz5mgouvwv2guz45, reportPath: , userName: domain\username
not found in the database
w3wp!library!1!02/27/2007-15:27:30:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
Execution 'mlgd4355vz5mgouvwv2guz45' cannot be found, ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException:
Execution 'mlgd4355vz5mgouvwv2guz45' cannot be found

I have raised the timeout of everything to 2hours (session timeout, RS
timeout etc...) but there is no changes.
I also try to use the local folder to store the temporary files instead of
the database, but its the same result.

But I have not found any option to change a execution snapshot timeout.
where can I change this?
on the RS side, where is the session? mlgd4355vz5mgouvwv2guz45 is not listed
in the RS temp database.

Thanks for your guides.

Jerome.
RE: 10 minutes of inactivity cause loadsnapshot error... Dave
3/2/2007 11:04:07 AM
I'm having the same issue, it appears as though the client browser is timing
out.

Dave

[quoted text, click to view]
Re: 10 minutes of inactivity cause loadsnapshot error... Jeje
3/3/2007 4:27:37 PM
oohhh

have you try to wake up the client at a regular basis?
like executing a script every 5 minutes and call something on the server
side?

[quoted text, click to view]
Re: 10 minutes of inactivity cause loadsnapshot error... EMartinez
3/3/2007 9:29:52 PM
[quoted text, click to view]

One option would be to set the refresh rate of the report to some
periodic value that way the database connection stays open, etc. Hope
this helps.

Regards,

Enrique Martinez
Sr. SQL Server Developer
AddThis Social Bookmark Button