INFO: LoadSnapshot: Item with session: zbifro55f3pbokb0sj5ichjh, reportPath: , userName: abc\rptsrv not found in the database

  • Mani-584606

    SSChampion

    Points: 11788

    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

  • Pradyothana Shastry

    SSCertifiable

    Points: 5211

    Can you check the user accessing reports has proper access and has login in place.

  • Mani-584606

    SSChampion

    Points: 11788

    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

  • Mani-584606

    SSChampion

    Points: 11788

    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.

  • sqlfriend

    SSC Guru

    Points: 52374

    Did you ever find the solution, I have the same issue,

     

    Thanks

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply