Symptom
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
Environment
SAP Datasphere
Reproducing the Issue
1. Go to app Data Builder -> Import Remote Tables
2. Select the SAP BW/ECC/ABAP connection and expand folders
3. Or validating connection
Cause
Unsufficient authorizations.
Resolution
Make sure the maintained credentials (User from ABAP source) in the connection has sufficient authorizations:
See Also
Keywords
"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