Share via

Issue with Corrupted Azure Synapse Workspace During Creation

Bram Teunis 0 Reputation points
2024-12-23T12:56:24.19+00:00

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.
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,093 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Smaran Thoomu 18,790 Reputation points Microsoft Vendor
    2024-12-23T13:59:31.85+00:00

    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://zcusa.951200.xyz/en-us/answers/questions/1465756/i-cannot-delete-azure-synapse-workspace

    https://zcusa.951200.xyz/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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.