Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi @carlosjesus ,
have you checked this solution?
Reload from QVDs fails with: Failed to open file i... - Qlik Community - 1746825
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
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.