Running RDL results in System Out Of Memory Error

Question

I'm running SSRS on SQL Server 2016. I'm using Visual Studio 2017 for development (these versions are both restrictions from my company). When running a particular report (RDL) I'm getting the following error. Before I go to my IT department, I just want to know (if anyone can tell) is this something that is typically thrown by the server? Low resources on the server side? I have 32GB RAM on my local PC so I don't believe there is a limitation on my machine. Anyone familiar with this one?

Answer 1

While the error you're encountering could be related to low resources on the SSRS server side, it could also be caused by issues with the report's complexity or the SQL queries being used. The best next step would be to investigate the SSRS logs, check server resource usage during the report execution, and optimize any heavy queries in the report.

If you're still seeing issues after these steps, it may be time to involve your IT department to help analyze server performance and configuration.

Answer 2

Hi @Dom,

From the error message, the System.OutOfMemoryException error indicates that SSRS request 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, please have a double check if you are designing a complex report with large data.

Also check Configuring Available Memory for Report Server Applications

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.