CODEWITHSUNDEEP
amazon-web-servicesamazon-athenadms
Wev
Wev

Reputation: 283

AWS DMS failing on second run due to Athena permissions

DMS is producing this error on the second run. Can't work out why, I've not even said for Athena to be used.

2024-09-18T15:49:45 [TARGET_APPLY    ]I:  Key len for get: 17 for table `(null)`.`(null)`  (file_glue_catalog_generation.c:296)
2024-09-18T15:49:45 [TASK_MANAGER    ]E:  Not retriable error: <InvalidRequestException> line 1:8: mismatched input 'DATABASE'. Expecting: 'MATERIALIZED', 'MULTI', 'OR', 'PROTECTED', 'ROLE', 'SCHEMA', 'TABLE', 'VIEW' [1001730]  (anw_retry_strategy.cpp:118)
2024-09-18T15:49:45 [TASK_MANAGER    ]E:  The athena start query execution request failed: line 1:8: mismatched input 'DATABASE'. Expecting: 'MATERIALIZED', 'MULTI', 'OR', 'PROTECTED', 'ROLE', 'SCHEMA', 'TABLE', 'VIEW' [1001804]  (athena_client.cpp:439)
2024-09-18T15:49:45 [TARGET_APPLY    ]E:  Failed to create Athena Database (null) [2]  (file_glue_catalog_generation.c:326)
2024-09-18T15:49:45 [TARGET_APPLY    ]I:  Error in bulk, bulk state: bulk confirmed record id - '0', bulk last record id - '0', confirmed record id - '10517', sorter confirmed record id - '10517'  (bulk_apply.c:2993)```

Upvotes: 0

Views: 184

Answers (1)

Mandrew
Mandrew

Reputation: 1

I had the same problem, and it turned out to be network related. I had to add a VPC endpoint for Athena and make sure that port 444 was open. That resolved it for me. Turning on debug level error logging was the key that showed me the full error.

Upvotes: 0

Related Questions