By using AWS re:Post, you agree to the Terms of Use
/AWS DMS - Migration fails when column in column filter is in camel case/

AWS DMS - Migration fails when column in column filter is in camel case

0

We are trying to migrate data from AWS Aurora Postgres (v13.4) to another AWS Aurora Postgres database (Serverless v2) but the data migration fails for tables wherein we add a column filter. Our table names and column names are in the upper camel case. I checked the logs it shows the following error:

2022-04-27T09:31:12 [TRANSFORMATION  ]E:  Failed to init filter for column CompanyId [20014]  (manipulator.c:605)
2022-04-27T09:31:12 [TRANSFORMATION  ]W:  The metadata transformations defined for table 'public.Tenants' were not performed as at least one of the transformation expressions contains an error  (manipulator.c:147)

Here is the mapping rule:

{
    "rules": [
        {
            "rule-type": "selection",
            "rule-id": "046273916",
            "rule-name": "046273916",
            "object-locator": {
                "schema-name": "public",
                "table-name": "Tenants"
            },
            "rule-action": "include",
            "filters": [
                {
                    "filter-type": "source",
                    "column-name": "CompanyId",
                    "filter-conditions": [
                        {
                            "filter-operator": "eq",
                            "value": "xxxxxx"
                        }
                    ]
                }
            ]
        },
        {
            "rule-type": "selection",
            "rule-id": "042087387",
            "rule-name": "042087387",
            "object-locator": {
                "schema-name": "public",
                "table-name": "Plans"
            },
            "rule-action": "include",
            "filters": []
        }
    ]
}
1 Answers
0

this seems to be a edge case i would suggest opening aws support case, so that they can work on this and provide any available workaround

answered 15 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions