Symptom
Using ODATA connection type with parameterized API is not working during Data Preview of creation of new Data Flow:
parameterized API example: /sap/opu/odata/sap/XYZ/XYZAPI(xxx='xxxx',xxxx='xxxx')
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:
Correlation ID: xxxxx
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 400 Bad Request{"error":{"code":"CX_SADL_GW_PARAMETER_ENTITY","message":{"lang":"en","value":"Entity 'xxx': Parameter entity set 'xxx' cannot be used for read"},"innererror":{"application":{"component_id":"BC-ESI-ESF-GW","service_namespace":"/SAP/","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_SADL_GW_PARAMETER_ENTITY","message":"Entity 'xxx': Parameter entity set 'xxx' cannot be used for read","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IWBEP/CX_MGW_BUSI_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","transition":false,"target":""}]}}} Code:99999;
Correlation ID: xxxxx
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 400 Bad Request{"error":{"code":"CX_SADL_GW_PARAMETER_ENTITY","message":{"lang":"en","value":"Entity 'xxx': Parameter entity set 'xxx' cannot be used for read"},"innererror":{"application":{"component_id":"BC-ESI-ESF-GW","service_namespace":"/SAP/","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_SADL_GW_PARAMETER_ENTITY","message":"Entity 'xxx': Parameter entity set 'xxx' cannot be used for read","propertyref":"","severity":"error","transition":false,"target":""},{"ContentID":"","code":"/IWBEP/CX_MGW_BUSI_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","transition":false,"target":""}]}}} Code:99999;
Read more...
Environment
SAP Datasphere
Product
SAP Datasphere all versions
Keywords
KBA , DS-DI-DF , Data Flows , CA-DI-IS-FA , Flow Agent , DS-BB-ODATA , To address issues related to Odata consumption API , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.