AWS DMS shows records Mismatched records and it shows around 600 records mismatched

Hi There,

I understand that you ran DMS , which migrates data from Oracle to postgres. After the migration DMS shows mimsatched records and it shows around 600 records mismatched. and would like to find out if there is any was you can identify and fix this issue.

Please that During validation, DMS creates a table at the target endpoint: awsdms_validation_failures_v1. If any record enters the ValidationSuspended or the ValidationFailed state, AWS DMS writes diagnostic information to awsdms_validation_failures_v1. You can query this table to help troubleshoot validation errors.

select * from awsdms_validation_failures_v1 where TASK_NAME = '<task name>'
 

Please look at the DETAILS field in the output from above to determine which columns don’t match. After you have found the validation errors on the "awsdms_validation_failures_v1" table returned by the above query and have the primary key of the failed record, you can query the source and target endpoints to see what part of the record does not match. Please refer to documentation- [1] for ValidationState implication.

Mismatched Records validation status indicates that some records in the table don't match between the source and target. Please refer to documentation [2], A mismatch might occur for a number of reasons and details would normally be provided in the awsdms_validation_failures_v1 table on the target endpoint.

Additionally, please check out this doc for troubleshooting tips [3].

Further, you may consider to perform a select in both the source and target environment to confirm that this is indeed a legitimate mismatch and not a false positive.

I hope this information will help.

[1] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html#CHAP_Validating.TaskStatistics

[2] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html#CHAP_Validating.TaskStatistics

[3] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html#CHAP_Validating.Troubleshooting

Please note that I personally value your feedback and would appreciate it if you accept and thumbs up this response if it satisfies your question