Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Tim_Borg
Contributor
Contributor

Task Trigger Error

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/ScriptReg...

 

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

Labels (2)
1 Reply
Marc
Employee
Employee

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
}