January 13, 2023 at 10:22 am
hi
I have a problem. I have created a report which shows the data from table in SQL Server (just a "select * from
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
January 13, 2023 at 2:12 pm
Responses are going to https://www.sqlservercentral.com/forums/topic/out-of-memory-error-code-2 (duplicate posts)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy