Out of Virtual and/or logical memory, allocating 1MB

[#1]

Dear All,

I am facing a prblem while reloading the data into qlikview developer.

The error is "Out of Virtual and/or logical memory, allocating 1MB"

Can some one let me know, what is the issue.

We need to upload the production data.

~Amit

[#2]

Hi Amit,

Do u have any synthetic key in your data model...?

if so try to break those keys

Check whether your data models and link between the tables are proper..?

- Sridhar

[#3]

check the size of the memory in the user preference tab. Go to Settings--> User Preference --> Objects --> Increase the memory size of calculated formulas and multi boxes. Try again.

Try to avoid count, distinct functions in the expressions.

Thanks,

Raghu.

[#4]

Hello Amit,

I had the same problem a couple of weeks ago. I googled it and got the tip that I would max out the allowed virtual memory on my machine. Also the tip was to put the initial size of the page file at the same as the maximum.

You control the virtual memory in System properties/advanced/performance settings/advanced/Virtual memory change

I'm running with 4gb physical memory so I did set both the initial and the maximum size to 4096 mb. I have not experienced any problems since.

[sathishkumar_go]

Hi

My suggestion is increase ur virtual memory in ur system.

-Sathish

[johnw]

I'd either add RAM or figure out how to make your application take less memory. QlikView gets VERY slow when running from virtual memory.

[#7]

Hi Raghu,

When I go to Settings--> User Preference --> Objects -->

both the memory size of calculated formulas and multi boxes are not enabled.

So, I cant change it.

Can you tell me, how to enable those boxes.

Rgds/Amit

[#8]

Hi Max,

I am also having 4gb physical memory and as mentioned by you, i adjusted the virtual memory to 4096 mb, but still I am getting the error.

Pls. let me know how to resolve this.

Rgds/Amit

[#9]

You set both the initial and maximum to 4096?

[rwunderlich]

amitkumar wrote:
I am facing a prblem while reloading the data into qlikview developer.
The error is "Out of Virtual and/or logical memory, allocating 1MB"

This is almost always a problem with the data model. Can you load a limited number of records? (In debugger, check "limited load" and pick a small number like 100).

If the limited load works, can you upload the file so we can look at it and give you advice? If you need to protect the privacy of the data, use the scrambling feature. See http://community.qlik.com/wikis/qlikview-wiki/preparing-examples-for-upload-reduction-and-data-scram...

-Rob