SAP Knowledge Base Article - Public

3471888 - Error when use the sources of S/4 HANA Connection in Data Flow in Datasphere

Symptom

When create a new Data Flow in Datasphere, open Source tab and expand the S/4 HANA Connection to load the resources, below error occurs:

An error occurred while accessing the connection. Open the "Connection" app in the side navigation panel, validate the connection, and view the details. If you do not have access to the "Connection" app, please contact your administrator.
We can provide the following information to assist either you or an SAP engineer to solve the issue:
Correlation ID: XXX
HTTP Status: 500 error
Error Code: getChildrenFailed
Technical Message: Failed to fetch the data. Error in getDisConnectionChildren. Failed to get container children for /. Cause 1: request failed: =1, msg='invalid endpoint" Code:99999;

But, there is not any error when validate the connection.

The same error occurs when use an ABAP connection or when use Replication Flow.

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

Environment

SAP Datasphere

Reproducing the Issue

  1. Create a new Data Flow in Data Builder.
  2. Open Source tab.  
  3. Expand the S/4 HANA Connection to load the resources.
  4. Error occurs.

Cause

Authorization is missing for the user in S/4 HANA system.

Resolution

  1. Logon the S/4 HANA system with the same user which is used in the S/4 HANA Connection.
  2. Run transaction code SU53.
  3. Reproduce the issue in Datasphere.
  4. In SU53, an entry with Result of "Authorization Check: No authorization in user master record" was generated with below details:
    Type of Application: RFC Function Module 
    Application Name: DHAMB_SERVICE_SYSTEM
    Authorization Object: S_DHAMBACT
    Field 1: DHAMB_ACVT
    Value 1: ES
  5. Assign the missing authorization to the user.

See Also

  • SAP Note 2831756 - SAP Data Intelligence / SAP Datasphere - ABAP Integration - Security Settings
  • SAP Note 2981615 - SAP Data Intelligence / SAP Datasphere - ABAP Integration - Security Settings
  • SAP Note 3100673 - SAP Data Intelligence / SAP Datasphere - ABAP Integration - Security Settings

Keywords

HTTP 500, HTTP 500 error, no authorization , KBA , DS-DI-CON , Connections , DS-DI-DF , Data Flows , DS-DI-RF , Replication Flows , CA-DI-IS-ABA-APE , ABAP Integration - ABAP Pipeline Engine , Problem

Product

SAP Datasphere all versions

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png