Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rittermd
Honored Contributor

Out of Calculation Memory

This error is showing up in the Sessions Details sheet of the Operations Monitor provided by Qlik Sense.

We have made no modifications to this app.

There is only 3 months of data.  If I filter on 1 or 2 months the error goes away.  If I try to see all 3 months I get the error.

Anyone else have this problem?

We are running QS 3.1.1

8 Replies
tcybucki
New Contributor

Re: Out of Calculation Memory

I just ran into this problem too, not a lot of data in the table where it just won't load

Edit: This has been happening since we updated to 3.1. We were running 2.0 prior to this and not experiencing the problem.

Now it is happening everytime we load up any app with a table with what seems to be more than 1000 rows. You see every table attempting to calculate for several minutes:Capture.JPG

After 10-15 minutes, it gives up. This is a major problem for us as we are about to deploy production Apps to our operation, and we are only experiencing this issue since we updated to 3.1 last week. We were running tables with hundreds of thousands of rows, with fairly little issue, but now I can't load a couple thousand. I cannot navigate the filter panes because the dimension choices will not even show up, so now we have no data loading.

Nothing has changed in our Qlik Sense Server set up within the past week. We have had Qlik Sense Server deployed for a year and a half, and this issue rarely appeared. Is there any reason why this would be occurring?

Re: Out of Calculation Memory

Hi,

It may be because the RAM is not sufficient to load the data, increase the RAM and check.

If Issue still exists, contact Qlik Support and log the ticket.

Regards,

Kaushik Solanki

lakshmikandh
Valued Contributor II

Re: Out of Calculation Memory

Did you check the log files ? Yes, there could be a issue with Upgrade.

Please check log files if there is anything captured, check if your connectivity to the database is normal as earlier.

datalakeyu
Valued Contributor

Re: Out of Calculation Memory

There is no synthetical key in my data model. However, Out of calculation memory happens to a table and a map in the Qlik app.

Any suggestion?

Thanks!

lech_miszkiewic
Honored Contributor III

Re: Out of Calculation Memory

There is many things you can improve.

  • what is a dimension in your table (field or calculated dimension)?
  • what is your expression
    • does your expression use data island calendar
    • Is it maybe "=sum(If...)" expression?
  • How is your model build - does your expression have to run through all rows in your fact table or you can use set analysis to pre-filter rows only to those which have to be calculated.

Can you screenshot your datamodel and highlight where are all components coming from ?

Maybe QlikSense seems to be easy tool to use, but performance tuning requires knowledge on how to make all expressions/objects responding fast.

We will take it from there.

cheers

Lech

lech_miszkiewic
Honored Contributor III

Re: Out of Calculation Memory

obviously other comments regarding CPU and memory are 100% valid too!!!

If there is enough memory and you still run at the error you may need to increase calc time (this is a setting in QMC Engine settings)

1.png

datalakeyu
Valued Contributor

Re: Out of Calculation Memory

16 GB RAM and Intel I-7, there should be no memory and CPU issue.

How to increase calc time in Qlik sense desktop?

I am using Qlik sense desktop version 3.2 SR 4.

Thanks!

lech_miszkiewic
Honored Contributor III

Re: Out of Calculation Memory

Hi, How about other staff i asked about - probably more important than computer specs?