Why is my AWS DMS task in an error status?
Last updated: 2022-10-12
My AWS Database Migration Service (AWS DMS) task is in an error status. What does an error status mean, and how can I troubleshoot and resolve the error?
An AWS DMS task that is in an error status means that one or more of the tables in the task couldn't be migrated. A task in an Error status continues to load other tables from the selection rule, but a failed task stops with fatal errors.
- To identify the table that has an error, open the AWS DMS console.
- Choose Database migration tasks from the navigation pane.
- In the Tables errored column, the number of tables that have errors are listed.
- Choose the name of the task that has an error status.
- From the Table statistics section, check the Load state column to see which table names have errors. Or you can run describe-table-statistics.
- To troubleshoot error messages further, turn on Amazon CloudWatch logging. If you haven't turned on logging, stop the task, and modify the task to turn on logging. Then, restart the task.
- From the Logs page for your task, filter the timestamps for events that have ]E: and ]W: in them.
- After you resolve the errors, reload the tables, or restart the task for to the error status to be resolved.