AWS DMS replication issue on database migration between on-premise to AWS RDS service for SQL Server

Satheesh Kumar Thiyagarajan 1 Reputation point
2022-11-11T00:38:19.457+00:00

Between On-premise SQL server database and the AWS RDS service for SQL Server, I have set up the AWS DMS sync. Having the following problem right now. Kindly help to troubleshoot this issue. What does the error code mean in the below messages?

22-11-10T05:05:02:246333 [SOURCE_CAPTURE ]D: Connection failure error codes are: 00026,00904,10054,4060,01222,55,64,121,1231,233,109,18401,6005,40613 (provider_syntax_manager.c:2114)

2022-11-10T05:05:02:246381 [SOURCE_CAPTURE ]D: Fatal error codes are: 20028,18470 (provider_syntax_manager.c:2202)

2022-11-10T05:05:02:246389 [SOURCE_CAPTURE ]D: Table error codes are: 16943,208,11529,1904,1750,8180,207 (provider_syntax_manager.c:2173)

2022-11-10T05:05:02:246397 [SOURCE_CAPTURE ]D: Data failure error codes are: 7125,8114,6522,511 (provider_syntax_manager.c:2144)

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
515 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Takahito Iwasa 4,841 Reputation points MVP
    2022-11-14T05:14:53.86+00:00

    Hi, @Satheesh Kumar Thiyagarajan

    This error log is an error log output by AWS DMS.
    So asking a question in Microsoft Q&A is probably not appropriate.

    You should ask the community on AWS re:Post or use AWS paid support.

    0 comments No comments

  2. PandaPan-MSFT 1,911 Reputation points
    2022-11-14T05:38:07.587+00:00

    Hi @Satheesh Kumar Thiyagarajan ,
    I'm agree that it is the AWS problem. Maybe you can post questions in this link: https://iq.aws.amazon.com/services/aws/dms ( I'm not sure if it is the official web, I just search on my own)

    0 comments No comments