Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Out of virtual and/or logical memory

Hi All,

     I have encountered memory problems for times. below are the screanshots:

How should i avoid these? Thank you very much!

Capture1.PNG

Capture.PNG

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Out of virtual and/or logical memory

Hi,

I think Quantity of the data causing the issue, try to check this in high configuration machine like server if you have any.

Also, load limited rows like current year or for one company etc, to make sure that huge data is the issue.

Hope this helps you.

Regards,

Jagan.

View solution in original post

8 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Out of virtual and/or logical memory

Hi,

This is because of memory issues, it may be becuase of your expression, data model, Quantity of data displaying in Tables etc.

Regards,

Jagan.

Highlighted
Not applicable

Re: Out of virtual and/or logical memory

Hi,

If you're using a 32-bit system then consider switching to 64-bit.

Otherwise you'll need to reduce the data and consider the tips that Jagan mentioned.

Check this thread:

Internal Inconsistency Type D detected

And the qv support's reply provided in this question:

Internal inconsistency, type D Detected

Highlighted

Re: Out of virtual and/or logical memory

Hi,

Consider increasing ram.

I believe you are running 32 bit of Qlikview desktop installer.

You need to look on how to move for 64 bit with more ram.

Regards

ASHFAQ

Highlighted
Honored Contributor III

Re: Out of virtual and/or logical memory

Increase RAM and Hardware cinfiguration

Highlighted
Not applicable

Re: Out of virtual and/or logical memory


Hi Jagan,

Thank you very much! My expressions and data model are both simple enough.  There are 1 Fact table and 5 dimension tables. There are 107m rows in the fact table. My system is 32-bit.

The straight table contains at most 50 rows. In my case, as you said, it is quantity of data that cause the memory issue?

Highlighted
MVP & Luminary
MVP & Luminary

Re: Out of virtual and/or logical memory

Hi,

I think Quantity of the data causing the issue, try to check this in high configuration machine like server if you have any.

Also, load limited rows like current year or for one company etc, to make sure that huge data is the issue.

Hope this helps you.

Regards,

Jagan.

View solution in original post

Highlighted
Not applicable

Re: Out of virtual and/or logical memory

Yes. we're running 32-bit system on computers. Data in the qvw app is about 11m rows.

Highlighted
Not applicable

Re: Out of virtual and/or logical memory


I am fully with you. My users are all using 32-bit system and they can not add the RAM or change the OS. I think i have to start considering limiting the data quantity. Thanks!