Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am getting an error when I use EXECUTE command in my load script.
The following error occurred:
EXECUTE statement requires Script (Allow Database Write and Execute Statements) in User Preferences settings
I am aware that we need to add following entries in the settings.ini file which are as follows:
[Settings 7]
OverrideScriptSecurity=1
I restart the Qlik Sense Engine Service.
If any one has an answer to this problem ?
Thanks,
To use "Execute" you must also enable "Legacy" file mode by disabling StandardMode https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/LoadData/disable-st....
Note that disabling StandardMode also allows for direct (non-lib) access to the file system by script. Limiting file access to defined connections is what enables the "data governance" promise of Qlik Sense. For that reason, it's typically not recommended to disable StandardMode. You will lose that data governance feature.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Merci !
How one can do the same thing in Qlik View not in Qlik Sense?