Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to drop document from memory manually?

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.

13 Replies
whiteline
Honored Contributor II

Re: How to drop document from memory manually?

Hi.

What is the reason for that ?

The server should do it automatically.

Employee
Employee

Re: How to drop document from memory manually?

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
Contributor II

Re: How to drop document from memory manually?

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?

Not applicable

Re: How to drop document from memory manually?

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.

Not applicable

Re: How to drop document from memory manually?

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
Honored Contributor II

Re: How to drop document from memory manually?

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
Honored Contributor II

Re: How to drop document from memory manually?

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

Not applicable

Re: How to drop document from memory manually?

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
Valued Contributor III

Re: How to drop document from memory manually?

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.

Community Browser