Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Liliqlik
Contributor II
Contributor II

execute cmd.exe

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,

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Liliqlik
Contributor II
Contributor II
Author

Merci ! 

draghici1109
Creator
Creator

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

Alexandru Draghici
BICC at Komm.ONE