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(1) or missing correction(2).

1. Make sure SAP Note 2203709 is implemented (Relevant for PI_BASIS from version 2005_1_700 to 740 only) or should not be relevant (already higher PI_BASIS)

   Checking on index server trace, you will find the error messages:

   DPAdapterManager AdapterManager.cpp(04549) : ::sendMessage: No BAdI implementation for subscriber type 'HANA_SDI'
   FedTrace DPAdapterAccess.cpp(02466) : DPAdapterAccess::BrowseMetadata: failed with error: No BAdI implementation for subscriber type 'HANA_SDI'

   That indicates the SAP Note 2203709 is missing in Datasphere's source system. Implement the note.

2. For Unsufficient authorizations 

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

• Authorizations

NOTE: This solution is NOT relevant for Connection Type "S/4HANA Cloud"
For S/4HANA Cloud connections, check out KBA 3381575 - Error getChildrenFailed for remote tables of S/4HANA Cloud in SAP Datasphere

• 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