Out of memory (Reporting Services error)

Krzysztof M 0 Reputation points
2023-01-13T10:30:33.3733333+00:00

hi

I have a problem. I have created a report which shows the data from table in SQL Server (just a "select * from [table] where catid in (..)).

There is a parameter where I can choose if it should show MAIN categories, OTHER categories or ALL categories - and depend on choose - the list of catid is shorter or longer.

It works fine when I choose MAIN or OTHER categories. But when I choose ALL - after some time I receive an error - out of memory.

Result of this select (for all categories) is quite big - 25k records, but it should just be shown - there are no calculations in the report.

What is more strange - this worked a month ago for me and other people, but a week ago in stopped working on my collegue's computer, but still worked on mine. Today it stopped working also on mine.

I tried to restart (local machines, SQL server) - nothing helped.

Do you have any idea why it happened like that and how to fix it?

Regards

Chris

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,993 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,451 Reputation points Microsoft Vendor
    2023-01-16T01:47:25.18+00:00

    Hi @Krzysztof M

    According to my searches, the "Out of memory" error is an error that occurs when the system does not have enough memory to complete the requested operation.

    You can resolve the issue by configuring a reasonable memory management strategy for the report server application.

    https://learn.microsoft.com/en-us/sql/reporting-services/report-server/configure-available-memory-for-report-server-applications?view=sql-server-ver16

    Also try adding enough physical memory to the report server, or upgrade to a 64-bit version of Microsoft SQL Server Reporting Services, or run the report at a time when the memory limit is lower.

    For more details, you can refer to this link: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/93f82018-daa3-4703-8d69-c2e2389d17fc/systemoutofmemoryexception-for-ssrs?forum=sqlreportingservices.

    Best regards,

    Aniya

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.