SQL Server Reporting -10 minutes of inactivity cause loadsnapshot error

May 23 2008 4:53 AM

Hi all,

 

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 have also used the local folder to store the temporary files instead of

the database, but it’s the same result.

There have been MANY posts on several forums however I haven't seen an answer to this to date. 

Any suggestions would be welcome.


Answers (1)