QVD Lock

[carlosjesus]

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?

[Jack_Guo]

Hi @carlosjesus ,

have you checked this solution?

Reload from QVDs fails with: Failed to open file i... - Qlik Community - 1746825

[vinieme12]

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

[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.