DMS replication

Question

Hello AWS

We are having an issue related to DMS table replication.

The DMS manager says that there is no error in the replication task or errors in the tables, however
we have detected that some records are not updated correctly. Some data exists at the source but does not exist at the destination

Can you help us understand what happened?

Compliments

Answer

Please refer to DMS task cloudwatch logs for any warnings or errors. 
If the error is from failed dml operation on target you can check for any reported errors in target awsdms_apply_exceptions table
For further pointers please refer to 
https://aws.amazon.com/blogs/database/debugging-your-aws-dms-migrations-what-to-do-when-things-go-wrong-part-1/
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html

DMS replication

Contenido relevante