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 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南