AWS DMS replication instance upgraded to 3.5 and end point failing - Failed to get a table defination

Question

After upgrading an existing DMS replication instance to 3.5
an existing oracle source endpoint which was working pre upgrade is now encountering :

Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to get a table definition.

The login is a non admin login, it appears to be a missing permission post replication instance upgrade and / or a bug.
The endpoint works if I use an admin login (which I don't want to be using)
Please advise.
ty

Accepted Answer

Many thanks when I added below to the non master user , the end point now works:

GRANT SELECT ON V_$SESSION TO myuser;
GRANT SELECT ON V_$MYSTAT TO myuser;

GRANT SELECT ON GV_$SESSION TO myuser;

Answer

Hello,

Currently, there is an issue identified with DMS Replication Instance version 3.5 leading to endpoint failure for Oracle as source with the following error:

“Test Endpoint failed: Application-Status: 1020912, Application-Message: Failed to get a table definition.”

The issue is specific to non-master users. You can grant the following privileges to your non-master user and test the endpoint connection.

```
GRANT SELECT ON GV$SESSION TO Username; 
GRANT SELECT ON V$MYSTAT TO Username;  
```
While ensuring required privileges are granted to the user -

[+] https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html#CHAP_Source.Oracle.Self-Managed

Alternatively, for time being, you may use the master user until the issue is fixed by the AWS internal team.

Thank you

AWS DMS replication instance upgraded to 3.5 and end point failing - Failed to get a table defination

Relevant content