Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Apr 18, 2023 10:30:58 AM
Nov 12, 2020 8:31:02 AM
QlikView tasks / reloads are stuck for an infinite time. Manual intervention kills them and kicks them off again to retry. The behavior is not consistent and stalling happens randomly.
The tasks stall at a STORE command while writing to QVDs.
The failing tasks include reloads that write to QVDs and the issue is normally an indication of insufficient disk I/O performance. Qlik is investigating improvements to the default save process (internal ID ID QV-20266).
In 12.50 we introduced Asynchronous Write as a feature to speed up the storing of .qvds. However, we have noticed that in disks that perform less well, the mentioned issue can happen.
Upgrade to the latest version of QlikView.
A setting can be introduced which makes the QVB save writing process less aggressive. This has been successfully tested, but does come with a performance impact. The cost of applying the setting are slower reloads as the file writing speed drops to save disk functions.
To implement:
Note: As a workaround, in QlikView 12.50 SR3 the default has been set to 0, disabling the Asynchronous Write feature. This will result in slower, but more stable, performance.
Asynchronous Write can been enabled back by setting the value to 1, if the performance of the disk has been tested and verified to be able to handle the higher load.
QlikView 12.50 SR4 will include some improvements that should make the feature more reliable even of less-performing hardware.
We have seen a couple of places where the above fix doesn’t seem to help.
If you are experiencing this, please check the following
Is there a file called Initial.ini in the below folder,
C:\Users\<service account>\AppData\Roaming\QlikTech\QlikViewBatch\initial.ini
If there are, you need to perform the steps below. This file should have been cleaned up by the installer but under some special circumstances this doesn’t happen
Stop the distribution server service.
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the ID QV-20266 for reference.
QlikView 12.50 (April 2020) IR, SR1 and SR2
Note the instructions direct rename of initial.ini. Does this mean to rename to change to initial.old or something to that effect?
@wendywallace Correct! Anything that will invalidate it from being read by the product. I will clarify this in the article.