I am using AWS DMS to migrate data from sql server to postgres in Full Load + CDC mode. My full load was finished and CDC was ongoing and I stopped the CDC task to start it after a couple of days.

After I started the same task after a couple of days, my task failed and is still failing. The logs indicate the following error for all the tables :

select OBJECTPROPERTY(id, 'TableHasPrimaryKey') from sysobjects where id = ?

SOURCE_CAPTURE : For all the tables, it fails further by logging "failed in checling PK presence for table identified by id)

my source sql server database has not changed in terms of primary key constraints. I did add primary keys to target postgres database after CDC is finished.

But the task and the query is still pointing to failure to read primary key from source database.