Memory issues while running a yearly report
One of my consultant is trying to run an yearly report which consumes approximately 3 GB of size. But, the memory available at that point is only 2 GB on the server. The report generates a runtime error "SYSTEM_NO_TASK_STORAGE".
But, when I restart the server, all the buffers are cleared and there is 5 GB space after which the report runs to success. The number of program swaps in ST02 are more than 3000. The swap space assigned is 400 MB.
I believe that increasing the swap space can resolve this issue. But, I would like to know any other better solutions for this.