Forum Discussion
Data Mart Refresh Cannot be Cancelled
We have a data mart that has been working fine for weeks. It started a refresh at 8:30am and is still running over 4 hours later. Previously it took a couple of minutes. Digging through all the settings, there is no way to cancel a refresh. We are connecting from a data mart directly to a SQL Serverless Pool in Synapse. When we try to do anything with this dataset it says there is a table lock.
Status code: 400
Time: Mon Apr 10 2023 12:22:28 GMT-0500 (Central Daylight Time)
Service version: 13.0.20442.57
Client version: 2304.1.13131-train
Cluster URI: https://wabi-us-east2-b-primary-redirect.analysis.windows.net/
3 Replies
I looked in there and did not see a place to cancel an external query. I am newer to Synapse in general though so there are still areas that I am not familiar with. I just did some Googling and a quick search in Bing and did not find a way to do this. Happen to have a link showing how to cancel a query in a SQL Serverless Pool?
I have this problem too, started yesterday. I have logged a Service Request with Micorsoft.
