Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

10 Replies
ToniKautto
Employee
Employee

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

Hi Toni,

i have enabled legacy mode ( i think).

I followed all the steps mentioned in your link.

but still not run.

RTS

Anonymous
Not applicable
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Employee
Employee

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

you're right 3.0.1

Anonymous
Not applicable
Author

thanks Rob.

i can't find this information on the net.

You have inside information

Levi_Turner
Employee
Employee

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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