Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Issue in QlikView reload using FABS() and concatenating fields related to multi-threading
Article Number: 000085135 | Last Modified: 2019/10/03Description
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
LOAD
x & '|' & y as KEY,
x,
y,
fabs(keepchar(z,'1234567890')) as z
FROM tmp.xlsx
(ooxml, embedded labels, table is tmp.xls);
Environment:
Example script that causes issue to occur:
NoConcatenate
LOAD
x & '|' & y as KEY,
x,
y,
fabs(keepchar(z,'1234567890')) as z
FROM tmp.xlsx
(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.
Cause
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:
Product Defect ID:
- QVII-1752
Resolution
! 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:
The EnableParallelReload=0 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]
EnableParallelReload=0
.....
Workaround:
The EnableParallelReload=0 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]
EnableParallelReload=0
.....
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us