"EXECUTE statement requires Override Security"

[Anonymous]

Hi,

i'm in Qliksense Server 3.1 and i try run a small aplication where i pretend run a cmd file to move files from one directory to another and i get "EXECUTE statement requires Override Security" error.

what i have done :

1.change in QMC Engine Standard mode option to No (uncheked).
2.create Settings.ini file in "C:\ProgramData\Qlik\Sense\Engine"  (this file does not exist, I had to create it. in this directory?)
with this lines :
[Settings 7]
OverrideScriptSecurity=1

AllowExecuteCommand=1
 
3.Restart all qliksense services

4.run load script .... i got error
what is missing me? the settings file is at that location?

thanks in advance
RT

[ToniKautto]

It is really not recommended to utilize EXECUTE as it will be a security risk in your environment. For this reason it is not available in standard mode, and you would have to enable legacy mode. See Execute ‒ Qlik Sense‌ for more details.

[Anonymous]

Hi Toni,

i have enabled legacy mode ( i think).

I followed all the steps mentioned in your link.

but still not run.

RTS

[Anonymous]

at script log file i have :

"...

2016-09-01 11:46:47      UseMemoryFillPattern          1

2016-09-01 11:46:47      ScriptMode                    Legacy (gives greater system access) (aka qv11 mode)

2016-09-01 11:46:47      ReloadCodebase                Classic

---

".

so is in Legacy Mode.

i think the problem is in Settings.ini file. how to know if it is being loaded on startup services ?

RTS

[rwunderlich · Accepted solution]

Your setup looks correct. I see this Bug Fix listed in the Qlik Sense 3.0.2 release notes:

----------

Legacy mode in Sense 3.0 does not work

Jira issue ID: QLIK-61452

Description: Scripts using the call EXECUTE did in some cases not work in Qlik Sense 3.0.

------------

Perhaps that is your problem?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Levi_Turner]

Are you sure you are in 3.1 rather than 3.0.1? As Rob pointed out, in 3.0.1 there was a bug where the EXECUTE command did not work as expected.

[Anonymous]

you're right 3.0.1

[Anonymous]

thanks Rob.

i can't find this information on the net.

You have inside information

[Levi_Turner]

Here are the release notes for 3.0.2 (https://da3hntz84uekx.cloudfront.net/QlikSense/3.0.2/74/QlikSense3_0_2ReleaseNotes.pdf) released yesterday.

[rwunderlich]

Hi Ricardo,

If you have access to the Qlik Download site, the release notes are there along side the install files.  Links are also provided in the Qlik Support Updates release announcements.

Qlik Sense 3.0 Service Release 2 is now available

-Rob