Azure / Azure/azure-quickstart-templates

201-vm-sql-full-autopatching

Open
#5,879 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
14.9k
Forks
16.2k
Avg merge
6d 21h
Merged PRs (30d)
6

Description

[201-vm-sql-full-autopatching](https://github.com/Azure/azure-quickstart-templates/tree/master/201-vm-sql-full-autopatching)

### Issue Details
I tried to deploy the ARM template via the Azure DEV Ops pipeline and got the following error. It works just fine when I am trying to deploy this from the git to Azure.

"error": {
"code": "ResourceDeploymentFailure",
"message": "The resource operation completed with terminal provisioning state 'Failed'.",
"details": [
{
"code": "DeploymentFailed",
"message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details.",
"details": [
{
"code": "Conflict",
"message": "{\r\n \"status\": \"Failed\",\r\n \"error\": {\r\n \"code\": \"ResourceDeploymentFailure\",\r\n \"message\": \"The resource operation completed with terminal provisioning state 'Failed'.\",\r\n \"details\": [\r\n {\r\n \"code\": \"VMExtensionProvisioningError\",\r\n \"message\": \"VM has reported a failure when processing extension 'dscExtension'. Error message: \\\"DSC Configuration 'PrepareSqlServerSa' completed with error(s). Following are the first few: Cannot validate argument on parameter 'StorageSubSystemUniqueId'. The argument is null. Provide a valid value for the argument, and then try running the command again. No MSFT_StoragePool objects found with property 'FriendlyName' equal to 'SqlVMStoragePoll'. Verify the value of the property and retry. No MSFT_VirtualDisk objects found with property 'FriendlyName' equal to 'SqlVMDataDisk'. Verify the value of the property and retry.\\\".\"\r\n }\r\n ]\r\n }\r\n}"
}
]
}
]
}
} undefined

### Repro steps (*if necessary, delete otherwise*)
1. It doesn't have any issues while getting it deployed from the git hub
2. This error occurs only when I am trying to deploy from azure dev ops pipeline.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the linked 201-vm-sql-full-autopatching template and compare its GitHub deployment with the Azure DevOps pipeline deployment. Investigate the dscExtension failure in PrepareSqlServerSa, especially the missing SqlVMStoragePoll and SqlVMDataDisk objects. Done means the template deploys successfully through the reported pipeline path.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure
Domain
cloud, devops, infrastructure
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.