Forum Discussion
Community ChampionKill an In Progress Refresh
Hi rsbin
No worries, you could try this below.
You would need to have system administrator access
Terminate (kill) a specific session on a server - Azure SQL Data Dictionary Queries (dataedo.com)
Community ChampionAppreciate the response. I have tried re-publishing repeatedly in the same workspace. It just seems to hang. Publishing to a different workspace does work, but I need to keep it in this workspace.
I am very tempted to delete the file and dataset from the current workspace - but this is a last resort. If I can't republish to the same workspace, then I run into all sorts of additional problems (I am embedding this into a web page).
I will try it again...whilst writing this message...and perhaps more patience will pay off.
Again, thanks for taking the time...and if you have any other ideas....please pass them along.
Regards,
Super UserHi rsbin
Could you not kill the connection on your cloud source?
For example if it is Azure SQL you can kill the SPID?
- rsbin
We have recently lost our Database Administrator, so am not well versed in the techy stuff.
I am working with an Azure SQL table. If you can give me some further instructions on this "SPID" thing, I am pretty good at following directions.
Appreciate any further details.
- rsbin
Apologies for the delayed response. Been a hectic morning.
Thanks for the link....have connected with one of our Systems Engineers who should have admin access. Will discuss this with him tomorrow and hopefully it resolves this issue.
Will let you know how I make out.
Thanks again and best regards,
- rsbin
Good Morning. The Refresh Session finally killed itself sometime in the overnight hours. I was able to finally republish the Report, so hoping that will clear out any gremlins. Will attempt a refresh later today to see if it all works out.
I have bookmarked your link in case I need it again.
Thanks again for your help!