10 minutes of inactivity cause loadsnapshot error...
in [Reports]
|
From: Jeje on 27 Feb 2007 16:23 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.
From: Dave on 2 Mar 2007 14:04 I'm having the same issue, it appears as though the client browser is timing out. Dave "Jeje" wrote: > 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. > >
From: Jeje on 3 Mar 2007 16:27 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? "Dave" <Dave(a)discussions.microsoft.com> wrote in message news:2C12D7C7-3F5B-4B71-A8F5-5E936A98A166(a)microsoft.com... > I'm having the same issue, it appears as though the client browser is > timing > out. > > Dave > > "Jeje" wrote: > >> 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. >> >>
From: EMartinez on 4 Mar 2007 00:29 On Mar 3, 3:27 pm, "Jeje" <willg...(a)hotmail.com> wrote: > 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? > > "Dave" <D...(a)discussions.microsoft.com> wrote in message > > news:2C12D7C7-3F5B-4B71-A8F5-5E936A98A166(a)microsoft.com... > > > I'm having the same issue, it appears as though the client browser is > > timing > > out. > > > Dave > > > "Jeje" wrote: > > >> 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. 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
|
Pages: 1 Prev: rpt to rdl conversion Next: Printing SSRS Report from asp.net web page/C# |