System.OutOfMemoryException

System.OutOfMemoryException

Posted by: tskelley on 30 July 2018, 9:51 am EST

• 

  tskelley

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 July 2018, 9:51 am EST - Updated 30 September 2022, 3:14 pm EST

  We have large data returning from SQL server database more than 15,00,000 record. when we tried to bind this data to active report file (.rpt) we are getting exception System.OutOfMemoryException

  We are unable to attach Xml data source as it 2 GB size but we are attaching following information

  1. Design_Tool.PNG (its shows the exception)
  2. FilesInfo.PNG (it shows file size)
  3. ReportFile.rpx (Report file)
     

     617×680 21.3 KB
     

     1258×979 39.3 KB
• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 31 July 2018, 1:11 am EST

  Hello,

  I am able to replicate the issue at our end. I have escalated the issue to our developer team(ID 261471) and will revert you once I get any information from them.

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 August 2018, 7:05 am EST

  Hello,

  Could you please try with x64 target platform.

  Thanks

• 

  tskelley

  • Post Options:
  • Link
    Copy

  Posted 1 August 2018, 8:09 am EST - Updated 30 September 2022, 3:14 pm EST

  Hello,

  We running on 64 bit machine with 8 GB RAM. here is the machine details.
  
  

  

  1225×191 11 KB

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 August 2018, 9:01 am EST - Updated 30 September 2022, 3:15 pm EST

  Hello,

  Could you please try with “End User Designer” application located at “~\Documents\GrapeCity Samples\ActiveReports 12\Professional”. Also, please run the application after changing the platform to x64.

  Thanks
  
  

  

  641×519 10.9 KB

• 

  tskelley

  • Post Options:
  • Link
    Copy

  Posted 24 October 2018, 2:24 am EST

  Hello,

  We have done the changes in the project file for changing platform to x64 but it still getting error system out of memory exception.

  Is there any way to implement load on demand on the active report viewer? For example, load first 100 records on the first page and then on 2nd-page load next 100 records…

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 24 October 2018, 8:48 am EST

  Hello,

  I have forward the information to our development team.

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 25 October 2018, 7:43 am EST

  Hello,

  Please try after loading the data at the runtime. Please refer to “To use an Unbound data source” topic in the following link:
  
  http://help.grapecity.com/activereports/webhelp/AR12/webframe.html#BindReportstoaDataSource.html

  Also, you can refer the following link for optimization of the section report.
  
  http://help.grapecity.com/activereports/webhelp/AR12/webframe.html#OptimizingActiveReportsj.html

  Hope it helps.

  Thanks,

• 

  tskelley

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 7:12 am EST

  Hello,

  Unfortunately, the solution you provided is not working in our scenario, we are creating report dynamically and we are not using any subreport in our scenario.

  Again is there any way to get pagination event so that we can bind the record to report per page instead of loading all data once.

  Thanks,

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 1 November 2018, 6:15 am EST

  Hello,

  Sorry for the confusion. I meant to say to bind the data at runtime not using the subreport. “FetchData” event fires at every page start to collect the data from the file. You can refer the “To use an Unbound data source” topic in the following link:
  
  http://help.grapecity.com/activereports/webhelp/AR12/webframe.html#BindReportstoaDataSource.html.

  Also, refer to the product samples for the same:
  
  ~\Documents\GrapeCity Samples\ActiveReports 12\Section Reports\Data\UnboundData

  Hope it resolves your problem

  Thanks,