AWS DMS Resolving 'Failed to Retrieve Capture List' Error in MSSQL to MySQL Migration

Hello.

This error usually indicates an issue with the source endpoint configuration or network connectivity between AWS DMS and the source database.

Check Endpoint Configuration: Ensure that the source endpoint for the MSSQL database is correctly configured in AWS DMS. Verify the connection details like server name, port, and credentials. Confirm that the specified database user has the required permissions to read the database objects.

Network Connectivity: Check if the AWS DMS instance can reach the MSSQL database hosted on Azure. Verify that there are no network issues like firewalls or security groups blocking the connection.

Regards, Andrii

Error 'Failed to Retrieve Capture List' appeared while starting a replication task on an Oracle source.

Review of the alert log led to a trace file containing: MODULE NAME: repctl

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

The query was a select on all_tables with 5000 "or" clauses such as

OR  (owner like 'SYSADM' and table_name like 'PSAUTHSIGNON').

"Or" clauses tend to consume high amounts of PGA.

"repctl" confirms that the trace is from DMS.

The solution was to split the list of 5000 tables into four replication tasks with 1250 tables in each one.