6 Replies Latest reply: Dec 21, 2016 1:00 PM by Shubham Singh RSS

    Error Out of Memory Calculation

    Dhanashri Dindore

      Hi Friends,

        I am new to Qlik Sense. We are having Multiple applications with huge database . 

      Now we are using that applications, application shows Error :

       

       

      "Out Of Memory Calculation ".

       

       

      "Out of memory error"? Not during reload. This error occurs in front end.

      We are using filter panes for sorting data but it is quite difficult to select always.

      How to solve this error?

        • Re: Error Out of Memory Calculation
          Shraddha Gajare

          Try to keep default selection on opening an app.

          • Re: Error Out of Memory Calculation
            Dhanashri Dindore

            Hi Shraddha,

            Thanks for ur suggestion but we require different type of data all the time.

            Is there another way?

            • Re: Error Out of Memory Calculation
              Jonathan Dienst

              Well you don't give very much information, but if you have a very large database, it may simply be too big for your hardware. Some of your expressions may be very memory intensive - such as an expression spanning several large table, or link tables with many millions of rows.

               

              Possible solutions

              • Upgrade your hardware
              • Split the model into smaller parts
              • If there is a lot of history, create a historical model that aggregates the data and a 'recent' model with more detail, but shorter time window
              • Remove all the unused fields
              • Partially aggregate the data to reduce the number of rows
                • Re: Error Out of Memory Calculation
                  Dhanashri Dindore

                  Hi,

                    We are considering all points and increased RAM size and made one application with some simple one month data and directly displaying one table to show some direct values without calculations but that time also it is taking ample of time to show and some times it shows same Error: 'OUT OF CALCULATION MEMORY' .

                  What Could be the problem ?

                  Is it related to any virus?

                  or version problem(We are using 3.1 qlik sense)?

                  We have also tried same in qlik view also still it shows Error:'OUT OF OBJECT MEMORY' and system gets hang.

                  Please suggest any solution.

                • Re: Error Out of Memory Calculation
                  Dhanashri Dindore

                  Hi,

                  Please give us any solutions because it shows same Error: 'OUT OF CALCULATION MEMORY'  on 80 to 45 days restricted data.

                  Please HELP!!!

                  • Re: Error Out of Memory Calculation
                    Shubham Singh

                    Please share your Expressions of measure used in table and expanded form of your data model.

                     

                    You may use below points to optimize your application.

                    • Avoid using of single threaded functions like aggr.
                    • Try to make a star model.
                    • If qlik has to traverse very long across the model to populate the table, performance will be slow.
                    • Try to use only function in mesure instead of adding a dimension, if for each value of column1 column2 will have a single unique value.
                    • Use number to associate tables by using Autonumber funtion.