Azure / Azure/azure-quickstart-templates

201-vm-sql-full-autopatching - DSC Issue

Open
#5,286 2 comments 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
When Deploying this template i get a DSC error as per below

{"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\": \"DeploymentFailed\",\r\n \"message\": \"At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-debug for usage details.\",\r\n \"details\": [\r\n {\r\n \"code\": \"Conflict\",\r\n \"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}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}"}]}

### Repro steps (*if necessary, delete otherwise*)
1. Deploy from Github - get the error
2. Deploy from Visual Studio Code - Get same error

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the 201-vm-sql-full-autopatching template linked in the issue and reproduce the deployment from GitHub or Visual Studio Code. Investigate the dscExtension failure for PrepareSqlServerSa, especially the missing SqlVMStoragePoll and SqlVMDataDisk resources. Done means the template deploys successfully without the reported DSC storage errors.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.