System.MemoryOutOfException | SSRS Report Builder

Question

Facing issue : System.MemoryOutOfException error

I have created a SSRS report in report builder with a Table consisting of 350 columns and 14 lakh + records, data is coming from a parallel processing SQL server database.
Data from all 350 columns needs to be displayed in table in report and it is getting filtered through 8 query parameters.this comes becomes buisness wants to export the data and compare within different matrices.

Please suggest any performance improvemnt tips or tools which can be used to achive above results. The only condition the data cannot be reduced we need to all the records in tables.

Answer 1

Report Builder isn't the right tool for your requirements.
Use a SSIS package instead, it's a ETL tool designed for such amount of data.

See SQL Server Integration Services

Answer 2

Hi @Vishal Bhattacharya ,
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, we can 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, we can also refer to the following thread: https://social.technet.microsoft.com/Forums/en-US/b1439ebe-9bb4-4786-b43c-1d12b84117dc/systemoutofmemoryexceptionmicrosoft-sql-server-report-builder-30-product-version-11030000?forum=sqlreportingservices

Best Regards,
Joy

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.