Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gerhardl
Creator II
Creator II

Memory Error

Hi,

I've been working for weeks on a QV application that covers all aspects of our business. It is coming along beautifully but suddenly (after adding a few application extracts) I am getting a continuous error message - "Out of virtual and/or logical memory, allocating 2MB".

It pops up every few seconds and a lot of my charts now have "no data to display".

I really don't want all of my hard work to go down the drain because my laptop is crappy - what can I do?

Thanks,

G

1 Solution

Accepted Solutions
montubhardwaj
Specialist
Specialist

Hi G,

Below points will be of some help to you:

It's hard to say what the issue is right away like this. The actual file size usually has little to do with the amount of RAM consumed when calculating objects. This error message can occur for several reasons. If it's a chart it is because of your expressions. You either have too much data, to long, or a really bad if/else statement in one of your expressions.
However, here are a few things that are usually present in objects where Out of object memory occurs.

As a first step, you look at the number of fields being included in the application and validate that they are all required. Fields loaded but not referenced in any sheet objects will still use memory.

Pivot tables give the user a massive amount of flexibility but basic straight tables are less memory intensive in large data volume implementations.

Removing data that is not required from your data model can reduce the volume and uniqueness of the data model. You can simply comment the columns out to ensure that if they are needed at a later date you can easily add them again.

Do not write complexformulas in your chart expressions. Try to do all the calculations in the script part.

Also, try to avoid synthetic keys in your data model. They are not always very harmful but can cause serious problems if your database is not proper.

View solution in original post

7 Replies
Not applicable

Hi G,

try to remove the complicated expressions in your chart and write these in Script instead of layout

Reduce the complexity on Layout.

Regards

Sravan

Not applicable

HI G, After adding new extract to your application , i think you might have not checked the

Expressions. Please see if any fields or variable is not present over there..

also if too many dimensions are there in chart memory goes OUT.

I hope this will help u

gerhardl
Creator II
Creator II
Author

Hi,

I think the problem is that there are fields in my application extract that are the same as in the other extracts I use. And because I am new to QV I do not really know when to use Load, Concatenate Load, Join, etc...

At the moment I have:

  1. Load Account Extract
  2. Load Transaction Extract
  3. Concatenate Load Transaction Extract (x 20)
  4. Load Application Extract.

I then get the following message at the end:

One or more loops have been detected in your database structure. Loops may cause ambiguous results and should therefore be avoided. QlikView will cut the loop(s) by setting one or more tables as loosely coupled. Settings for loosely coupled tables can be modified after script execution in the tables page of the document properties dialog.

And then all my Transaction data is wrong and I get the memory error message. If I choose concatenate load some of my other chart data is wrong!

There are fields in the Application extract that are the same as in the Account Extract, which load statment should I use?

Thanks,

G

Not applicable

Can you share you application ????/ it will be easy for us

gerhardl
Creator II
Creator II
Author

I'm not actually allowed to as it contains client information. Plus it is HUGE. How about just the script? Will that help? It is HUGE too though...

montubhardwaj
Specialist
Specialist

Hi G,

Below points will be of some help to you:

It's hard to say what the issue is right away like this. The actual file size usually has little to do with the amount of RAM consumed when calculating objects. This error message can occur for several reasons. If it's a chart it is because of your expressions. You either have too much data, to long, or a really bad if/else statement in one of your expressions.
However, here are a few things that are usually present in objects where Out of object memory occurs.

As a first step, you look at the number of fields being included in the application and validate that they are all required. Fields loaded but not referenced in any sheet objects will still use memory.

Pivot tables give the user a massive amount of flexibility but basic straight tables are less memory intensive in large data volume implementations.

Removing data that is not required from your data model can reduce the volume and uniqueness of the data model. You can simply comment the columns out to ensure that if they are needed at a later date you can easily add them again.

Do not write complexformulas in your chart expressions. Try to do all the calculations in the script part.

Also, try to avoid synthetic keys in your data model. They are not always very harmful but can cause serious problems if your database is not proper.

gerhardl
Creator II
Creator II
Author

Hi,

Synthetic keys seems to have been the issue. I have change all the names of the Application extract fields that also occur in other tables. This might cause problem later on but for now it seems to have solved the memory problem.

Thanks to everyone,

G