AWS announces AWS Interconnect – multicloud (preview), providing simple, resilient, high-speed private connections to other cloud service providers. AWS Interconnect - multicloud is easy to configure and provides high-speed, resilient connectivity with dedicated bandwidth, enabling customers to interconnect AWS networking services such as AWS Transit Gateway, AWS Cloud WAN, and Amazon VPC to other cloud service providers with ease.
Notify table error on AWS DMS Replication task
Hello, I want to be able to catch/detect table errors on my dms replication task, there is a thread from 2 years ago saying this is not possible (https://repost.aws/questions/QUhmFmkcEtQHin24L52rWpPg/aws-dms-replication-task-table-in-error-setup-notification), is this still the case?
I have currently set up an EventBridge rule to catch state changes on migration tasks. This dispatches a lambda to notify when there is a task failure. The problem is when some individual table fails in the task, having errors like:
The problem is that this only catches task-level failures and table errors are not, is there any way i can catch those?
- Newest
- Most votes
- Most comments
Hello.
As far as I know, as of October 2025, there is no event setting in AWS DMS to detect errors on a table-by-table basis.
DMS has an API called "describe-table-statistics," so why not use it to create a system that periodically checks for table errors?
https://docs.aws.amazon.com/cli/latest/reference/dms/describe-table-statistics.html
Yes, you can detect table errors in AWS DMS replication tasks through a few approaches:
-
AWSSupport-TroubleshootDMSTableErrors Automation Runbook: AWS provides an automation runbook that can identify tables in the
TableErrorstate. This runbook checks if CloudWatch logging is enabled for your DMS resource, analyzes the logs, and generates a report for each table in error state with suggestions for resolving issues. This requires CloudWatch logging to be enabled for your DMS task. -
Data Validation: You can enable data validation when creating or modifying a task. This allows you to monitor the validation state of tables through the console, AWS CLI, or AWS DMS API. You can view validation statistics including error states by checking the Table Statistics tab in the console or using the
describe-table-statisticscommand via CLI. -
Error Handling Settings: You can configure how AWS DMS handles table errors using task settings like
TableErrorPolicy(determines action when an error occurs for a specific table) andTableErrorEscalationPolicy(determines action when maximum number of errors is reached). By default, when a table error occurs, the task continues but data from the table with the error is moved into an error state. -
Data Resync: For CDC tasks where tables are in error state, AWS DMS version 3.6.1 and above offers Data Resync functionality that can automatically detect and resolve data inconsistencies, which is useful when a table is in error state and changes aren't being replicated to the target.
While there isn't a direct EventBridge event specifically for table-level errors (unlike task-level failures), you can implement a monitoring solution using the above approaches to detect and respond to table errors in your DMS tasks.
Sources
Error handling task settings - AWS Database Migration Service
AWSSupport-TroubleshootDMSTableErrors - AWS Systems Manager Automation Runbook Reference
Data consistency with AWS DMS data resync | AWS Database Blog
AWS DMS data validation - AWS Database Migration Service
Hi,
EventBridge can be configured to send events on multiple DMS state changes and activities: see https://docs.aws.amazon.com/dms/latest/userguide/CHAP_EventBridge.html
Look at section "ReplicationTask event messages": the event DMS-EVENT-0078may be the one that you are looking for.
Didier
Relevant content
- asked 2 years ago
- asked 10 months ago
- asked 2 years ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 3 years ago
