Thank you for connecting with us. I understand that you already have successful DMS full load and cdc tasks running which are replicating changes from MongoDB source to PostgreSQL target but for certain Collections the full load is not happening at all.
I assume all the configuration has been setup correctly at the MongoDB end as per the following documentation:
[+] Using MongoDB as a source for AWS DMS - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MongoDB.html
Given you were not able to find any errors/ warning even with the detailed debug on in the task logs, the only other place to look at will be the target PostgreSQL logs for possible hints around the full load run time.
If the DB logs too don't provide any direction, I will request you to please reach AWS Premium Support Team via a support case and with the task ARN details
I was able to fix this actually by looking at some non-error logs also, The issue was the source endpoint which I created had different mongo schema specified. So in my task one of the table was there with same name in different schema as well, while other was not there. So in one table full load happened somehow from other schema.
So I started to create different source endpoint for different mongoDB collecctions. So now every thing works as expected
AWS data migration service task, Load complete, replication ongoing, but no rows loaded in redshift or shown in Table statisticsasked 8 months ago
Using DMS CDC for Oracle to Postgresasked 2 months ago
DMS task is creating full row duplicates in targetasked 5 months ago
AWS DMS Migration task Source MongoDB and Target RDS Postgres
AWS DMS Source MongoDB and Target RDS Postgres Full load not happening but ongoing replication happensAccepted Answer
Applying column filters in DMS Task for source MongoDB and target Postgres
AWS DMS Migration task from source MongoDB and target RDS Postgres
Does DMS drop and creates the target files in S3 target endpoints?asked 24 days ago
DMS Migration MongoDB source and RDS Postgres as destinationAccepted Answer
DMS supports Super type for Redshift target with MongoDB sourceasked 4 months ago