Qlik Sense ODAG hangs in canceling state

[BuTbka]

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? 

[Chetan_MN]

Hi @BuTbka What is the Qlik Sense version?

[Albert_Candelario]

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

[BuTbka]

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.

[Albert_Candelario]

@BuTbka what command did you execute?

Do you get any request if executing the below:

$ODagRequests = Get-QSOdagrequest -Full

Cheers,

Albert

[BuTbka]

@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. 

[Albert_Candelario · Accepted solution]

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

[BuTbka]

@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.