topic Re: OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB - Help! in QlikView

OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB - Help!

Fri, 27 Jun 2014 09:46:35 GMT

Hey guys,

I'm getting this error when trying to load 3 different files into Qlikview (File 1 = 118mb, File 2 = 50mb and File 3 = 155kb):

OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB

What do I have to do to fix it?

Any help would be appreciated!

Thanks!

Mav

Re: OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB - Help!

jerrysvensson — Fri, 27 Jun 2014 10:19:05 GMT

Buy more memory.

Re: OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB - Help!

hic — Fri, 27 Jun 2014 10:22:48 GMT

You probably have a problem with your data model. Load just a small amount of data using the same model, hit <ctrl>-T, look at your model, and ask yourself: Is this what I want? Then make necessary changes to the script.

Another possibility is that you have a chart with too many dimensions, that will eat all your memory. Remove all dimensions, but one, and see how much memory the application uses. Then add a second dimension and test, etc.

HIC

Re: OUT OF VIRTUAL AND/OR LOGICAL MEMORY, allocating 2MB - Help!

ramkrishna86 — Fri, 27 Jun 2014 10:48:07 GMT

Hi,

This type of problem occurs due to wrong data model, 300-400 MB QVW size is common. Please check your data model have any synthetic key?

If there is any synthetic key then it will consume memory and while reloading it will give you an error.

Thanks,

Ram Krishna