Unable to delete Azure Synapse Workspace even through Powershell force deletion

vaddi_dataengineer 20

Hello Team,

I am unable to delete synapse analytics even though following up post through webUI or powershell. I tried following the steps mentioned in the link below :-

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

but getting error -

Remove-AzResource: DeleteWorkspaceOrchestrationException : Workspace deletion failed due to unexpected exception.Check error message for exception details

CorrelationId: d406f6f6-7ca8-4901-9e4a-443db692eac8

Ganesh Gurram 1,825 Reputation points Microsoft Vendor

2024-11-06T23:40:27.01+00:00
@vaddi_dataengineer - Thanks for the question and using MS Q&A forum.

It seems like you're having trouble deleting your Azure Synapse Workspace. The error message you're receiving indicates that there's an unexpected issue preventing the deletion. Here are some steps you can take to troubleshoot and potentially resolve the issue:

Check Resource Dependencies: Ensure there are no dependent resources (such as SQL pools, Spark pools, linked services, etc.) that might be causing the issue. These resources typically need to be deleted before the Synapse Workspace can be deleted.

Resource Locks: Verify that there is no resource locks applied to the Synapse Workspace or any of its dependent resources. Resource locks can prevent deletion. You can check and remove locks in the Azure portal under the "Locks" section of the resource.

Check Activity Logs: Review the activity logs in the Azure portal for any specific error messages or details that might provide more insight into why the deletion is failing. The activity logs can be found in the "Activity log" section of the resource group or the Synapse Workspace.

Permissions: Ensure that the account you are using to delete the workspace has sufficient permissions. You need to have the necessary RBAC roles assigned, such as Owner or Contributor, at the resource group or subscription level.

Retry Deletion: Sometimes, intermittent issues can cause deletion to fail. Try deleting the workspace again after some time.

If the issue persists, you can try using the Remove-AzSynapseWorkspace cmdlet with the -Force parameter to force the deletion.

Hope this helps. Do let us know if you have any further queries.
vaddi_dataengineer 20 Reputation points

2024-11-07T00:30:50.3966667+00:00

I have tried all the above options earlier and tried last option but it is throwing unexpected exception.

Please let me know how to raise support ticket for this and close this issue to avoid any billing charges ?
Ganesh Gurram 1,825 Reputation points Microsoft Vendor

2024-11-07T17:08:32.2666667+00:00
@vaddi_dataengineer - To raise a support ticket in Azure, follow these steps:

Go to Azure Portal.

Navigate to Help + Support:

Click on the question mark (?) icon in the top-right corner.

Select Help + support.

Create a Support Request:

Click on Create a support request.

Follow the prompts to provide details about your issue. Make sure to select the appropriate service and issue type.

Provide Detailed Information:

Describe your problem in detail, including any error messages and steps you’ve already taken.

Attach any relevant logs or screenshots.

Select Support Plan and Severity:

Choose your support plan and the severity level based on the impact on your business.

Submit the Request:

Review your information and submit the support request.

For more information, refer to this: Create an Azure support request

This should help you get in touch with Azure support to resolve the issue and avoid any unnecessary billing charges. Let me know if you need any further assistance!
Ganesh Gurram 1,825 Reputation points Microsoft Vendor

2024-11-08T15:10:08.0333333+00:00

@vaddi_dataengineer - Did you get a chance to raise a support ticket? If so, please share the #SR number. Thanks!
Ganesh Gurram 1,825 Reputation points Microsoft Vendor

2024-11-11T12:00:24.8466667+00:00

@vaddi_dataengineer - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
vaddi_dataengineer 20 Reputation points

2024-11-13T00:22:38.96+00:00
Hi Team,

Apologies, as I was busy so couldnt look into it on priority. But the issue is resolved, after following the step :-

Grant the SQL Server Contributor Azure RBAC role to the principal named Microsoft Azure Synapse Resource Provider at the subscription containing the Synapse workspace to be deleted.

Delete the Synapse workspace.

Wait for the deletion operation to complete.

Remove the Azure RBAC role assignment created as part of step 1.

The issue was majorly due to SQL Server role assignment which was missing in subscription level.
Ganesh Gurram 1,825 Reputation points Microsoft Vendor

2024-11-13T00:38:19.58+00:00

@vaddi_dataengineer - I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

Accepted answer

Ganesh Gurram 1,825 Reputation points Microsoft Vendor

2024-11-13T00:41:52.0333333+00:00
@vaddi_dataengineer - I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

Ask: Unable to delete Azure Synapse Workspace even through Powershell force deletion

Solution: The issue is resolved, after following the step :-

Grant the SQL Server Contributor Azure RBAC role to the principal named Microsoft Azure Synapse Resource Provider at the subscription containing the Synapse workspace to be deleted.

Delete the Synapse workspace.

Wait for the deletion operation to complete.

Remove the Azure RBAC role assignment created as part of step 1.

The issue was majorly due to SQL Server role assignment which was missing in subscription level.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue.

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Unable to delete Azure Synapse Workspace even through Powershell force deletion

0 additional answers

Your answer