.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
ASPEvil
Jean Paul
satyapriyanayak
Ashutosh Jha
SP
Post New Web Links

Issue - The report execution has expired or cannot be found. (rsExecutionNotFound)

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
 

Hello Experts,

I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,

"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.

When I see SQL Server log after this issue comes I see following message there;

"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"

IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.

I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.

Please help me to know what are these issue, are these two issues related and how to fix it?

Regards.




View Complete Post


More Related Resource Links

Page expired after report execution

  

Hi.

I have created a complex SSRS 2005 report that queries a large dwh and a SSAS 2005 cube. Now, when I launch the report, the rendering takes more two hours and when I click to navigate on a drill-down report I have an error about the page is expired.

Any idea to solve this issue? Thanks


Data source not found issue in subscribed report (subscribed in ssrs 2005) , with shared data source

  

Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.

 1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.

2) The reports use a shared data source with name ‘Test Center’

3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!

4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.

5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.

6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.


- Thanks & Regards, RaSuHe

Item cannot be found.(rsItemNotFound) when executing a report from a sharepoint Website

  
Hello,
I have managed to integrate Report server with Sharepoint .
I created a report with it's data connection with microsoft Visual Studio 2005 , tested it , than deployed it to the specified document libraries in sharepoint.
Everything works fine till now.But when i try to execute the report from the document library in sharepoint the Message :
  • The item 'Reports/Report1.rdl' cannot be found. (rsItemNotFound) '. Even though the report1.rdl is inside the website and is returned when i do the search. Regards.

  • IE cannot display the webpage during report execution

      
    Hi. I have a problem with a report having some T-SQL and MDX queries. When I execute it during the working hours I have an error about that Internet Explorer cannot display the web page, but in the other hours the execution is completed successfully. I have a look inside RS log but I cannot find any errors; no timeout is set about report execution inside the Report Manager. Any ideas to solve this issue, please? Many thanks

    SharePoint 2010 Reporting Services report on sharepoint list rsExecutionNotFound

      
    I cannot get SQL Reporting Services 2008 R2 to work with a datasource that is a sharepoint list.  Reporting services seems to work fine setup in SharePoint 2010 Integrated mode. When I try and run a report that is based on a sharepoint list, I immediatly get the following error: The report execution tp15sp4515l3seqqo4do3e45 has expired or cannot be found. (rsExecutionNotFound) This seems to be something I am doing wrong with the sharepoint configuration, I would guess.  I haven't tried a regular database query, but they used to work when reporting services was configured for native mode.  So I assume this is just a problem connecting to sharepoint 2010 lists, with the new SharePoint 2010 List connection type. Edit This has got to have something to do with a permission setting for the app pool account of sharepoint.  I read something once where it said you had to grant it permissions, but every guide I've found since then doesn't mention anything about it. This log entry is where the problem seems to be occuring, I just don't know what permissions to give TESTDOMAIN\spweb which is the app pool account. library!ReportServer_0-3!1bdc!09/01/2010-09:58:03:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, tim

    "Access Denied" and RunwithElevatedPrivilages issue (Yes, I've found the other posts in the Forum)

      
    I just *KNEW* I had found a fix for my issue in the forums at http://social.msdn.microsoft.com/Forums/en-US/sharepointdevelopment/thread/c3d2b304-7fcc-40d2-86ce-61d9b21b03d7/ However, I've tried every suggestion made in this thread and *still* get issues in that the 'normal' end user cannot see the form. I have any overly simple form in the layouts folder with a lable and a table. I can write the Site Title to the label, and need to add rows to the table, one for each Site Owner (Full Control user) found for the site. This form will be available to anyone with access to the site. However all I get is: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) I have confirmed the application pool identity is the correct service account for the farm.  Here is the code I'm using; can anyone advise where I'm stepping on my own toes? protected override void OnInit(EventArgs e) { try { SPSecurity.RunWithElevatedPrivileges( delegate() { using (SPSite site = SPContext.Current.Site) { site.AllowUnsafeUpdates = true; SPWeb web = SPContext.Current.Web; web.Site.CatchAccessDeniedException = false; thisSiteTitle.Text = web.Title.ToString(); //FindSO(web); //BEGINNING OF COPIED FINDSO CODE writeToEventLog(app, "2", "2"); ArrayList allOwner

    financial report issue

      
    I am working on a project that is involved in financial reports. Here is what I want to accomplish I have a table (tbl_receivables) with id, accoundID, transDetails, debit, credit columns.  When I publish my receivables report I would like to see a balance field along with the table columns. Balance field value should be generated runtime and would give value of: current row credit - current row debit + previous row balance total. Should this calculation be handled in SQL server side or asp.net side? Is there any tutorial link that you can share with me?  

    SSIS Package execution issue

      
    HI ALL i am in great need,i am using ssis 2008 i have a package and two task in it..both task have OLEDB source and OLEDB desination when i execute the package whole data get dump from source to destination .but still my package does not show that it has been executed successfully..means package still show yellow color (processing mode)..not showing green color even after dumping whole data BOth package run one after other first dataflow task i have join with second data flow task....(second task start loading data but still fist package that has loaded data is in yellow color)

    Job Execution times / statistics report ...

      
    We have several sites (countries if you may call them) and each site has its own set of ERP databases (Progress database). We have designed ETL layers that are open and which can be invoked for each of these sites. On top of the ETL layers, we scheduled the SSIS packages via SQL jobs for each site and scheduled them to run at various times of the day based on the site operating hours. I want to now present the amount of time it takes to copy data from the ERP system into our SQL 2008 Staging and finally into our DataWarehouse. I can manually right click on the SQL jobs and get the timings, however, I want to automate this report so that we can look at it initially weekly and maybe monthly when things start to run smoothly. Any pointers or ideas? I know I can run SQL Profiler and capture the SQL behind this report, would it actually work? ThanksJagannathan Santhanam

    wired issue while modifing Report Desgn tab?

      
    Hi Experts, When ever I modified anything on my rdl file through BIDS 2008, (SSRS 2008), any dam thing (like "rearrange the position of any report item" or "changing any report item property", etc) it is adding below code into the rdl (xml) file , which results into the below error message:- <ConnectionProperties> <ConnectString /> <IntegratedSecurity>true</IntegratedSecurity> </ConnectionProperties> Error Message:- An error occurred during local report processing. The definition of the report'/rdl_file_name' is invalid. The report definitio is not valid. Details: The report definition element 'ConnectionProperties' is empty at line 8, position 9. It is missing a mandatory child element of type 'DataProvider'. How to get rid of this wired issue? Any Help? Thanks Regards, Kumar

    Report Viewer ASP.NET session has expired

      
    I've found many posts about this error in this forum as well as other forums, however I have not found a solution that has worked for me yet.My report runs fine in Report Viewer and I can export it to PDF without a problem.  The problem occurs if I try running the report or exporting the report again, only 30 seconds later, I receive the session has expired error.There are no images in the report, so setting "AsyncRendering" to False doesn't work for me.I triedsetting <sessionState cookieless="true" /> in my web.config file but that didn't work either.I tried setting me.session.timeout = 120 on my page_load event but that didn't work.All attempts brought me back to the same error.  Hopefully some of the ideas above will help other people, but none have worked for me so far.  Please let me know if someone knows of a  solution/work around to this error.Thanks.

    No available sandboxed code execution server could be found

      
    I am deploying the web parts as the sandboxed solution to the sharepoint 2010 environment and getting following error - "No available sandboxed code execution server could be found.", any idea?

    SSRS Report issue blank page is coming

      
    I have a report with 2 pages, some time the second page doesnot contain the data at that time i want to get only 1 page report. but as of now if second page does not have data it is coming as blank, can anyone help on this. I am using ssrs 2008Jeeva Jacob

    SSRS Issue with reloading Report

      
    Dear all, I have developed a couple of reports and could deploy them to different servers. All reports are working fine at all servers and test computers, however I cannot reload any of the reports on my own PC. I tried with IE7 and IE8 but nothing. Scenario: 1. Go to the report 2. Run the report 3. Change any of the paramters 4. Press View Report Button 5. No reloading nothing changes.   It seems like the system could not pass the new parameter value.   Could you please help me out? Thanks in advanc, Zoltan
    Categories: 
    ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
    Sql Server  SharePoint  Silverlight  Others  All   

    Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend