SAP Knowledge Base Article - Public

3757354 - SAP datasphere - unable to select ODP extractors as source in data flows when using BW connection

Symptom

  • Issues occur when using BW connection to create a data flow, choosing ODP extractors as source.
  • The data flow is enabled when validating the BW connection.
  • HTTP Status: 500 Internal Server Error. Error Code: getChildrenFailed. Error message: "Failed to fetch the data. Error in getDisConnectionChildren. Failed to get container children for /. Cause 1: request failed: rc=1, msg="Message: Opening connection to backend failed: Opening connection to ctcsaptc4ci.uk.centricaplc.com:sapgw00 denied. Expose the system in your Cloud Connector in case it was a valid request.\nCode: RFC_COMMUNICATION_FAILURE" Code:99999;"

Environment

SAP Datasphere

SAP BW

Reproducing the Issue

  1. Create a BW connection in SAP Datasphere and validate the connection.
  2. In a data flow, attempt to select ODP extractors under 'Sources'.
  3. Observe the failure with HTTP 500 and getChildrenFailed error.

Cause

Missing required resources in SAP Cloud Connector.

Resolution

In SAP Cloud Connector, add the following required resources for RFC connection:

  • /SAPDS/ (Prefix)
  • RFC_FUNCTION_SEARCH
  • RODPS_REPL_ (Prefix)

See Also

Configure Cloud Connector

Keywords

getChildrenFailed, RFC CallReceive error, 500 Internal Server Error, DS-Lite, /EXTRACTORS/SAPI, BW connection, cloud connector, /SAPDS/, RFC_FUNCTION_SEARCH, RODPS_REPL_, data flow, browse extractors, on-premise, resources , KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere 1.0