3472395 - SAP Datasphere-Error opening the cursor for the remote database

When trying to access remote table using the SAP ABAP connection while streaming is enabled, the replication is failed with the error:

Error: {"timestamp":20XX-XX-XX XX:XX:XX.XXXXXXX,"origin":"_sys_task","message":"internal error:}Error opening the cursor for the remote database,Processing terminated.

SAP Datasphere

Authorization issue.

Ensure the authorization object S_SDSPGMCK is assigned to the user in addition to the Authorizations.

3333691 - Datasphere remote table DPAgent authorization missing

S_SDSPGMCK, datasphere, remote table, DPAgent authorization , KBA , DS-DI-RT , Remote Tables , Problem