Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ClearCache not clearing memory with qvs.exe

Greetings.

I have a macro that exports a number of charts to a text file.  The chart export is contained in a loop, that selects a provider, exports, then loops for the next provider, through the pre-selected list.  As it runs, QV uses more an more memory.

I added ActiveDocument.ClearCache to the end of the loop, so that it would clear memory before selecting the next provider.  when running this through Desktop, this ran wonderfully, and the whole processe never took more than 500Mb.  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.  This is causing the process to bomb on a 32 bit system.

Any ideas why ClearCache doesn't work on server?  Is there something similar I can run on QV Server?  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.

1 Reply
tmumaw
Specialist II
Specialist II

I had the same problem and I had to stop and restart the QV services to get it to clear.

Thom