Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
When some user press cancel button while ODAG report start to execute, some of that reports hang in "canceling" state.
We are tried to cancel that requests though api, but receive error
Invoke-RestMethod : {"message":"'ackcancel' action is not valid for on-demand app request in state 'canceling'","statusCode":400,"msgCode":"ODAG-ERR-1067","errType":"Calling Application"}
It there any way to cancel that requests without reboot of cluster?
That does not looks like is the Qlik CLI one.
You might want to try somethin like below:
Import-Module QlikSenseCLI
Connect-QlikSense -TrustAllCertificates
$ODagRequests = Get-QSOdagrequest -Full
Foreach($ODagRequest in $ODagRequests){
IF(($ODagRequest.OdagRequestState -eq "Canceling") ){
Write-Host $ODagRequest.id + $ODagRequest.OdagRequestState
Remove-QSOdagrequest -Id $ODagRequest.id
}
}
I hope this helps!
Cheers,
Albert
Hi @BuTbka What is the Qlik Sense version?
Hello @BuTbka,
What API call are you using?
I have also seen customer using the Qlik Sense Qlik CLI tool to cancel such requests, you might want to have a look too at - How to install Qlik-CLI for Qlik Sense on Windows - Qlik Community - 1715387
Bear in mind Qlik Sense Qlik CLI for Windows is not a official support product.
Qlik CLI support and compatibility - Qlik Community - 1735424
Cheers,
Albert
Hi!
@Chetan_MN
Feb 2023 Sp 5
@Albert_Candelario
I use this one https://help.qlik.com/en-US/sense-developer/February2023/Subsystems/ODAGserviceAPI/Content/methods-p...
I also tried Qlik CLI, but no luck.
@BuTbka what command did you execute?
Do you get any request if executing the below:
$ODagRequests = Get-QSOdagrequest -Full
Cheers,
Albert
@Albert_Candelario I use that code
Connect-Qlik -ComputerName $prod -Username $admin -Certificate $certProd -TrustAllCerts
$req = Invoke-QlikGet -path "https://$($prod):9098/v1/requests?user=$user"
$req.state
$badReq = $req | where { $_.state -eq "canceling" }
Invoke-QlikPut -path "https://$($prod):9098/v1/requests/$($badReq.id)?action=ackcancel
Also there are some requests in loading state.
That does not looks like is the Qlik CLI one.
You might want to try somethin like below:
Import-Module QlikSenseCLI
Connect-QlikSense -TrustAllCertificates
$ODagRequests = Get-QSOdagrequest -Full
Foreach($ODagRequest in $ODagRequests){
IF(($ODagRequest.OdagRequestState -eq "Canceling") ){
Write-Host $ODagRequest.id + $ODagRequest.OdagRequestState
Remove-QSOdagrequest -Id $ODagRequest.id
}
}
I hope this helps!
Cheers,
Albert
@Albert_Candelario Hi!
Qlik-Cli(https://github.com/ahaydon/Qlik-Cli-Windows/) does not have function Get-QSOdagrequest
But QlikSenseCLI(https://github.com/QlikProfessionalServices/QlikSenseCLI) has it.