remote pdb clone fails due to missing work request id

[hal9000jw]

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 "me too" comments, 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

Terraform Version and Provider Version

Terraform v1.9.4
on linux_amd64

• provider registry.terraform.io/oracle/oci v6.20.0

Affected Resource(s)

oci_database_pluggable_database

Terraform Configuration Files

resource "oci_database_pluggable_database" "pluggable_database_crml" {
  container_database_id = module.database.cdb_id
  pdb_name              = "CRML"

  pdb_creation_type_details {
    creation_type                            = "REMOTE_CLONE_PDB" # LOCAL_CLONE_PDB | REMOTE_CLONE_PDB
    source_pluggable_database_id             = data.terraform_remote_state.db_erp_dev.outputs.pdbs["CRMD"].pdb_id
    source_container_database_admin_password = data.terraform_remote_state.db_erp_dev.outputs.admin_password

    refreshable_clone_details {
      is_refreshable_clone = false
    }
  }

  should_pdb_admin_account_be_locked = true
  tde_wallet_password                = module.database.tde_wallet_password

  timeouts {
    create = "8h"
  }
}

Debug Output

N/A

Panic Output

N/A

Expected Behavior

The terraform resource should report successful completion since the pdb was cloned successfully, is available in the console and is in a read/write state. The work request also reports successful completion...

$ oci work-requests work-request get --work-request-id ocid1.coreservicesworkrequest.oc1.iad.abuwcljrp77bklgjdhlnpdmf2prr4vupkcgaoibcnjiswjqtfh3pcceesiga
{
  "data": {
    "compartment-id": "ocid1.compartment.oc1..<removed>",
    "id": "ocid1.coreservicesworkrequest.oc1.iad.abuwcljrp77bklgjdhlnpdmf2prr4vupkcgaoibcnjiswjqtfh3pcceesiga",
    "operation-type": "Remote Clone Pluggable Database",
    "percent-complete": 100.0,
    "resources": [],
    "status": "SUCCEEDED",
    "time-accepted": "2024-12-17T23:03:30.102000+00:00",
    "time-finished": "2024-12-17T23:55:23.021000+00:00",
    "time-started": "2024-12-17T23:03:39.634000+00:00"
  }
}

Actual Behavior

│ Error: Work Request error
│ Provider version: 6.20.0, released on 2024-12-11.
│ Service: Database Pluggable
│ Error Message: work request succeeded but no identifier was found, workId: ocid1.coreservicesworkrequest.oc1.iad.abuwcljrp77bklgjdhlnpdmf2prr4vupkcgaoibcnjiswjqtfh3pcceesiga, entity: pluggableDatabase, action: CREATED
│ Resource OCID: ocid1.pluggabledatabase.oc1.iad.anuwcljrnoavv2ya7hk24uv2753yhs7imsdefj7brcypvl4yr27c3jtcsk3q
│ Suggestion: Please retry or contact support for help with service: Database Pluggable
│
│
│ with oci_database_pluggable_database.pluggable_database_crml,
│ on database.tf line 66, in resource "oci_database_pluggable_database" "pluggable_database_crml":
│ 66: resource "oci_database_pluggable_database" "pluggable_database_crml" {

Steps to Reproduce

1. terraform apply

Important Factoids

N/A

References

Issue # 2227

[tf-oci-pub]

Thank you for reporting the issue. We have raised an internal ticket to track this. Our service engineers will get back to you.

[hal9000jw]

For everyone's knowledge, I have determined that the following commands can be used to rectify the situation.

terraform apply -refresh-only -target="oci_database_pluggable_database.<resource_name>"

terraform untaint oci_database_pluggable_database.<resource_name>