SAP Knowledge Base Article - Public

3774155 - Datasphere - Not able to fetch data via Generic OData connection when creating a Data Flow

Symptom

The Generic OData connection validation is fine, but not able to fetch data when creating a Data Flow. Error message:

Failed to fetch data preview.We can provide the following information to assist either you or an SAP engineer to solve the issue:

HTTP Status: 500 error
Error Code: getDataSetFailed
Technical Message: Failed to fetch the data. Error in getDataSet. Failed to get dataset data for /XXX. Cause 1: HTTP/1.1 403 Forbidden{"error":{"code":"XXX","message":{"lang":"en","value":"You do not have start authorization for XXX, return code 4"},"innererror":{"application":{"component_id":"CA-CPD-SS","service_namespace":"/CPD/","service_id":"XXX","service_version":"0001"},"transactionid":"XXX","timestamp":"XXX","Error_Resolution":{"SAP_Transaction":"For backend administrators: use ADT feed reader \"SAP Gateway Error Log\" or run transaction /IWFND/ERROR_LOG on SAP Gateway hub system and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"ContentID":"","code":"CX_NO_… do not have start authorization for XXX, return code 4","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IWBEP/CX_MGW_TECH_EXCEPTION","message":"User does not have the sufficient authorizations","propertyref":"","severity":"error","transition":false,"target":""}]}}} Code:99999;
  

Environment

SAP Datasphere

Reproducing the Issue

  1. Open SAP Datasphere and create a new Data Flow in the target Space.
  2. Select the Generic OData connection, try to preview source data

Cause

The OData API version(v2/v4) configured in Datasphere connection panel is not right.

Resolution

Verify the OData API version and check the configuration in Datasphere connection panel.

Keywords

Datasphere, Generic OData connection, Data Flow, OData V2, OData V4, 403 Forbidden, getDataSetFailed, /IWBEP/CM_MGW_RT/000, authorization, IWSV, S/4HANA API, data preview, CPD service , KBA , DS-DI-DF , Data Flow Runtime , Problem

Product

SAP Datasphere 1.0