topic ClearCache not clearing memory with qvs.exe in QlikView https://community.qlik.com/t5/QlikView/ClearCache-not-clearing-memory-with-qvs-exe/m-p/368400#M493609 <HTML><HEAD></HEAD><BODY><P>Greetings.</P><P></P><P>I have a macro that exports a number of charts to a text file.&nbsp; The chart export is contained in a loop, that selects a provider, exports, then loops for the next provider, through the pre-selected list.&nbsp; As it runs, QV uses more an more memory.</P><P></P><P>I added ActiveDocument.ClearCache to the end of the loop, so that it would clear memory before selecting the next provider.&nbsp; when running this through Desktop, this ran wonderfully, and the whole processe never took more than 500Mb.&nbsp; However, I run the same thing on QV Server, and the memory never gets cleared - the whole process takes up a maximum of 5.9Gb.&nbsp; This is causing the process to bomb on a 32 bit system.</P><P></P><P>Any ideas why ClearCache doesn't work on server?&nbsp; Is there something similar I can run on QV Server?&nbsp; Once I export the table contents, I have no reason to hang onto it in memory - I'd like it to just drop and go to the next.</P></BODY></HTML> Thu, 24 May 2012 17:20:06 GMT 2012-05-24T17:20:06Z ClearCache not clearing memory with qvs.exe https://community.qlik.com/t5/QlikView/ClearCache-not-clearing-memory-with-qvs-exe/m-p/368400#M493609 <HTML><HEAD></HEAD><BODY><P>Greetings.</P><P></P><P>I have a macro that exports a number of charts to a text file.&nbsp; The chart export is contained in a loop, that selects a provider, exports, then loops for the next provider, through the pre-selected list.&nbsp; As it runs, QV uses more an more memory.</P><P></P><P>I added ActiveDocument.ClearCache to the end of the loop, so that it would clear memory before selecting the next provider.&nbsp; when running this through Desktop, this ran wonderfully, and the whole processe never took more than 500Mb.&nbsp; However, I run the same thing on QV Server, and the memory never gets cleared - the whole process takes up a maximum of 5.9Gb.&nbsp; This is causing the process to bomb on a 32 bit system.</P><P></P><P>Any ideas why ClearCache doesn't work on server?&nbsp; Is there something similar I can run on QV Server?&nbsp; Once I export the table contents, I have no reason to hang onto it in memory - I'd like it to just drop and go to the next.</P></BODY></HTML> Thu, 24 May 2012 17:20:06 GMT https://community.qlik.com/t5/QlikView/ClearCache-not-clearing-memory-with-qvs-exe/m-p/368400#M493609 2012-05-24T17:20:06Z ClearCache not clearing memory with qvs.exe https://community.qlik.com/t5/QlikView/ClearCache-not-clearing-memory-with-qvs-exe/m-p/368401#M493610 <HTML><HEAD></HEAD><BODY><P> I had the same problem and I had to stop and restart the QV services to get it to clear.</P><P>Thom</P></BODY></HTML> Thu, 24 May 2012 18:12:46 GMT https://community.qlik.com/t5/QlikView/ClearCache-not-clearing-memory-with-qvs-exe/m-p/368401#M493610 tmumaw 2012-05-24T18:12:46Z