Forum Discussion

jesus21282's avatar
jesus21282
Frequent Visitor
4 years ago

REST API Cancel Refresh ViaApi - Operation failed - Canceling refresh operation is disabled

Hi folks!- I have a dataset refresh stuck for 4+ hours so far, where it usually takes ~10 mins to refresh.   I would like to cancel this refresh, but there is no option in the dataset options to ca...
General Comment
Need Help
m-colbert's avatar
m-colbert
Resolver III
4 years ago

Is this dataset in your My Workspace or a shared workspace. If in a shared workspace, you need to use the Cancel a Dataset in a Group.

Other possible ways to kill are to kill the session/thread  on your backend, or restart/take offline the gateway its going through. 

jesus21282's avatar
jesus21282
Frequent Visitor
4 years ago

Good point. The dataset is in a shared workspace, and I used Cancel Refresh in Group instead ( I will edit this in my first message ), but it failed with the error shown.

 

I also managed to finally fix the issue, by stopping the Flow calls to refresh the dataset. This means, I turned off the Power Automate flow triggering the dataset refresh temporarily, and then,I was now able to upload my dataset from local again, effectively overriding the version online. Finally, I turned on my flow again and it's all running well back again.

 

I further dig into your comment, and:

- I am not sure how to tell session/thread in my backend;

- Restarting the gateway is not easy for us, because we use a Gateway cluster of 5 On-Premises data gateways, and we don't know which one server in particular is taking this load. Any thoughts on this?