Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Report Builder System.OutOfMemoryException

Hi, I'm trying to create a paginated report in Report Builder.  I haven't been able to get it to let me view the report, not even if I try to run it with less data. The data source is quite large, ...
System Out Of Memory
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    As per my understanding, the System.OutOfMemoryException error is an error that is raised by Reporting Services when an operation requests more memory from the system and the system cannot provide the memory. This issue always occur when the computer does not have sufficient memory to complete the requested operation. Including the report is too large- returns too much data by the dataset.

     

    In order to narrow this issue, you could refer to the following methods:

    • Add sufficient physical memory to the computer.
    • Upgrade to a 64-bit version of Microsoft SQL Server Reporting Services.
    • Schedule reports to run at off-hours when memory constraints are lower.
    • Adjust the MemoryLimit setting accordingly.
    • Redesign the report.

    Besides, you could also refer to the following document: System.OutOfMemoryException(Microsoft SQL Server Report Builder 3.0 Product version 11.0.3000.0) | Microsoft Learn

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

As per my understanding, the System.OutOfMemoryException error is an error that is raised by Reporting Services when an operation requests more memory from the system and the system cannot provide the memory. This issue always occur when the computer does not have sufficient memory to complete the requested operation. Including the report is too large- returns too much data by the dataset.

 

In order to narrow this issue, you could refer to the following methods:

  • Add sufficient physical memory to the computer.
  • Upgrade to a 64-bit version of Microsoft SQL Server Reporting Services.
  • Schedule reports to run at off-hours when memory constraints are lower.
  • Adjust the MemoryLimit setting accordingly.
  • Redesign the report.

Besides, you could also refer to the following document: System.OutOfMemoryException(Microsoft SQL Server Report Builder 3.0 Product version 11.0.3000.0) | Microsoft Learn

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.