Wondering how to resolve when AWS DMS task validation fails? We can help you.
Here, at Bobcares, we assist our customers with several AWS queries as part of our AWS Support Services.
Today, let us see how our Support Techs resolve this AWS error.
How to resolve AWS DMS task validation fails?
When you enable validation for an AWS DMS task, you can review statistics at the table level and configure data validation settings.
You can view the data validation information using the AWS DMS console, the AWS Command Line Interface (AWS CLI), or the AWS DMS API.
Please note if you receive errors when running AWS CLI commands, make sure that you’re using the most recent version of the AWS CLI.
Today, let us see the steps followed by our Support techs to resolve it.
1.Firstly to view the data validation report, open the AWS DMS console.
2.Next, choose Database migration tasks from the navigation pane.
3.Then, choose the name of your task.
4.From the Table statistics section, review the Validation state.
Also you can run describe-table-statistics to review the data validation report in JSON format:
aws dms describe-table-statistics --replication-task-arn arn:aws:dms:us-east-1:45454545454:rep:XXXXXXXXXXXXXXXXXX
If the validation state is Mismatched records, then query the table awsdms_validation_failures_v1 that is created by AWS DMS on the target database:
select * from awsdms_validation_failures_v1 where TASK_NAME = 'XXXXXXXXXXXXXXXXXX';
Please make sure the value of TASK_NAME is the external resource ID of the task.
It is the last value in the task Amazon Resource Name (ARN).
After you have the primary key of the failed record, query the source and target endpoints to see what part of the record doesn’t match.
[Need help with more AWS errors ? We’d be happy to assist you]
To conclude, here we saw how our Support Techs resolve AWS DMS task validation fails error.