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
preguntada hace un año503 visualizaciones
1 Respuesta
0
Respuesta aceptada

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
INGENIERO DE SOPORTE
Kevin_Z
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas