Task Trigger Error

Tim_Borg — Fri, 24 Mar 2023 07:04:28 GMT

We are trying to reload a qlik sense task by running an executable file using QlikSenseTask.exe (found on github):

https://github.com/marcusspitzmiller/QlikSenseTask

When we run the task, we receive the error: EXECUTE statement not available in this script mode.

We updated the settings.ini by adding OverrideScriptSecurity=1 and restarted the server, but are still receiving the same error. https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/Execute.htm

We also tried to run the same .exe from Windows Command and received error "System.Exception: Method Not Allowed: Http code: 405
at QlikSenseJSONObjects.QlikSenseJSONHelper.StartTaskByName(String taskname, Boolean synchronous)
at QlikSenseTask.Program.Main(String[] args)"

We have also since disabled Standard mode and received the same error when running from Windows Command. When running from QMC, the executable section is skipped.

Could you kindly advise on how we could solve this issue please? (We are using Qlik Sense version November 2021, and it is not Enterprise SaaS).

Tim

Re: Task Trigger Error

Marc — Tue, 02 May 2023 22:21:59 GMT

If you have QlikSenseCLI

https://github.com/QlikProfessionalServices/QlikSenseCLI

you could try running the following script. `.\QlikSense-StartTask.ps1 -TaskName "Name of Task"`

https://gist.github.com/Nillth/0f13c48ae2b4d556ba995a5c44149f2b

$TaskName = "Name of Task" Connect-QlikSense -TrustAllCertificates #-Hostname "ifRequired" -VirtualProxy "ifRequired" $Tasks = Get-QSReloadtask -Filter "Name eq '$($TaskName)'" foreach($Task in $Tasks){ Add-QSTask -Start -Id $Task.Id }

topic Re: Task Trigger Error in Integration, Extension & APIs

Task Trigger Error

Re: Task Trigger Error