How to drop document from memory manually?

[#1]

Hi All,

Could anyone suggest how to drop qlikview document from server memory using batch script? I have the requirement to drop existing document from server memory manually before  publishing the refreshed document.

[whiteline]

Hi.

What is the reason for that ?

The server should do it automatically.

[hic]

I agree with whiteline. If you check "Allow Only One Copy of Document in Memory" in the QMC, then the server will handle this automatically.

HIC

[mikkeltaylor]

If the data is refreshed from the database why would you want to keep that data in memory? What would qlikview do with outdated data?

[#5]

My server is crashing because of insufficient memory when reloading/publishing refreshed document. If I drop  document from memory before publish the new refreshed version that will free up lot of memory so that I won’t crash the server due to lack of memory.

Let’s assume my server has 100 GB RAM, and my qvw file size is 10GB compressed. Before reloading document assume I have only 20GB available in server as other documents are already preloaded in memory. So there is no sufficient memory to reload and publish this updated document.

[#6]

That option is already checked for my server. Unless publisher process is at final step it does not drop the existing one/old snapshot. But i am getting server crash while refreshing/reloading document itself due to insufficiant memory. That is the reason , I want to drop the preloaded document before I start reload.

[whiteline]

Ok.

How did you noticed that the insufficient memory caused the problem ?

You can read the document about how the QV cache works. The most reason for the server to keep the cache and the old document in memory is that someone is using it.

You can try to cheat and temporarily replace the document with the one that has empty data set.

Then you can start the real reload process. Of course it can lead to some inconsistencies.

Usually the server flush the unnecessary cache and frees the memory when some other process needs more memory.

[whiteline]

You can search for the document that Henric Cronström has published about how the QV cache works.

[#9]

My server team notifying that server was keep on hanging due to over usage of CPU and Memory by qlikview software. My refresh of tasks runs midnight of the day so no user is going tobe online during that time.Also i just want to drop document from memory, not from accesspoint portal folder. If incase anybody logs into server at midnight still it should be able to load that document into memory anytime. But nobody logs into the server that time.

Thank you. That is very good article from Henric. Still that doesnot resolve my issue

[sudeepkm]

Have you tried keeping a less duration (like 5 min) Document timeout.

In that case if QlikView Server will drop the document from memory when no one is using it for more than 5 min.