Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ricardo_tamagni
Not applicable

"EXECUTE statement requires Override Security"

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

1 Solution

Accepted Solutions
rwunderlich
Not applicable

Re: "EXECUTE statement requires Override Security"

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

10 Replies
Toni_Kautto
Not applicable

Re: "EXECUTE statement requires Override Security"

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.

ricardo_tamagni
Not applicable

Re: "EXECUTE statement requires Override Security"

Hi Toni,

i have enabled legacy mode ( i think).

I followed all the steps mentioned in your link.

but still not run.

RTS

ricardo_tamagni
Not applicable

Re: "EXECUTE statement requires Override Security"

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
Not applicable

Re: "EXECUTE statement requires Override Security"

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

leviturner
Not applicable

Re: "EXECUTE statement requires Override Security"

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.

ricardo_tamagni
Not applicable

Re: "EXECUTE statement requires Override Security"

you're right 3.0.1

ricardo_tamagni
Not applicable

Re: "EXECUTE statement requires Override Security"

thanks Rob.

i can't find this information on the net.

You have inside information

leviturner
Not applicable

Re: "EXECUTE statement requires Override Security"

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
Not applicable

Re: "EXECUTE statement requires Override Security"

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