3202766 - Error getChildrenFailed for remote tables in SAP Datasphere

Error happens when validating connection, or using remote tables from ABAP based source system connection ( SAP BW/SAP ABAP/ SAP ECC/SAP S/4HANA) in SAP Datasphere.

HTTP Status: 500 Internal Server Error
Error Code: getChildrenFailed
Technical Message: internal error: Cannot get remote source objects: Could not get tables, Code: 403, SQL State: HY000

OR

- Remote tables are partially available for this connection.

Data Flows: The connection hasn't been configured to use cloud connector, edit the connection and complete the cloud connection properties to be able to use data flows.
Remote Tables: Probably authorizations are missing from ABAP tables: internal error: cannot get remote source objects: Could not get tables, code 403, SQL State: HY000

SAP Datasphere

1. Go to app Data Builder ->  Import Remote Tables

2. Select the SAP BW/ECC/ABAP connection and expand folders

3. Or validating connection

Unsufficient authorizations.

Make sure the maintained credentials (User from ABAP source) in the connection has sufficient authorizations:

• Authorizations

• SAP Help - Prepare Connectivity to SAP ABAP Systems
• SAP Help - Prepare Connectivity to SAP BW
• SAP Help - Prepare Connectivity to SAP ECC
• SAP Help - Prepare Connectivity to SAP S/4HANA On-Premise
• SAP Help - Authorizations

"Cannot get remote source objects" "Could not get tables" "getChildrenFailed", dwc, data warehouse cloud, proper, Internal Server Error, getChildrenFailed, code 403, DQL State:HY000, SQL State: HY000, Could not get tables, authorizations, missing, ABAP Tables, ABAP adapter, dwc, data warehouse cloud , KBA , DS-DI-CON , Connections , How To