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
- Open SAP Datasphere and create a new Data Flow in the target Space.
- 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
SAP Knowledge Base Article - Public