Thank you for reaching us. I understand that you have noticed that a small number of records to remain in "pending" state after full load completion and sometimes reloading the table will resolve the issue. While the specific issue needs to be investigated upon by the Premium Support Engineer, a probable reason can be due to the presence of rows which are being continuously modified at the source during validation; then AWS DMS can't validate those rows.
Besides, we also have an option to manually validate the tables again by clicking on the 'Validate again' button on the task console. This will work for a full load and cdc dms task and a cdc only dms task but not for a full load only dms task.
I will also recommend you to let the task run with these pending records for a while to see if they are marked as 'Mismatched records' and then you can make use of the 'awsdms_validation_failures_v1' control table at the target to look them up:
[+] AWS DMS data validation - Troubleshooting - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Validating.html#CHAP_Validating.Troubleshooting
How can I stop an in progress Lift and Shift migrationasked 5 months ago
Migration task Progress is showing 0 and it is stuckasked 7 months ago
In the midst of transferring all my domains to Route53 I have an important .UK.NET domain that I find I cant transfer to ROUTE53Accepted Answerasked 4 months ago
Certificate Requests Stuck In Pending Validationasked 3 years ago
Where do I set innodb_force_recovery in RDS Mariadbasked a month ago
We lost access to i-037efcb963119d88a and cant reboot itasked 3 years ago
I have lots of tables that are stuck in the "Pending Records" Validation state and I can't get them to progressasked a month ago
I have a runn p2.xlarge instance that I wish to permanently terminateasked 3 years ago
Instance i-09e40ed2e3967760d is stuck in stopping stateasked a year ago
Instances stuck in shutting downAccepted Answerasked 3 years ago