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 Antwort
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
beantwortet vor 2 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen