December 1, 2011 at 11:16 pm
Hi,
We have SQL Server 2005 reporting services. Reporting services is configured with all default settings
The report server url (http://servername/reportserver)is called from the application's web.config file and fetches the data and displays to user with in the application.
One of our reports is taking more than an hour giving no results (it just hangs there). If we run the same report from report manager, it finishes in couple of minutes.
When the user runs the report from the application, the below error is logging in reportserver log files continuously.
w3wp!cache!e!12/01/2011-14:23:13:: i INFO: Session live: /Reports/BalanceSummaryReport
w3wp!session!c!12/01/2011-14:23:16:: i INFO: LoadSnapshot: Item with session: wxbmwo55nf2yap55kwqegz55, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'wxbmwo55nf2yap55kwqegz55' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'wxbmwo55nf2yap55kwqegz55' cannot be found
w3wp!session!f!12/01/2011-14:23:16:: i INFO: LoadSnapshot: Item with session: ne4azr55zib2lh55nahfkyme, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!f!12/01/2011-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ne4azr55zib2lh55nahfkyme' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'ne4azr55zib2lh55nahfkyme' cannot be found
w3wp!session!c!12/01/2011-14:23:16:: i INFO: LoadSnapshot: Item with session: kzzs4l45hdcjt055gdfczd55, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kzzs4l45hdcjt055gdfczd55' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'kzzs4l45hdcjt055gdfczd55' cannot be found
w3wp!session!c!12/01/2011-14:23:16:: i INFO: LoadSnapshot: Item with session: sfzp0y55hffauw45jrapdpvp, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'sfzp0y55hffauw45jrapdpvp' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'sfzp0y55hffauw45jrapdpvp' cannot be found
w3wp!session!c!12/01/2011-14:23:16:: i INFO: LoadSnapshot: Item with session: blrl2d455pa3ym55vmqtfl55, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:16:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'blrl2d455pa3ym55vmqtfl55' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'blrl2d455pa3ym55vmqtfl55' cannot be found
w3wp!session!c!12/01/2011-14:23:17:: i INFO: LoadSnapshot: Item with session: vq1bvn45azyql3jarmbh4rfk, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'vq1bvn45azyql3jarmbh4rfk' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'vq1bvn45azyql3jarmbh4rfk' cannot be found
w3wp!session!c!12/01/2011-14:23:17:: i INFO: LoadSnapshot: Item with session: mnfsnx45z0y1dxjusbwelj45, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'mnfsnx45z0y1dxjusbwelj45' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'mnfsnx45z0y1dxjusbwelj45' cannot be found
w3wp!session!c!12/01/2011-14:23:17:: i INFO: LoadSnapshot: Item with session: m5pghtfilaykpg55zekcxtne, reportPath: , userName: abc\rptsrv not found in the database
w3wp!library!c!12/01/2011-14:23:17:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'm5pghtfilaykpg55zekcxtne' cannot be found, ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'm5pghtfilaykpg55zekcxtne' cannot be found
Could you please provide your inputs. Thanks
December 1, 2011 at 11:53 pm
Can you check the user accessing reports has proper access and has login in place.
December 1, 2011 at 11:59 pm
yes, user has the access. He is able to run all other reports except this.
The dbo.execution log table shows that the report was finished in 10 mins but the actual user did not get the results. The IE session just keeps on revolving for an hour with NO results and also the status column in executionlog table has rsSuccess all the time
Thanks
December 5, 2011 at 10:00 am
The data source is Oracle and the query is finishing in 15 mins at oracle end.
But the report rendering is taking hours and it's not showing up any results and we just need to close the IE and it's logging the error mentioned above.
If any body faced this..please advice.
December 13, 2019 at 6:48 pm
Did you ever find the solution, I have the same issue,
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply