locked
problem with report viewer RRS feed

  • Question

  • User-1726612628 posted

    I found a few topics about that problem but I'm not sure it solves my problem.

    I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
    Each report view is running a diffrent report.
    in the code behinde I'm adding each report a parameter from my page.

    Now, my site is configure to send me errors to my mail.

    I've noticed that every time that I leave the page with the 4 report viewer open, after about 10-12 minutes (without toucing anything and without any refresh or postback) I get an error mail with this error:

    Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found (rsExecutionNotFound)

    The page itself stay OK with the 4 viewer and the user don't know that there was a problem but I do.

    Any thing know way is that?

    I saw some thing about session of the report viewer but I'm not sure about that.

    B.T.W
    I'm still with sp1on my sql server, Does any body know if it realted to my problem?

    Thanks!


     

    Monday, January 7, 2008 9:46 AM

All replies

  • User-1136466523 posted

    Hi,

    I suggest that you can check the reporting service log ( which exist in %MSSQL_ROOT%\Reporting Services\LogFiles).

    Generally, the system will throw an exception “Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: ucv5xtu2x2uvhfjmjkfmfy45 cannot be fount”. Mostly, it is caused by the fact that the session is missing or it is expired.

    You may try the following link to refer the solution on this.
    http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

    Thanks.

    Tuesday, January 8, 2008 1:46 AM
  • User-1726612628 posted

     Hi Nai-Dong,

    Thanks for the reply but I'm not sure its the same problem.

    The sql server does not generate a report for the error and in the link you provaided its not the same (There he is talking about getting this error while the report is executing  while in my case the report was loaded into the report viewer and he is ok and only after 10 minuts excatly I'm getting this error. maybe the report viewer is config to send ping to the sqlserver after ten minuts or something).

     

    Any more ideas?

     

    Thnks! 

    Tuesday, January 8, 2008 3:35 AM
  • User-1136466523 posted

    Hi,

    Well, could you please show out your reporting service log file so that we can see what causes the error exactly? (which exist in %MSSQL_ROOT%\Reporting Services\LogFiles)

    Thanks.

    Tuesday, January 8, 2008 4:07 AM
  • User-1726612628 posted

     Hi,

    This is the server log. By the time of the log He wasn'r created whan I got the errors (It is very long):

    <Header>
      <Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
      <Locale>en-US</Locale>
      <TimeZone>MyCountry Standard Time</TimeZone>
      <Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerService__01_08_2008_05_35_58.log</Path>
      <SystemName>MySQL1</SystemName>
      <OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
      <OSVersion>5.2.3790.65536</OSVersion>
    </Header>
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing ConnectionType to '1'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    ReportingServicesService!library!9!1/8/2008-05:36:08:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    ReportingServicesService!resourceutilities!9!1/8/2008-05:36:08:: i INFO: Reporting Services starting SKU: Enterprise
    ReportingServicesService!resourceutilities!9!1/8/2008-05:36:08:: i INFO: Evaluation copy: 0 days left
    ReportingServicesService!runningjobs!9!1/8/2008-05:36:08:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
    ReportingServicesService!runningjobs!9!1/8/2008-05:36:08:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    ReportingServicesService!runningjobs!9!1/8/2008-05:36:08:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    ReportingServicesService!runningjobs!9!1/8/2008-05:36:08:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 73431 seconds.  Cycle: 86400 seconds
    ReportingServicesService!runningjobs!9!1/8/2008-05:36:08:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    ReportingServicesService!runningjobs!9!1/8/2008-05:36:08:: i INFO: SQM timer timer enabled: Next Event: 77031 seconds.  Cycle: 86400 seconds
    ReportingServicesService!library!11!1/8/2008-05:36:08:: i INFO: Catalog SQL Server Edition = Enterprise
    ReportingServicesService!crypto!11!1/8/2008-05:36:08:: i INFO: Initializing crypto as user: NT AUTHORITY\SYSTEM
    ReportingServicesService!crypto!11!1/8/2008-05:36:08:: i INFO: Exporting public key
    ReportingServicesService!crypto!11!1/8/2008-05:36:08:: i INFO: Performing sku validation
    ReportingServicesService!crypto!11!1/8/2008-05:36:08:: i INFO: Importing existing encryption key
    ReportingServicesService!dbpolling!11!01/08/2008-05:36:08:: EventPolling polling service started
    ReportingServicesService!dbpolling!11!01/08/2008-05:36:08:: NotificationPolling polling service started
    ReportingServicesService!dbpolling!11!01/08/2008-05:36:08:: SchedulePolling polling service started
    ReportingServicesService!dbpolling!11!01/08/2008-05:36:08:: UpgradePolling polling service started
    ReportingServicesService!dbpolling!d!1/8/2008-05:36:08:: EventPolling heartbeat thread started.
    ReportingServicesService!dbpolling!c!1/8/2008-05:36:08:: NotificationPolling heartbeat thread started.
    ReportingServicesService!dbpolling!10!1/8/2008-05:36:08:: Polling started
    ReportingServicesService!library!3!1/8/2008-05:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-05:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-06:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-06:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-06:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-06:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-06:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-06:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-07:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-07:16:08:: Using folder C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\RSTempFiles for temporary files.
    ReportingServicesService!library!b!1/8/2008-07:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-07:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-07:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 5 sessions, 0 cache entries, 5 snapshots, 38 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-07:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-07:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 14 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-08:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 4 sessions, 0 cache entries, 6 snapshots, 40 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-08:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 6 snapshots, 47 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-08:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 11 sessions, 0 cache entries, 11 snapshots, 88 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-08:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 16 chunks, 0 running jobs, 1 persisted streams
    ReportingServicesService!library!3!1/8/2008-08:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 4 sessions, 0 cache entries, 4 snapshots, 25 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-08:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 4 snapshots, 31 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-09:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 3 snapshots, 26 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-09:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 5 sessions, 0 cache entries, 5 snapshots, 41 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-09:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 2 snapshots, 18 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-09:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 13 sessions, 0 cache entries, 13 snapshots, 85 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-09:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 15 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-09:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 10 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-10:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 9 sessions, 0 cache entries, 9 snapshots, 47 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-10:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 9 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-10:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 3 snapshots, 22 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-10:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 2 snapshots, 16 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-10:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 6 sessions, 0 cache entries, 6 snapshots, 47 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-10:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 4 snapshots, 33 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-11:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 1 snapshots, 9 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-11:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 3 snapshots, 22 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-11:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 7 sessions, 0 cache entries, 6 snapshots, 51 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-11:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 5 snapshots, 33 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-11:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 4 sessions, 0 cache entries, 9 snapshots, 71 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-11:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 16 sessions, 0 cache entries, 16 snapshots, 129 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-12:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-12:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 15 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-12:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 8 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-12:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 6 sessions, 0 cache entries, 6 snapshots, 51 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-12:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 3 snapshots, 23 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!4!1/8/2008-12:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-13:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 10 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-13:16:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 2 snapshots, 14 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-13:26:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 3 snapshots, 22 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-13:36:08:: i INFO: Cleaned 0 batch records, 0 policies, 3 sessions, 0 cache entries, 3 snapshots, 22 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!b!1/8/2008-13:46:08:: i INFO: Cleaned 0 batch records, 0 policies, 8 sessions, 0 cache entries, 8 snapshots, 63 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!3!1/8/2008-13:56:08:: i INFO: Cleaned 0 batch records, 0 policies, 1 sessions, 0 cache entries, 1 snapshots, 8 chunks, 0 running jobs, 0 persisted streams
    ReportingServicesService!library!a!1/8/2008-14:06:08:: i INFO: Cleaned 0 batch records, 0 policies, 12 sessions, 0 cache entries, 13 snapshots, 67 chunks, 0 running jobs, 0 persisted streams
     

     

    Tuesday, January 8, 2008 10:44 AM
  • User-1136466523 posted

    Hi,

    From the log you provided, we can’t find any exception throwed in it. It just initializes the reporting service according the definition on the config file.

    Is it all of your log? If not, try to find the exception which start with:

    ReportingServicesService!library!a!e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException …

    And then try to check what cause the error. (From the first post you provided, I do think it’s caused by the expiration of sessions).

    Thanks.

    Tuesday, January 8, 2008 9:33 PM
  • User-1726612628 posted

     Hi,

    I worked a little on the problem and I may have some more details.

    I run the report viewer from my asp.net application and it is config to send me mail with the exception when ever there is an error.

    I added to my mail (except from the exception) the stack trace.

    Like I said, The error happen when I'm browsing to my page with  the report view. the report is loaded and is looking fine. after not doing any thing on the page for 10 minuts (the page don't have any auto refrese or any thing) I'm getting the error mail.

     

    The exception is:

    "Execution '1ygyimm3u2mtryh451zwssff2' cannot be found ---> Execution '1ygyimm3u2mtryh451zwssff2' cannot be found"


     In the stack trace, The last lines are (There is something about session but its not the last line):

    at system.web.services.protocols.soapHttpClient.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)

    at system.web.services.protocols.soapHttpClient.invoke(String methodName, Object[] parameters)

    at microsoft.sqlserver.reportingservices2005.Execcution.reportExecutionServices.GetExcecutionInfo()

    at microsoft.sqlserver.reportingservices2005.Execcution.reportExecutionServices.GetExcecutionInfo()

    at microsoft.reporting.webForms.serverReport.touchSeesion()

     at microsoft.reporting.webForms.SessionKeepAliveOperation.PerformOperation(name ValueCollection urlQuery)

     ----End of stack----

    A session problem sounds like a reasonable cause but I don't see way only after 10 minuts its happen and who is asking to check the session again since I'm not doing anything on the page.

    Is there any thing I can do The keep the session alive?

    Its look like a problem with the reportViewer control...

     

    Thanks a lot for your help so far.

     

    Roy. 

    Wednesday, January 9, 2008 3:07 AM
  • User-1136466523 posted

    Hi,

    First, could you please check how do you handle with your session state? It’s most likely that you are using in-proc session state (which is by default).

    Second, go to the application pool, in properties, what is the maximum worker processes you set? 1 or 2?

    When you use in-proc session with two worker processes, each one has its own version of session which is independent with each other. As a result, if a request for the page is routed to one worker process, but the request for the report content goes to the other process, the second request will not find a session and assume it has expired, then the error occurs.

    The two ways to work around this are to either use only a single worker process or to use out-of-proc session state, such as SQL Server. 

    For more information on session-state, see:

    http://msdn.microsoft.com/en-us/library/ms178586.aspx

    Thanks.

    Wednesday, January 9, 2008 4:55 AM
  • User-1726612628 posted

     Hi.

    In my application web.config I'm useing:

    <sessionState timeout="60"></sessionStste> 

     

    Any way, I check in my sqlServer and on my ASP.net server and all application pool are set to allow 1 working process so I don't think that this is the problem.

     

    One more thing that can help is another symptom:

    I've just noticed that localy, I can't run the reports at all useing the report viewer control.

    When I'm running it with the Visual studio in localhost I get that erorr inside the report view as soon as the page load.

     

    Can it be some thing to do with securty?

     

    Thanks again for the help. 

    Wednesday, January 9, 2008 6:50 AM
  • User-1136466523 posted

    Hi,

    One more thing that can help is another symptom:

    I've just noticed that localy, I can't run the reports at all useing the report viewer control.

    When I'm running it with the Visual studio in localhost I get that erorr inside the report view as soon as the page load.

    For such scenario, as far as I can see, your aspx code contains hard-coded reportserverurl and reportpath values, which are different from development and production machine. If that’s the fact, try to set those settings dynamically in your page, reportviewer would end the client session since the report path has been changed from one server to another.

    Hard-coded:

    <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote" >
    <ServerReport ReportServerUrl="
    http://YOURSERVER/ReportServer" ReportPath="/YOURPath" />
    </rsweb:ReportViewer>

    Dynamically:

    <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote">
    <ServerReport />
    </rsweb:ReportViewer>

    Can it be some thing to do with securty?

    As far as I know, I'm afraid that I can ‘t find anything related to the security settings.

    Thanks.

    Wednesday, January 9, 2008 9:01 PM
  • User-1726612628 posted

    Hi,

     

    Well, Its look like I Hit one neasty error.

     I tried what you suggest and a few other thing and it doesn't work.

     

    I set and looked at my page after 10 minuts and the problem is that after 10 minute it trying to reload the report and thats the problem.

    It really look like a session problem but I don't know what also to do.

    I checked all session configuration on my SSRS on my ASP.net server and in my application and nothing is set to less then 20 minuts.

    I don't know what alse to do.

     

    Any way, Since there isn't a solution I think I'll just leave it like this and hope that users won't stay in this page for more then 10 minuts more then few times.

     

    Thanks for all of your help,

    Roy. 

    Thursday, January 10, 2008 2:41 AM
  • User840984748 posted

    Hi,

            In the report server site settings, increase the report execution time out and check whether the issue is still exist. i solved the same by changing this.

    Regards,

    Haseena.

    Thursday, October 9, 2008 2:49 AM
  • User-796790733 posted

    Hi Michael,

    I have a different question. Have tried posting in many places but no response. How do I create a simple one to many report with business object. I have a business object which returns a collection of Employees. The employee collection has a group collection. Each employee can be part of more than one group. Am searching for teh last 3 days. Can u please help. Thanks

    Wednesday, November 12, 2008 3:46 PM
  • User-50421769 posted

     Hi Nai-Dong Jin,

    One of my customer is also facing same kind of problem.

    Environment:

    SSRS 2005 - Scale out installation, and configured two report server sites.

    Machine 1: Windows 2003 R2 - OS, Our Application, SSRS 2005 SP3 & ReportServer Web site configured

    Report server used scale out deployment.

    Machine 2: SQL Server 2005 SP3 - Report Server Databases are installed.

    They are getting the rsExecutionNotFound error on loading the report it self from our application (using ReportViewer Control), but they are able to run the reports from the report server (http://localhost/Reports/Pages/Report.aspx?ItemPath=%2fProjectStatusDetail)

    As per your instructions I requested for the report server log files and here is the content from the log file.

     

     <Header>
      <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
      <Locale>en-US</Locale>
      <TimeZone>Central Daylight Time</TimeZone>
      <Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServer__04_28_2009_13_37_32.log</Path>
      <SystemName>AZPH-SRV-AP96</SystemName>
      <OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
      <OSVersion>5.2.3790.131072</OSVersion>
    </Header>
    w3wp!webserver!1!4/28/2009-13:37:33:: i INFO: Reporting Web Server started
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing ConnectionType to '1'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing IsSchedulingService to 'True'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing IsNotificationService to 'True'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing IsEventService to 'True'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing IsWebServiceEnabled to 'True'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing ProcessRecycleOptions to '0'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing WatsonFlags to '1064'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing SecureConnectionLevel to '0'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing DisplayErrorLink to 'True'  as specified in Configuration file.
    w3wp!library!1!4/28/2009-13:37:33:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'  as specified in Configuration file.
    w3wp!resourceutilities!1!4/28/2009-13:37:33:: i INFO: Reporting Services starting SKU: Standard
    w3wp!resourceutilities!1!4/28/2009-13:37:33:: i INFO: Evaluation copy: 0 days left
    w3wp!resourceutilities!1!4/28/2009-13:37:33:: i INFO: Running on 2 physical processors, 4 logical processors
    w3wp!runningjobs!1!4/28/2009-13:37:33:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.  Cycle: 600 seconds
    w3wp!runningjobs!1!4/28/2009-13:37:33:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    w3wp!runningjobs!1!4/28/2009-13:37:33:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    w3wp!runningjobs!1!4/28/2009-13:37:33:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.  Cycle: 60 seconds
    w3wp!library!6!04/28/2009-13:37:35:: i INFO: Catalog SQL Server Edition = Enterprise
    w3wp!session!8!04/28/2009-13:37:37:: i INFO: LoadSnapshot: Item with session: gqrctb55jcpyflen2dd4ao55, reportPath: , userName: CVTY\invisionusr not found in the database
    w3wp!library!8!04/28/2009-13:37:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gqrctb55jcpyflen2dd4ao55' cannot be found, ;
     Info: Microsoft.ReportingServices.Diagnostics.Utilities.ExecutionNotFoundException: Execution 'gqrctb55jcpyflen2dd4ao55' cannot be found

     

    Could you please look into the log file and find out what is happenning on the server & Please let me know if there are any other places to be checked.

    Wednesday, April 29, 2009 7:53 AM
  • User909355322 posted

     I got similar problem. There are two possible reason:

    1) You got a big report,

    Refer to http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

    2) Reporting web server stopped and started.

    You need changed your report server IIS application pool configuration. a} Set "Recycling -> Recycle work processed at the following times"  at a after hour time e.g 01:00. b) Set "Performance->Idle timeout -> Shutdown worker processes after being idle ... " to a longer time e.g 480 mins.

     Hope it will be helpful

    V.

     

     

     

     

     

    Wednesday, May 13, 2009 8:51 PM
  • User-486324517 posted

    I experienced the error and found a different cause. With some help of a knowledgable DBA, I was able to get rid of the error which allowed the report to render.
    It seems as if there was an issue with "paralellism" (because of the way I structured my JOINS). I added OPTION(MAXDOP 1) at the end of the query and it was much faster and allowed the query to complete without erroring.

    Monday, September 21, 2009 2:59 PM
  • User-1106678467 posted

    Found this on another forum an thought I should pass it along... look for a trailing space on the report path. Get rid of it and report works fine (at least it did for me).

    Saturday, March 7, 2015 9:40 AM