Use of the FieldIndex script function in SQL Select Where clause may result in failed load.
Article Number: 000041171 | Last Modified: 2018/11/21
There may be a script failure in the 12.10 track if the SQL Select load script is using a Where clause and part of the Where statement also includes the use of the Qlik FieldIndex script function as well.
This is a known issue identified as QV-11186 and has been fixed in the 12.20 track. There is a patch available for the 12.10 SR8 version.
The workaround is to use the EnableParallelReload setting set to a value of 0 in the Settings.ini of the Desktop Client, or of the QVB/QlikViewBatch process.
The path for Desktop Client to Settings.ini is:
The path for QlikViewBatch/QVB process Setting.ini is:
If the setting is not present, add it within the [Settings 7] section as follows: