terraform-provider-azurerm: terraform throws error while creating premium tier elasticpool : azurerm_sql_elasticpool

This issue was originally opened by @reddyed as hashicorp/terraform#18488. It was migrated here as a result of the provider split. The original body of the issue is below.

Hello,

i am able to create the azurerm_sql_elasticpool with the basic tier edition. but when i add it as premium tier in the terraform scripts, it throws error. my script is

resource "azurerm_sql_elasticpool" "elasticpool" {
name = "prod-epool"
resource_group_name = "${azurerm_resource_group.rg.name}"
location = "${azurerm_resource_group.rg.location}"
server_name = "${azurerm_sql_server.sql_server.name}"
edition = "Premium"
dtu = 2000
db_dtu_min = 0
db_dtu_max = 1750
pool_size = 5000
}

The error i get when i execute the terraform script is

azurerm_sql_elasticpool.elasticpool: 1 error(s) occurred:

azurerm_sql_elasticpool.elasticpool: sql.ElasticPoolsClient#CreateOrUpdate: Failure sending request: StatusCode=0 -- Original Error: json: cannot unmarshal array into Go struct field serviceError2.details of type map[string]interface {}

Any help is appriciated. Thanks

About this issue

Original URL
State: closed
Created 6 years ago
Comments: 17 (3 by maintainers)

Most upvoted comments

@jeffreyCline Thanks, I created #1931 for the similar issue with azurerm_sql_database

eoly on Sep 14, 2018

Throwing my hat in the ring here too.

Experiencing this same issue creating an azurerm_sql_database using Basic edition. Standard works.

terraform v0.11.8 terraform-provider-azurerm_v1.14.0_x4

eoly on Sep 13, 2018

I was able to get it to work, I manually configured the settings I wanted via the portal, and then looked at the Automation Script JSON file. My pool_size needed to be 51200 instead of 50000.

  pool_edition             = "Standard"
  pool_dtu                 = "50"
  pool_db_dtu_min          = "0"
  pool_db_dtu_max          = "10"
  pool_size                = **"51200"**

this worked,

Parvez-dkda on Jul 25, 2018