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
asked a year ago597 views
1 Answer
0
Accepted Answer

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
SUPPORT ENGINEER
Kevin_Z
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions