Why is my AWS DMS task in an error status?
Last updated: 2021-02-16
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, you must enable Amazon CloudWatch logging. If you haven't enabled logging, stop the task, modify the task to enable logging, and then restart the task.
- From the Logs page for your task, filter the time stamps for events that have ]E: and ]W:.
- After you resolve the errors, you must reload the tables or restart the task for to the error status to be resolved.