There is insufficient system memory in resource pool 'internal' to run this query when printing more than 200 bills on crystal report

Question

1.00/5 (1 vote)

See more:

The system RAM is 4GB Got the error "There is insufficient system memory in resource pool 'internal' to run this query" while the crystal report is printing more than 200 bills. minimum memory per query(in KB) is 1024. SQL Server 2008-r2 version has been installed.

how can I fix this issue?
if I clear the memory how can I clear it without affecting the current system

What I have tried:

I increased

minimum memory per query(in KB) is to 2048

Posted 22-May-22 20:27pm

Member 11788138

Updated 22-May-22 22:31pm

Add a Solution

Comments

Richard Deeming 25-May-22 5:25am

NB: SQL Server 2008 R2 has been "end-of-life" since September 2019. When the server this is running on eventually dies, you should look to upgrade to a supported version of SQL Server - especially since you can't install that version on any OS later than Windows Server 2012 R2 or Windows 8.1, both of which are effectively "dead". (Server 2012 R2 is eol in October 2023; 8.1 is eol in January 2023.)

Until you replace it, I hope this server is behind some serious firewalls, and has a decent antivirus system in place!

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2022-05-22T22:31:00

Solution 2

You might try the Cumulative Update 4 for SQL Server 2008 R2 if you don't have that installed already:
KB982854 - FIX: Error "There is insufficient system memory in resource pool 'internal' to run this query" in Microsoft SQL Server[^]

Posted 22-May-22 22:31pm

RickZeeland

Pete O'Hanlon · Answer 2 · 2022-05-22T21:10:00

Wow. I'm not surprised you are running into this issue. The message you are getting is a SQL Server message and it's really telling you that you don't have enough memory to process your query. If you have a lot of records to work through, you should add a lot more memory.

SQL Server is a server based system meaning that it should be running on a server; which would have a lot more memory than you would get in a desktop system.