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 réponse
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
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions