Failure with ongoing replication from SQL Server RDS using AWS DMS
Need to disable SQL Server Change tracking and enable RDS Change Tracking.

Find any tables which are enabled for CDC with:

SELECT s.name as Schema_name, t.name AS Table_name, tr.* FROM sys.change_tracking_tables tr INNER JOIN sys.tables t on t.object_id = tr.object_id INNER JOIN sys.schemas s on s.schema_id = t.schema_id;


Then for each of those tables table run:

ALTER TABLE dbo.Products DISABLE CHANGE_TRACKING;


Disable CDC on the database:

alter database AdventureWorks set change_tracking = off


Enable RDS CDC on the database:

exec msdb.dbo.rds_cdc_enable_db 'AdventureWorks'


Enable RDS CDC for each table:

exec sys.sp_cdc_enable_table   
   @source_schema           = N'dbo'
,  @source_name             = N'Products'
,  @role_name               = NULL;


Finally rerun your DMS tasks and they should work.