4 Replies Latest reply: Sep 18, 2018 12:21 PM by Gerardo García RSS

    IncreaseMemoryQuota : what does it mean ?

    Frédéric Villemin

      Hello,

      I think I've got an Issue with my Qlikview Server 12.1 and its documents.

      On a server with 64GB, with 3 documents of 500MB, I begin having Memory warnings while sometime that only use 20GB of Memory.

      I'm trying to find what causes this peak in memory and I have discovered messages in the Events logs:

       

      20171005T113143.000+0200 20171009T105227.000+0200 2 500 Warning WorkingSet: Virtual Memory is growing beyond parameters - 44.683(38.400) GB

      20171005T113143.000+0200 20171009T105232.000+0200 4 700 Information IncreaseMemoryQuota: Request PivotTableBox::GetTableLayout going MT_HIGH

      20171005T113143.000+0200 20171009T105232.000+0200 2 500 Warning WorkingSet: Virtual Memory is growing beyond parameters - 44.806(38.400) GB

       

      IncreaseMemoryQuota: Request PivotTableBox::GetTableLayout going MT_HIGH

      What does this mean ?  how can I know which Pivot Table causes that issue ?


      Thanks

        • Re: IncreaseMemoryQuota : what does it mean ?
          Liz Ward

          I just have seen this same message and I too would like to know what it means.

          • Re: IncreaseMemoryQuota : what does it mean ?
            Gerardo García

            In QV 12, there may be times when a dashboard is opened which has , for example, a big demand of memory when expanding huge pivot tables, or exporting a large amount of data to Excel.

             

            When reviewing the Event logs, search for MT_High or IncreaseMemoryQuota and you can see entries relating to pivot table box, straight table, etc.

             

            IncreaseMemoryQuota: Request PivotTableBox::GetTableLayout going MT_HIGH

            IncreaseMemoryQuota: RequestStraightTable::GetTableLayout going MT_HIGH

             

            The entries are related to Memory Throttling (MT_High).  QlikView server wants to  temporarily increase the memory to handle the request  e.g. exporting a large amount of data to excel, or a large demand of memory when expanding huge pivot tables. The memory is intended to be released once the request is complete.

            In versions 12.0 - 12.20 SR2 , the memory may not get released.

             

            Resolution:  Upgrade to 12.20 SR 3 or later

             

            Note -The dashboards responsible for the memory consumption need to be reviewed.  You can help pinpoint what dashboards are responsible by reviewing the audit log and searching for customer actions occuring just prior to the MT_HIGH and Internal Inconsistency errors in the event log.  Remember, Increase Memory Quota are information entries.  You will not see those entries when searching for Warnings or Errors.


            Hope that this will be helpful


            Regards