DMS Error Starting New Replication Task in STAGE

Question

Greetings, an error has been encountered that has not been seen before. I could not find anything on google so I am hoping someone here can help. This happens when we start a new DMS task.

Source Endpoint: on-prem SQL Server Instance 
Target Endpoint: RDS SQL Server Instances

```
2024-04-29T18:26:57 [SOURCE_CAPTURE  ]E:  Failure in approving stored functions presence [1020101]  (sqlserver_endpoint_capture.c:372)
```

![Enter image description here](/media/postImages/original/IMR20oCY0sRXy4RLKEMTIv3Q)

Accepted Answer

this message it is unable to identify if the source sql server node is primary or secondary read replica. 
if your database is not part of alwaysonavailability group then you can ignore this message else check if endpoint login/user has permissions to query following system objects.

sys.availability_groups_cluster 
sys.dm_hadr_availability_replica_cluster_states 
sys.dm_hadr_availability_replica_states 
sys.availability_replicas 
sys.dm_hadr_availability_group_states

DMS Error Starting New Replication Task in STAGE

Relevant content