The issue relates to the use of the FABS()
function in the load script along with concatenating the fields where FABS()
function is being used and a multi-core machine. The more CPU cores, the more likely the issue may occur.
Example script that causes issue to occur:NoConcatenate
x & '|' & y as KEY,
fabs(keepchar(z,'1234567890')) as z
(ooxml, embedded labels, table is tmp.xls);Environment:
- This appears to only impact 11.20 SR16 and later releases in the 11.20 version track only.
There is an apparent multi-threading issue with the FABS()
function it appears. A issue has been submitted to engineering for further review.Product Defect ID:
! This is currently being investigated as a possible defect. Information provided here is given as is at the time of documenting. For up to date information contact support at support.qlik.com with the ID
QVII-1752 for reference. Workaround:
setting can be used in the QlikView Desktop or Publisher/Reload Engine Settings.ini files, the location of both is as follows:
QlikView Desktop: C:\Users\bbs\AppData\Roaming\QlikTech\QlikView
Publisher/Reload Engine: C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch
You will add the above setting such that it appears as follows:[Settings 7]