awscc_dms_migration_project Provider produced inconsistent result after apply

[kstephensontm]

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
• The resources and data sources in this provider are generated from the CloudFormation schema, so they can only support the actions that the underlying schema supports. For this reason submitted bugs should be limited to defects in the generation and runtime code of the provider. Customizing behavior of the resource, or noting a gap in behavior are not valid bugs and should be submitted as enhancements to AWS via the CloudFormation Open Coverage Roadmap.

Terraform CLI and Terraform AWS Cloud Control Provider Version

Affected Resource(s)

• awscc_dms_migration_project

Terraform Configuration Files

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

# Copy-paste your Terraform configurations here - for large Terraform configs,
# please use a service like Dropbox and share a link to the ZIP file. For
# security, you can also encrypt the files using our GPG public key: https://keybase.io/hashicorp

Debug Output

Panic Output

│ Error: Provider produced inconsistent result after apply
│
│ When applying changes to awscc_dms_migration_project.dms_migration_project, provider
│ "provider["registry.terraform.io/hashicorp/awscc"]" produced an unexpected new value:
│ .source_data_provider_descriptors: planned set element
│ cty.ObjectVal(map[string]cty.Value{"data_provider_arn":cty.UnknownVal(cty.String),
│ "data_provider_identifier":cty.StringVal("arn:aws:dms:us-west-2:590183695615:data-provider:WOKMGXN3RZAM5I4CPZNBX4PJFM"),
│ "data_provider_name":cty.StringVal("sc-sql-server"),
│ "secrets_manager_access_role_arn":cty.StringVal("arn:aws:iam:::role/sc-secrets-manager-role"),
│ "secrets_manager_secret_id":cty.StringVal("arn:aws:secretsmanager:us-west-2:㊙️database/mssql-default..us-west-2.rds.amazonaws.com/dms_user--Rl6M5B")})
│ does not correlate with any element in actual.
│
│ This is a bug in the provider, which should be reported in the provider's own issue tracker.

Expected Behavior

Creation of the dms migration project

Actual Behavior

Partial creation with the above error

Steps to Reproduce

resource "awscc_dms_migration_project" "dms_migration_project" {
instance_profile_identifier = awscc_dms_instance_profile.dms_instance_profile.id
migration_project_name = "sc-project2" #"${local.name}-migration-project"
schema_conversion_application_attributes = {
s3_bucket_path = "s3://-sc-s3-bucket"
s3_bucket_role_arn = "arn:aws:iam:::role/sc-s3-role"
}
source_data_provider_descriptors = [
{
data_provider_identifier = awscc_dms_data_provider.dms_data_provider_source.id
data_provider_name = "sc-sql-server"
secrets_manager_access_role_arn = "arn:aws:iam:::role/sc-secrets-manager-role"
secrets_manager_secret_id = "arn:aws:secretsmanager:us-west-2:㊙️database/mssql-default..us-west-2.rds.amazonaws.com/dms_user--Rl6M5B"
},
]
target_data_provider_descriptors = [
{
data_provider_identifier = awscc_dms_data_provider.dms_data_provider_target.id
data_provider_name = "sc-postgresql"
secrets_manager_access_role_arn = "arn:aws:iam:::role/sc-secrets-manager-role"
secrets_manager_secret_id = "arn:aws:secretsmanager:us-west-2:㊙️database/postgres-default/pssql_user-*****-Yy3dv6"
},
]
}

1. terraform apply

Important Factoids

no

References

https://registry.terraform.io/providers/hashicorp/awscc/latest/docs/resources/dms_migration_project

[wellsiau-aws]

related to #1586

[kstephensontm]

I just tried the latest version 1.18.0 to create a migration project (awscc_dms_migration_project) and getting this error. any ideas on how to get this to work? I am able to create this manually. the target is engine = "aurora_postgresql" which exists because the target was created.

│ Error: AWS SDK Go Service Operation Incomplete
│
│ with awscc_dms_data_provider.dms_data_provider_target,
│ on dms-schema-conversion.tf line 39, in resource "awscc_dms_data_provider" "dms_data_provider_target":
│ 39: resource "awscc_dms_data_provider" "dms_data_provider_target" {
│
│ Waiting for Cloud Control API service UpdateResource operation completion returned: waiter state transitioned to FAILED.
│ StatusMessage: The specified database engine is not supported by DMS. Please choose a supported database engine and try
│ again. (Service: DatabaseMigration, Status Code: 400, Request ID: 2b85813d-e4c5-443c-a79b-87be8031ffd2). ErrorCode:
│ InvalidRequest

[kstephensontm]

It wants to update the engine for some reason but only aurora_postgresql works. when you try and use aurora-postgresql, it just errors out.

awscc_dms_data_provider.dms_data_provider_target will be updated in-place

~ resource "awscc_dms_data_provider" "dms_data_provider_target" {
+ data_provider_identifier = (known after apply)
+ description = (known after apply)
~ engine = "aurora-postgresql" -> "aurora_postgresql"
id = "arn:aws:dms:us-east-2::data-provider:EAIS6T77MFFMJKC4IR7D45UKMI"
~ settings = {
+ microsoft_sql_server_settings = (known after apply)
+ my_sql_settings = (known after apply)
+ oracle_settings = (known after apply)
~ postgre_sql_settings = {
+ certificate_arn = (known after apply)
# (4 unchanged attributes hidden)
}
}
+ tags = (known after apply)
# (4 unchanged attributes hidden)
}