Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
}