QlikView: Failing reloads, macros, and BNF script reload mode

[Sonja_Bauernfeind]

Reloads and macros may fail after an upgrade from QlikView 11.20 to later versions.

A complete list of symptoms include:

• Expression editor may throw an error
• Chart may show empty
• Chart may show "Incomplete visualization"
• Chart may show "Invalid dimension"
• And any other odd behavior that would mimic a change in the script (expression, set analysis, etc)
• Macros cannot be reloaded

Environment:

QlikView 
 

A new script reload mode has been introduced: BNF. This requires scripts to be modified to match the BACKUS-NAUR FORMALISM.

BNF mode can be temporarily disabled in QlikView versions prior to November 2018 (12.30). Any later release require scripts to be correctly rewritten.

Only applicable prior to 12.30:

All the flags mentioned below are disabled in 12.30 and later.

Disabling BNF reload mode on the local QlikView client:

Update the QV.exe  Settings.ini file by adding the line EnableBnfReload=0 under the [Settings 7] tag for the default reload setting "EnableBnfReload".
By default, Settings.ini can be found in C:\%USER%\AppData\Roaming\QlikTech\QlikView?
 

Disabling BNF reload mode for the entire server :

Update the QVB.exe  Settings.ini by adding the line EnableBnfReload=0 under the [Settings 7] tag for the default reload setting "EnableBnfReload". 
By default, the Settings.ini can be found in C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch. For more information please review Where to find the QlikView QVB settings file

Modify it to read:

[Settings 7]
EnableBnfReload=0

Disabling BNF reload mode for individual apps:

Add the ///$bnf off tag at the top of the script (it must be within the first 50 characters of the script). Reload the script.

It is a good idea to use the ///$bnf off tag as a troubleshooting step.  See if toggling this setting in the load script will cause a change in the suspect behavior.