Issue with Corrupted Azure Synapse Workspace During Creation

Question

An issue has arisen with an Azure Synapse Analytics workspace during its creation process. Due to an error or misconfiguration during setup, the workspace became corrupted. As a result, the workspace is in a non-functional state and cannot be deleted or modified.

Details:

1. Workspace Creation: While creating the Synapse workspace, an error occurred due to a misstep in the configuration or permissions. This caused the workspace to enter a corrupted or partially deployed state.
2. Current State: The workspace is now inaccessible, and any attempt to:
   • Delete the workspace.
     • Modify the workspace settings.
       • Redeploy or recreate the workspace. results in failure due to its corrupted state.
       1. Error Messages: Actions to delete or adjust the workspace result in specific error messages or no response, depending on the operation attempted. These might include:
          • "Internal server error."
          1. Desired Resolution:

• Complete removal of the corrupted Synapse workspace and its dependencies from the resource group.

Answer 1

Hi @Bram Teunis

Thank you for reaching out to the Microsoft Q&A platform.

I understand that you're facing issues with a corrupted Azure Synapse workspace, making it inaccessible and preventing any further actions like deletion or modification, you can try the following steps to resolve the issue:

• Ensure there are no resource locks on the Synapse workspace or its dependent resources.
• Go to the Azure Portal > Resource Group > Check for locks on the Synapse workspace or associated resources like storage accounts, managed identity, or SQL pools.
• If possible, manually delete the dependent resources (e.g., SQL pools, integration runtimes, or storage accounts) linked to the workspace. After removing dependencies, attempt to delete the workspace again.
• Sometimes, the Azure Portal might not allow actions on corrupted resources. Use the following commands:

    Remove-AzResource -ResourceId <workspace-resource-id>
  

    az resource delete --ids <ResourceId>
  

  Replace <ResourceId> with the ID of the Synapse workspace.
• If none of the above steps resolve the issue, raise a support request with Azure Support.

Please check the below similar issue threads that also might help you.

https://learn.microsoft.com/en-us/answers/questions/1465756/i-cannot-delete-azure-synapse-workspace

https://learn.microsoft.com/en-us/answers/questions/2116217/unable-to-delete-azure-synapse-workspace-even-thro

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.