Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
How do I troubleshoot and resolve table errors in AWS DMS?
My AWS Database Migration Service (AWS DMS) task or DMS Serverless replication shows the "Running with errors" or "Error" status. I want to troubleshoot and resolve issues with my tables.
Short description
When AWS DMS can't migrate tables from your source database to the target database, the migration task or serverless replication shows the "Running with errors" or "Error" status.
To troubleshoot and resolve these errors, complete the following steps:
- Install or start the Amazon CloudWatch agent.
- Check the state of your migration task or serverless replication.
- Use the AWSSupport-TroubleshootDMSTableErrors runbook to analyze and resolve table error messages.
Note: If you didn't create and start a migration task or serverless replication at least once, then start one.
Resolution
Install or start the CloudWatch agent
To collect metrics and logs, install the Amazon CloudWatch agent and start the agent.
Check migration task or serverless replication state
Note: If you receive errors when you run AWS Command Line Interface (AWS CLI) commands, then see Troubleshooting errors for the AWS CLI. Also, make sure that you're using the most recent AWS CLI version.
To view the state of your migration task, review your task's Table statistics section. You can also run the describe-table-statistics AWS CLI command. To check the state of your serverless replication, review your serverless replication logs.
Run the troubleshooting runbook
Note: Before you begin, make sure that your AWS Identity and Access Management (IAM) role has the required permissions to run the automation. For more information, see the Required IAM permissions section in AWSSupport-TroubleshootDMSTableErrors.
Complete the following steps:
- Open the AWS Systems Manager console.
- In the navigation pane, choose Documents.
- Search for AWSSupport-TroubleshootDMSTableErrors, and then select it.
- Choose Execute automation.
- For Execution Mode, keep the Simple execution selection.
- For DMSArn, enter the Amazon Resource Name (ARN) for the task or serverless replication.
- Choose Execute.
After the automation completes, review the Outputs section and complete the runbook's troubleshooting steps.
Related information
AWS Support Automation Workflows (SAW)
Run an automated operation powered by Systems Manager Automation
Troubleshooting migration tasks in AWS Database Migration Service
- Language
- English
Relevant content
- asked 3 months ago
- asked a year ago
