3166773 - Failed to fetch data when modelling Data Flow in Datasphere

Creating a data flow with ABAP source connection, folder SAP ODP Extractor shows the error below when expanding:

Correlation ID: ***
HTTP Status: 500 Internal Server Error
Error Code: getChildrenFailed
Technical Message: Failed to fetch the data. Failed to get container children for /EXTRACTORS/SAPI. Cause 1: Browse request could not be performed due to error: RFC CallReceive error . Code:99999;

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

SAP Datasphere

1. In Data Builder, creating a Data Flow
2. Select the connection under Sources
3. Expand folders, error message is displayed.

Cause 1:

Missing authorizations in the ABAP/ECC Source system user which communicates with SAP Datasphere.
You should be able to confirm that by checking authorization errors for the RFC user in the Source system backend.

Cause 2:

The required resources are not added in Cloud Connector - Cloud To On-Premise

Resolution for Cause 1:

Check out SAP Note 2855052 - Authorizations required for ODP Data Replication API 2.0.
Follow the note to maintain the required authorizations both in DP Agent and Cloud Connector, if applicable.

Check out SAP Note 2810450 - Prerequisites for ODP Extraction using SAP Data Services as reference.

Resolution for Cause 2:

Depending on the connection type, protocol, and use case, add the required resources in Cloud Connector. SAP Help Configure Cloud Connector explains authorizations need to be configured in Cloud Connector.

RFC CallReceive error, Code:99999, /EXTRACTORS/SAPI, authorization, dwc, data warehouse cloud, "getChildrenFailed" "Error in getDisConnectionChildren" "RFC CallReceive error" "Data Flow" , KBA , DS-DI-CON , Connections , DS , SAP Datasphere , Problem