topic Re: Qlik sense server - Powershell Execute in Legacy mode is not working. in App Development

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

varmekontrol — Sat, 16 Nov 2024 20:38:42 GMT

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.

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

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

varmekontrol — Wed, 19 Jun 2019 06:53:22 GMT

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?

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

Nicole-Smith — Thu, 12 Sep 2019 20:09:40 GMT

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

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

gballester — Mon, 20 Jul 2020 23:34:20 GMT

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?

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

Liliqlik — Fri, 16 Oct 2020 13:57:42 GMT

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

Thanks

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

gballester — Tue, 27 Oct 2020 18:50:18 GMT

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/ScriptRegularStatements/Execute.htm