Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
varmekontrol
Creator
Creator

Qlik sense server - Powershell Execute in Legacy mode is not working.

Not sure if this is the right board for this question, but that is another question 🙂

 

I am trying to execute some batch files in my load script on my Qlik sense server.
Feel like I have read every post available about this subject,. but can´t seem to get it to work. 

I am trying to 

 

Execute cmd /C powershell -command  D:\Routines\Copy_by_header_time.ps1;

 

And getting 

 

The following error occurred:
EXECUTE statement requires Script (Allow Database Write and Execute Statements) in User Preferences settings

 

 

All settings are set to what the Qlik help and community suggested. image.png 

My ps1 file is stored in the "Table files root directory" 

 

 

Labels (2)
1 Solution

Accepted Solutions
gballester
Creator
Creator

5 Replies
varmekontrol
Creator
Creator
Author

An update to this issue is that I have tried to add the setting.ini file to the folder C:\Program Files\Qlik\Sense\Engine (is was not present like in Qlik sense desktop) 

The settings.ini file contains : 

[Settings 7]
OverrideScriptSecurity=1

AllowExecuteCommand=1

 

I have also restarted all services with no result
Tried restarting everything as each attempt, without any result. 

I have a hard time finding anything about Qlik sense server and Powershell, so maybe Powershell does not work with the Qlik sense server April 2019 edition?  

Nicole-Smith

@varmekontrol did you ever resolve this?  I'm having the same issue.

gballester
Creator
Creator

Hi, I am having the same problem to go from standard to legacy mode on a sense server. Were you able to solve that issue?

Liliqlik
Contributor II
Contributor II

Hello Nicole-Smith, I have the same problem. Have you resolved this problem ?

Thanks

gballester
Creator
Creator

In the following link it is explained how to enable legacy mode in a Sense Server

https://help.qlik.com/en-US/sense/June2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...