DMS Cannot get captured tables list [1020486] (tasktablesmanager.c:964)

I am trying to migrate a database in MSSQL RDS server with DMS service. to POSTGRES RDS. While the service successfully migrates the db with lesser number of tables. It is not able to migrate db with large number of tables.

The error encountered is:

• Calling for get capture table list from the Metadata Manager started. (tasktablesmanager.c:960)
• Failed (retcode -1) to execute statement
• RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server]Query timeout expired [1022502]
• Failed to get the capture list from the endpoint. Attempt #1 from 5 (metadatamanager.c:4977)
• Cannot get captured tables list [1020486] (tasktablesmanager.c:964)