Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Binary Loads in Qlik Sense, Binary load fails with error Cannot open file or General Script Error

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andre_Sostizzo
Digital Support
Digital Support

Binary Loads in Qlik Sense, Binary load fails with error Cannot open file or General Script Error

Last Update:

May 26, 2021 2:44:16 AM

Updated By:

Sonja_Bauernfeind

Created date:

Dec 3, 2015 5:54:36 PM

A Binary Load on a Qlik Sense App located in the Qlik Sense App share fails. 

The following error is logged in the Script Log: 

0002 Binary lib://Apps/8cd41016-f330-4ca0-9a6a-c46cbc31304f
Error: Cannot open file
General Script Error

 

Environment:

Qlik Sense Enterprise on Windows 
QlikView 

 

There are four main requirements for a successful binary load:

  1. Binary load must be the first statement in the load script
  2. Only one binary load statement per script
  3. The source QVW or QVF file must be available during the entire binary load*
  4. The reloading user must have access to read the source QVW or QVF file*


*Binary Loads from live Qlik Sense Apps are not supported in Qlik Sense Enterprise on Windows.

Example: BINARY [SenseAppID];  (for example BINARY 2d405d18-ddd3-5353-5128-adce12e482bd;)

QVF files in the Server Apps folder are read/written by Engine service when:

  1. When users are doing modifications on those apps, so a file lock will be always possible to happen on those files at any moment.
  2. In a multi-node environment, apps are constantly being synchronized(called 'binary sync) onto all nodes, which means any changes on such app from any node will have the possibility to lock the app.
  3. And some 'binary sync does not happen instantly. The sync actions will be delayed for several hours when the system load is high. So the file lock is very unpredictable.

During these operations, those files may be locked and causing reload task failure.

 

Resolution

 

For Qlik Sense:

Do binary load on static QVF/QVW files if necessary, or load QVD files generated by other QVD generators.

 

What to generally consider:

  • Binary load is not the first command line in the script
    It is a requirement that binary load is the first executable command in the load script. See below online help references:
    Qlik Sense: Binary Load
    QlikView: Binary Load 
     
  • The source application is Section Access protected
    The reloading user must be allowed to access and open the file being targeted in the binary load. This means that the QlikView or Qlik Sense service user must be included in the Section Access table. 
     
  • Source QVW is updated by another task during binary load
    No other task can update the source QlikView (QVW) or Qlik Sense (QVF) application file during the binary load. 
     
  • Source QVW is locked by 3rd party process, like anti-virus or backup
    No other software can lock the source QlikView (QVW) or Qlik Sense (QVF) application file during the binary load. 
     
  • Source QVW is located on a file share, and file share access is interrupted by network problem
    Any file share hosting the source QlikView (QVW) or Qlik Sense (QVF) application file must be available during the binary load.
Labels (1)
Contributors
Version history
Last update:
‎2021-05-26 02:44 AM
Updated by: