topic Re: execute cmd.exe in App Development

execute cmd.exe

Liliqlik — Fri, 16 Oct 2020 13:14:31 GMT

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,

Re: execute cmd.exe

rwunderlich — Sun, 18 Oct 2020 22:45:36 GMT

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-standard-mode.htm.

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

Re: execute cmd.exe

Liliqlik — Wed, 21 Oct 2020 14:25:57 GMT

Merci !

Re: execute cmd.exe

draghici1109 — Fri, 25 Feb 2022 10:44:09 GMT

How one can do the same thing in Qlik View not in Qlik Sense?