Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Out of Virtual and/or Logical memoory allocating 2MB

Hi,

I got the below error on my local machine for the Qlikview files whose size is more.  The same qlikview file I able to open in the server.

I am able to open the qlikview files whose size is less.

Error:

"Out of Virtual and/or Logical memory allocating 2MB"

Please suggest..

Thanks in advance.

4 Replies
Highlighted
Specialist
Specialist

Hi

QlikView can usually handle large volumes of data. In my experience, this error results from an inefficiency in your model, either the data structure or in an object. I would check:

  • data structure once the script has completed - is anything ambiguous?
  • invalid expressions, for example in a chart
  • a complicated or incorrect calculated dimension

Hope these ideas help.

Highlighted
Specialist III
Specialist III

Hi,

Could be a data model issue.

Mostly joins are getting created that are forming a synthetic key and circular reference.

Do a limited load and check data model for any dotted lines.

thanks,

Rajesh Vaswani

Highlighted
Support
Support

Dear Sir,

One of possible cause is when QlikView is installed on a 32-bits machine.  On 32-bit QlikView use a limited RAM per process even though more physical memory may be available. Using a 64-bit could solve the issue.


If you have a 32-bit PC, you could play by checking which object is taking a lot “memory” or “CalTime” by
1. Making a backup of your application
2. Opening your application in QlikView Desktop >> go to Settings>> Document Properties >> Sheets tab and in the list of objects, look at “memory” or “CalTime” for each object
3. Remove some objects taking “memory” or/and “CalTime”  and test again.


The issue could be related to complex expressions in chart object (use of complex IF condition, etc..)
Try to check the memory usage as well in Windows Task Manager>> Processes tab as you open your application and/or do some selections.


A recommended solution is to review use a 64-bit PC or try to review the model

Regards,

Highlighted
Not applicable

Thanks Josheph and Rajesh for your reply.