Synapse stuck in provisioning state

Question

Synapse stuck in provisioning state

Rasmus Kromann 20

I deployed a Synapse Workspace a long time ago. It never finished deploying, and now I want to get rid of it, but I am unable to delete it. The deletion fails with message: "Workspace is in non-terminal state Provisioning and cannot be updated". The details are as follows:

<< Removed Personally Identifiable information(PII) >>

Please delete the resource group

Smaran Thoomu 21,320 Reputation points Microsoft External Staff

2025-03-06T15:01:44.0466667+00:00

Hi @Rasmus Kromann
Thank you for your question and for using the MS Q&A platform.

I understand that you are encountering an error while trying to create an Azure Synapse Workspace, specifically the error code "WorkspaceInNonTerminalState" with the message "Workspace is in non-terminal state Failed and cannot be updated."

To address this issue, please try deregistering Microsoft SQL and then registering it again before attempting to create the Synapse Workspace. If this does not resolve the issue, please inform us, and we will investigate further.

Thank you!
Rasmus Kromann 20 Reputation points

2025-03-06T15:14:04.4966667+00:00

Hi @Smaran Thoomu

Thanks for your quick answer.

To be honest with you, I have very little knowledge about Synapse workspaces. When I said I deployed it, it is actually not correct. Someone else deployed it (or tried to) and then left the company.

So really, what I was hoping for was that someone from Microsoft could just log in and wipe the resource group. That is why I entered all the connection details to begin with.

Can you do that or arrange that someone does?

Best regards

Rasmus
Smaran Thoomu 21,320 Reputation points Microsoft External Staff

2025-03-06T17:13:29.6666667+00:00

@Rasmus Kromann Could you please refer to this similar thread issue and try the steps on your end? https://learn.microsoft.com/en-us/answers/questions/1465756/i-cannot-delete-azure-synapse-workspace?source=docs
Rasmus Kromann 20 Reputation points

2025-03-06T20:58:39.2133333+00:00

I downloaded the bicep file and found out that there is an associated resource group called synapseworkspace-managedrg-1a51d661-9eb3-4a08-9017-8148a16c34b9. This resource group has a deny assignment which apparently prevents me from deleting the group. I cannot change the deny assignment and thus the trail ends there.

Accepted answer

0 additional answers

Your answer

Smaran Thoomu 21,320 Reputation points Microsoft External Staff

2025-03-06T15:01:44.0466667+00:00

Hi @Rasmus Kromann
Thank you for your question and for using the MS Q&A platform.

I understand that you are encountering an error while trying to create an Azure Synapse Workspace, specifically the error code "WorkspaceInNonTerminalState" with the message "Workspace is in non-terminal state Failed and cannot be updated."

To address this issue, please try deregistering Microsoft SQL and then registering it again before attempting to create the Synapse Workspace. If this does not resolve the issue, please inform us, and we will investigate further.

Thank you!
Rasmus Kromann 20 Reputation points

2025-03-06T15:14:04.4966667+00:00

Hi @Smaran Thoomu

Thanks for your quick answer.

To be honest with you, I have very little knowledge about Synapse workspaces. When I said I deployed it, it is actually not correct. Someone else deployed it (or tried to) and then left the company.

So really, what I was hoping for was that someone from Microsoft could just log in and wipe the resource group. That is why I entered all the connection details to begin with.

Can you do that or arrange that someone does?

Best regards

Rasmus
Smaran Thoomu 21,320 Reputation points Microsoft External Staff

2025-03-06T17:13:29.6666667+00:00

@Rasmus Kromann Could you please refer to this similar thread issue and try the steps on your end? https://learn.microsoft.com/en-us/answers/questions/1465756/i-cannot-delete-azure-synapse-workspace?source=docs
Rasmus Kromann 20 Reputation points

2025-03-06T20:58:39.2133333+00:00

I downloaded the bicep file and found out that there is an associated resource group called synapseworkspace-managedrg-1a51d661-9eb3-4a08-9017-8148a16c34b9. This resource group has a deny assignment which apparently prevents me from deleting the group. I cannot change the deny assignment and thus the trail ends there.

Answer 1

Smaran Thoomu 21,320 Microsoft External Staff

Hi @Rasmus Kromann

The Synapse workspace was stuck in the provisioning state, but we have now marked its status as 'failed'. The associated managed resource group will be deleted automatically once the main workspace (dataon-next-step-fodemo-synw) is deleted.

Could you please retry the deletion operation and let us know if you face any further issues?

Rasmus Kromann 20 Reputation points

2025-03-10T07:40:04.31+00:00

Yes, it works. The resource group is deleted now. Thank you.
Smaran Thoomu 21,320 Reputation points Microsoft External Staff

2025-03-10T16:25:34.9233333+00:00

Hi Rasmus Kromann,

Thank you for confirming that the issue is resolved, and the resource group has been deleted successfully. Glad we could assist!

If you found this response helpful, please consider Accept answer so that it may help others facing a similar issue. Let us know if you need any further assistance.

Share via

Synapse stuck in provisioning state

0 additional answers

Your answer