Reload from QVDs fails with: Failed to open file in write mode for file: \\SRVR\folder\XXX.qvd
Reload from QVDs failing in Qlik Sense April 2020 or later and QlikView 12.50 with System error: Failed to open file in write mode for file: \\servername\foldername\XXX.qvd
Other symptoms may include:
Errors for sharingViolation in the logs
QVDs being locked requiring manual unlocking of files via the Open Files menu.
Qlik Sense April 2020 or later (see fix versions)
QlikView 12.50 to 12.50 SR2 (see fix versions)
The behaviour was adjusted in:
QlikView 12.50 SR3
Qlik Sense April 2020 Patch 8
Qlik Sense June 2020 Patch 7
Qlik Sense September 2020 Patch 2
Qlik Sense November 2020 IR
Implement the following ini setting EnableQvdAsyncWrite=0.
Steps for Qlik Sense:
Stop the Qlik Sense Engine and Qlik Sense Service Dispatcher services on all nodes with engines.
For each of the nodes: open Notepad as Administrator
Open the Settings.ini file (by default located in C:\ProgramData\Qlik\Sense\Engine\Settings.ini)
Please make sure Enter/Return are pressed to create a new blank line after the last setting.
Save the file
After these changes have been made on all nodes, start the Qlik Sense Engine and Qlik Sense Service Dispatcher services on each node.
Steps for QlikView:
Reloads in QlikView are carried out by the QVB.exe. So we need to change the settings.ini for the QVBs, rather than the QlikView Server.
Stop all currently running reloads (qvb.exe).
Stop the QlikView Distribution Services on all nodes
For each node running a Distribution Service, open Notepad as an Administrator
Open the QVS Settings.ini file (by default, located in C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch)
Modify the Settings.ini using this schema:
Ensure that the entry is entered under [Settings 7] section and not under the [Authentication] section (if entered under [Authentication] section, the entry will not be read by the QVS)
Save the file
These changes have been made on all nodes running reloads.
Start the Distribution Services
There is an optimization in QVD writing in the April 2020 release and later of Qlik Sense Enterprise for Windows and in QlikView 12.50, which gives a noticeable performance boost but on some systems can lead to hung reload jobs. The reason for hung reloads is not immediately related to the optimization itself, but rather to the new write speed.