SAP Knowledge Base Article - Public

3492293 - Error "Entity Set Name does not exist" when creating Data Flow from Cloud Data Integration connection

Symptom

During a new Data Flow creation on a Cloud Data Integration type connection (integration with SAP Analytics Cloud (SAC)) similar error message pops up as below:

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: xxxxxxxxxxxxxxxxxxxxxxxxxxx
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: {"error":{"code":"xxxxxxxxxxxxxxxxxxxxxxxxxxx","message":"Entity Set Name does not exist [3707]"}}null [HTTP/1.1 400 Bad Request] Code:xxxxx;
Cause 2: {"error":{"code":"xxxxxxxxxxxxxxxxxxxxxxxxxxx","message":"Entity Set Name does not exist [3707]"}}null [HTTP/1.1 400 Bad Request] Code:xxxxx;

Environment

SAP Datasphere

SAP Analytics Cloud 

Reproducing the Issue

  1. Data Builder:
  2. Create new Data Flow
  3. Expand: Sources -> Connections and select the CDI type connection

Cause

The URL is not following the mandatory pattern:

https://my-sac-tenant.eu10.sapanalytics.cloud/api/v1/dataexport/administration

Resolution

Correct the URL as per SAP Datasphere Community blog post: Using the SAC Data Export API with Datasphere and Data Intelligence.
The relevant part is Section #3. SAP Datasphere.

It must follow the pattern: https://my-sac-tenant.eu10.sapanalytics.cloud/api/v1/dataexport/administration

Keywords

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

Product

SAP Datasphere all versions

Attachments

Pasted image.png
Pasted image.png