The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

Question

The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

Evan Van Scooter 50

Resource/subscriptions/*****/providers/Microsoft.Sql/managedInstances/smi-inf-sql-dev-east1/securityAlertPolicies/Default
Operation nameUpdate managed server threat detection policy
Time stampThu May 04 2023 17:26:47 GMT-0400 (Eastern Daylight Time)
Error codeResourceDeploymentFailure
MessageThe resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

ShaktiSingh-MSFT 16,271 Reputation points

2023-05-11T07:37:02.0233333+00:00

Hi
Evan Van Scooter •,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Ran Karat 20 Reputation points

2024-01-21T10:11:55.5+00:00

Same here, so frustrating.

4 answers

Your answer

ShaktiSingh-MSFT 16,271 Reputation points

2023-05-11T07:37:02.0233333+00:00

Hi
Evan Van Scooter •,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Ran Karat 20 Reputation points

2024-01-21T10:11:55.5+00:00

Same here, so frustrating.

Answer 1

Stuart Dobson 16

This error is not much use - I have found you're able to get more details by going to the Deployments tab in Azure, clicking on the failed deployment, Related Events, Expand the Operation, find the one that failed and then, this is the important bit, look at the Json tab. I've found that there is usually more added to the message than is shown further up the chain.

Frerichs, R (Roland) 0 Reputation points

2025-03-19T07:29:14.19+00:00

What do you mean by 'Related Events'? I don't see such thing in the deployment.

Answer 2

Alberto Morillo 34,556 MVP

Please verify an Azure Policy may be preventing the deployment to succeed. Here you will find some built-in policies to start.

Meister Melanie 5 Reputation points

2023-05-26T18:37:44.0433333+00:00

@Alberto Morillo Can you update the links? I think, they are wrong
Alberto Morillo 34,556 Reputation points MVP

2023-05-26T20:15:38.75+00:00

@Melanie Meister thank you so much for reaching me.
Tejas Patil 10 Reputation points

2023-06-06T15:32:50.52+00:00

@Alberto Morillo where's the link to policies? Can you please add it?
Alberto Morillo 34,556 Reputation points MVP

2023-07-25T12:56:41.78+00:00

https://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql

Answer 3

Cody Holmes 10

Yet again, another Azure error that has no explanation. Having the same issue, which is disrupting my business. Microsoft really needs to get this entire system together. I'm getting incredibly annoyed with Azure.

I'm starting to understand why everyone is on Amazon infrastructure.

Answer 4

Ayaz 0

i am also facing some issue : The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed

Share via

The resource write operation failed to complete successfully, because it reached terminal provisioning state 'Failed'.

4 answers

Your answer