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 Answer
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

AWS
answered 2 years 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