I have created CDC DMS Task to Replicate oracle RDS Data between two environments. I observed when we are having multiple tables in Mapping rules, When I create task,Migration progress is struck at 0% .When I stop and resume the task.I am ablo to see migration progress as 100%. Usually in what scenarios, do we face it? I dont see any errors as well. We observed that, When Migration Progress is 0% , it will not actually replicate the data..only after progress shows 100% it is replicating data.
Would having triggers in Target table cause this? Usually sometimes when we create the task itself we are able to see e migration progress as 100% but sometimes it is struck at 0% and wont move to 100% until we stop and resume the task.
Source : Oracle RDS Target : Oracle RDS in different env Replication Type: Replication Ongoing only( No Full load)MigrationProgress
Below is how our metrics looks like :
I tried with increasing Replication Instance size but it didn’t worked .