AWS DMS task fails to retrieve tables

Question

I'm trying to migrate existing data and replicate ongoing changes the source database is PostgreSQL it's managed by aws. the target is kafka. I'm facing the below issue.

Last Error No tables were found at task initialization. Either the selected table(s) or schemas(s) no longer exist or no match was found for the table selection pattern(s). If you would like to start a Task that does not initially capture any tables, set Task Setting FailOnNoTablesCaptured to false and restart task. Stop Reason FATAL_ERROR Error Level FATAL

Facing same issue with one of my new DMS tasks with Postgresql as a source. — Suz'l Shrestha, Apr 21 '22 at 08:27
@Suz'lShrestha try to set database name postgres in the endpoint — Mohamed Emad, May 17 '22 at 08:30

score 0 · Answer 1 · answered Mar 16 '23 at 14:07

I faced the same issue. I was using database user that is not root(or user that doesn't have enough permission). Once I started using the root user for the DMS task, everything went smooth.

AWS DMS postgresql as a source documentation link: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html

AWS DMS task fails to retrieve tables

1 Answers1