Error is thrown when creating ES or ETCD DB with `ops_manager` user

[akocbek]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

We tried to use ibm_database terraform resource to created ES and etdc database, with new user which has ops_manager type. On terraform apply error is thrown and deployment fails.

Error: [ERROR] CreateDatabaseUser (user123) failed Not Found
│ {
│     .....
│     "Result": {
│         "errors": {
│             "errors": "not_found",
│             "hint": "You may need to URL-encode any included CRN(s), see https://cloud.ibm.com/apidocs/cloud-databases-api/cloud-databases-api-v5#deployment-ids-and-crns for details"
│         }
│     },
│ }
│ 
│ 
│   with ibm_database.db,
│   on main.tf line 11, in resource "ibm_database" "db":
│   11: resource "ibm_database" "db" {

Terraform CLI and Terraform IBM Provider Version

terraform -v
Terraform v1.6.6
on darwin_arm64
+ provider registry.terraform.io/ibm-cloud/ibm v1.67.1

Affected Resource(s)

• ibm_database

Terraform Configuration Files

Please include all Terraform configurations required to reproduce the bug. Bug reports without a functional reproduction may be closed without investigation.

resource "ibm_resource_group" "resourceGroup" {
  name     = "test_bug_rg_2"
}

resource "ibm_database" "db" {
  name              = "test_bug_db_etcd_2"
  plan              = "standard"
  location          = "eu-gb"
  service           = "databases-for-etcd"
  resource_group_id = ibm_resource_group.resourceGroup.id
  tags              = ["tag1", "tag2"]
  adminpassword    = "password12345678"
  users {
    name     = "user123"
    password = "passwor!!!!d12345678"
    type     = "ops_manager"
  }

  timeouts {
    create = "120m"
    update = "120m"
    delete = "15m"
  }
}

Debug Output

https://gist.github.com/akocbek/1e9aeb278fd4cbfc66faa49ac864511c

Panic Output

Expected Behavior

• User for database with type ops_manager would be created

Actual Behavior

• User for database with type ops_manager is not created, error is thrown CreateDatabaseUser (user123) failed Not Found

Steps to Reproduce

1. terraform apply

Important Factoids

References

• #0000