Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSince upgrading from QlikView 11.20 to QlikView 12, reloading data from http/https URLs containing spaces fails.
This was working fine previously in version 11.
The errors shown in the log file is Error: Unknown error in xlsx file
Sometimes BadZip File errors also may occur.
Environment:
QlikView 12.20
A bug was reported for R&D to investigate this issue: QV-9634. The bug was closed as working as designed.
Changes were made to the product that affected the way we access files with the http protocol,.This resulted in many benefits, however one drawback was that we more strictly follow the specifications (which does not allow for spaces in the URL).
The solution for this issue is to replace the spaces in the URL's used in the script with %20
For instance:
[http://server/path/file to load.xml]
must be changed into
[http://server/path/file%20to%20load.xml]
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join UsSearch Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a caseExperiencing 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