DEBUG output: azurerm_mssql_database long_term_retention InvalidParameterValue

long_term_retention.txt

######### Long term retention request #########

[DEBUG] AzureRM Request: 
PUT /subscriptions/2abcd789-1d3g-2ag8-cc77-5ja2fjbdklf9f/resourceGroups/foo-rg-prod-cnus/providers/Microsoft.Sql/servers/foo-sql-prod/databases/foo-sqldb-prod/backupLongTermRetentionPolicies/default?api-version=2017-03-01-preview HTTP/1.1
Host: management.azure.com
User-Agent: Go/go1.15.5 (amd64-darwin) go-autorest/v14.2.1 Azure-SDK-For-Go/v49.2.0 sql/v3.0 HashiCorp Terraform/0.14.6 (+https://www.terraform.io) Terraform Plugin SDK/1.13.1 terraform-provider-azurerm/2.46.1 pid-222c6c49-1b0a-5959-a213-6608f9eb8820
Content-Length: 2
Content-Type: application/json; charset=utf-8
X-Ms-Correlation-Request-Id: 2450b752-580d-91e9-d0ac-701bf6049f79
Accept-Encoding: gzip

{}

[DEBUG] AzureRM Response for https://management.azure.com/subscriptions/2abcd789-1d3g-2ag8-cc77-5ja2fjbdklf9f/resourceGroups/foo-rg-prod-cnus/providers/Microsoft.Sql/servers/foo-sql-prod/databases/foo-sqldb-prod/backupLongTermRetentionPolicies/default?api-version=2017-03-01-preview: 
HTTP/2.0 400 Bad Request
Content-Length: 133
Cache-Control: no-cache
Content-Type: application/json; charset=utf-8
Date: Tue, 09 Feb 2021 14:26:29 GMT
Expires: -1
Pragma: no-cache
Server: Microsoft-HTTPAPI/2.0
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Content-Type-Options: nosniff
X-Ms-Correlation-Request-Id: 2450b752-580d-91e9-d0ac-701bf6049f79
X-Ms-Ratelimit-Remaining-Subscription-Writes: 1199
X-Ms-Request-Id: baa2c81d-e98d-4018-81c7-c9707ed3fc3f
X-Ms-Routing-Request-Id: CANADACENTRAL:20210209T142630Z:9ba12f27-f2f1-4f0b-b736-e7b5cce16373

{"error":{"code":"InvalidParameterValue","message":"Invalid value given for parameter properties. Specify a valid parameter value."}}

######### Short term retention request #########

[DEBUG] AzureRM Request: 
PUT /subscriptions/2abcd789-1d3g-2ag8-cc77-5ja2fjbdklf9f/resourceGroups/foo-rg-prod-cnus/providers/Microsoft.Sql/servers/foo-sql-prod/databases/foo-sqldb-prod/backupShortTermRetentionPolicies/default?api-version=2017-10-01-preview HTTP/1.1
Host: management.azure.com
User-Agent: Go/go1.15.5 (amd64-darwin) go-autorest/v14.2.1 Azure-SDK-For-Go/v49.2.0 sql/v3.0 HashiCorp Terraform/0.14.6 (+https://www.terraform.io) Terraform Plugin SDK/1.13.1 terraform-provider-azurerm/2.46.1 pid-222c6c49-1b0a-5959-a213-6608f9eb8820
Content-Length: 2
Content-Type: application/json; charset=utf-8
X-Ms-Correlation-Request-Id: b7c2591f-a3d3-9557-37df-8c3550718e7d
Accept-Encoding: gzip

{}
[DEBUG] AzureRM Response for https://management.azure.com/subscriptions/2abcd789-1d3g-2ag8-cc77-5ja2fjbdklf9f/resourceGroups/foo-rg-prod-cnus/providers/Microsoft.Sql/servers/foo-sql-prod/databases/foo-sqldb-prod/backupShortTermRetentionPolicies/default?api-version=2017-10-01-preview: 
HTTP/2.0 400 Bad Request
Content-Length: 133
Cache-Control: no-cache
Content-Type: application/json; charset=utf-8
Date: Tue, 09 Feb 2021 14:55:44 GMT
Expires: -1
Pragma: no-cache
Server: Microsoft-HTTPAPI/2.0
Strict-Transport-Security: max-age=31536000; includeSubDomains
X-Content-Type-Options: nosniff
X-Ms-Correlation-Request-Id: b7c2591f-a3d3-9557-37df-8c3550718e7d
X-Ms-Ratelimit-Remaining-Subscription-Writes: 1199
X-Ms-Request-Id: 06b3fc00-f3dd-4a80-840c-14512e9fc119
X-Ms-Routing-Request-Id: CANADACENTRAL:20210209T145545Z:8abd012f-638d-48b5-a710-3cd1f377b9d1

{"error":{"code":"InvalidParameterValue","message":"Invalid value given for parameter properties. Specify a valid parameter value."}}
2021/02/09 09:55:45 [DEBUG] azurerm_mssql_database.foo_db: apply errored, but we're indicating that via the Error pointer rather than returning it: Error issuing create/update request for Sql Server "foo-sql-prod" (Database "foo-sqldb-prod") Short Term Retention Policies (Resource Group "foo-rg-prod-cnus"): sql.BackupShortTermRetentionPoliciesClient#CreateOrUpdate: Failure sending request: StatusCode=400 -- Original Error: Code="InvalidParameterValue" Message="Invalid value given for parameter properties. Specify a valid parameter value."