Report Builder System.OutOfMemoryException

[nataliafedoun]

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, is there maybe something I can add in the query to make it run?

[v-binbinyu-msft · Accepted solution]

Hi @nataliafedoun ,

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) | M...

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.