DMS "Validation query execution failure" -- how to find the query that failed

0

I have a couple tables in a DMS task where the ValidationState is "Table error" and the ValidationStateDetails is "Validation query execution failure". Can anyone tell me how to find the query/action that failed? I've searched the DMS task and RDS target logs in Cloudwatch as well as the logs of the source DB but am not finding anything.

Jeremy
已提问 1 年前503 查看次数
1 回答
0
已接受的回答

Hi

To be able to find the validation query, you will need to reach to the support team, and we have to enable the internal logging to be able to capture the validation query.

Or depends on what engine, there might be engine logging which can be enabled to capture what DMS executed against the database. (It should be a select query, however if it failed, engine log may reveal the failure reasons)

AWS
支持工程师
Kevin_Z
已回答 1 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容