DMS task stalls at truncating tables in target S3 bucket

Question

I have created a DMS task to migrate data from a view in a MSSQL database running on an EC2 instance to a folder in an S3 bucket. It is a full load and truncates existing tables in target bucket. There are currently no tables as the task has never successfully run. The task stalls once it gets to the truncate/delete tables step. There are no error messages. It just does not progress any further.

Answer

CloudWatch metrics is a good place to start troubleshooting a stuck DMS task. Please see this [post](https://repost.aws/knowledge-center/dms-stuck-task-progress) for details.

Answer

What is the type / size of your DMS replication instance? It may be the source of the trouble if the source from which you replicate is very active.
Following page guides you on finding the right type to have smooth replication.

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_ReplicationInstance.Types.html

DMS task stalls at truncating tables in target S3 bucket

Relevanter Inhalt