EXECUTE Command Error

[Anonymous]

Hi All,

I am getting the following error when I use EXECUTE command in my load script.

The following error occurred:

EXECUTE statement requires Override Security

I am aware that we need to add following entries in the settings.ini file which are as follows:

[Settings 7]

OverrideScriptSecurity=1

And then I need to restart the Engine and Service Dispatcher services.

But for some unknown reason, even after following all the above steps, I still get the same error.

It would really great if any one has an answer to this problem.

Thanks,

[swuehl · Accepted solution]

I think you need to modify the .ini setting for

AllowExecuteCommand=1

Authorizing the Script EXECUTE Statement | Qlikview Cookbook

[Anonymous]

Thanks Swuehl. It works great.

[saravana325da]

Tested on  Qlik sense Desktop Apr 2020

1.--------------
Open setting.ini file in notepad++ from the below location:C:\Users\hp\Documents\Qlik\Sense\Settings.ini
Add below 3 line,save.
[Settings 7]
OverrideScriptSecurity=1
StandardReload=0
2.--------
open cmd.exe , run the .py file and check the output is generating and your python code is working OK.
python "C:\Users\hp\Desktop\qlik execute command.py"
3.-----------
In Qlik sense Data load editor : add the .py file location as below format.
Execute python "C:\Users\hp\Desktop\qlik execute command.py";
save the qvf file
close and restart the Qlik sense App
open Data load editor ,Run load Data button on Right top corner.
4----------
Now , the Qlik sense execute the python code and generate the Output ,whenever the load script running. (same as in cmd prompt)
5---------
if you made any changes/modify in python code,saved. then next time when open Qlik sense Qvf file and press load data , the visualization will auto update based on the python file output.