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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
carlosjesus
Partner - Contributor
Partner - Contributor

QVD Lock

Some tasks that store large QVD sometimes fail to store, because the QVD are locked, but the problem is that to unlock I have to stop and start Qlik services.

What is the reason for this and how can I avoid this problem?

Labels (1)
3 Replies
Jack_Guo
Support
Support

vinieme12
Champion III
Champion III

If you are unable to alter settings as suggested by @Jack_Guo 

An alternative workaround is to add Sleep() time to allow the QVD to complete writing the qvd to disk

 

Store Table into [lib//somepath/TableName.QVD](qvd);

Sleep (8*60)*1000;  // 8 minutes Sleep duration

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
marcus_sommer

You may considering to slice the qvd's into multiple ones maybe on a yearmonth-level or any other appropriate dimensions. Such approach will minimize the risks with larger I/O operations regardless if they are more on a technically or administrative level caused and may even speed up the overall task-times if they are performed with (more) incremental and parallelized approaches.