3381575 - Error getChildrenFailed for remote tables of S/4HANA Cloud in SAP Datasphere

Error happens when validating S/4HANA Cloud Connection, or using remote tables in Data Builder of 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

SAP Datasphere

SAP S/4HANA Cloud

S/4HANA Cloud IP/Domain are not reachable from DPAgent client.

First of all, check DPAgent logs (framework.trc log file) right after validating the connection. The trace can indicate the following:

ODataV4Handler | ODataV4Handler.connectToSource [] - Failed to get odata metadata from https://XXXXXXXXX-api.s4hana.cloud.sap/sap/opu/odata4/sap/cdi/default/sap/cdi/0001/$metadata,
remote exception: org.apache.olingo.client.api.http.HttpClientException: org.apache.http.conn.HttpHostConnectException: Connect to XXXXXXXXX-api.s4hana.cloud.sap:443 [XXXXXXXXX-api.s4hana.cloud.sap/IP]
failed: error 110 - Connection timed out (Connection timed out) (local port XXXXX to address 0.0.0.0, remote port 443 to address IP)","framework_alert.trc"

Make sure OData API URL is reachable from DPAgent client machine.

KBA , DS-DI-CON , Connections , Known Error