Error using Aurora Postgres version 11.8 as DMS source endpoint
We had a DMS source endpoint that was connecting to an Aurora Postgres 10.7 database and it was working fine. We upgraded the database to Aurora Postgres 11.8 and now the endpoint connection test is failing. A DMS target to the same database is working fine, so it appears the replication instance is setup correctly. The error message is:
Test Endpoint failed: Application-Status: 1020912, Application-Message: Failure in resolving database version. ODBC general error., Application-Detailed-Message: Failed retrieve database backend version RetCode: SQL_ERROR SqlState: XX000 NativeError: 1 Message: ERROR: rds_activity_stream stack item 9 not found on top - cannot pop; Error while executing the query Failed (retcode -1) to execute statement
Is Aurora Postgres 11.8 supported as a source by DMS?
Edited by: mnpete on Nov 19, 2020 7:16 AM
I found the problem. It appears that DMS source endpoints don't work when the activity stream is enabled. After disabling the activity stream I was able to successfully test the source endpoint.
DMS service for aurora postgres doesnt accept a view as source for full load processasked 2 months ago
PostgresRDS 9.4.20 AWS DMS source pglogical shared_preload_libraries paramAccepted Answerasked 3 years ago
DMS - Elasticsearch as target - Failed to connect to database.asked 10 months ago
aurora serverless as source and destination for DMSAccepted AnswerMODERATORasked 2 years ago
does AWS DMS support partition tables from postgresasked 5 months ago
Support for RDS Oracle as source while using DMS SCN for CDCAccepted Answerasked 4 years ago
DMS - When to switch the application to the new target databaseAccepted Answerasked 4 months ago
Phantom Update on Aurora Postgres from AWS DMS Replication from SQL Server Sourceasked 3 months ago
AWS DMS migration task doesn't automatically increment the source tableAccepted Answerasked 2 years ago
Error using Aurora Postgres version 11.8 as DMS source endpointasked 2 years ago