Symptom
- Unable to create model on OData service exposed by CDS view with parameters through Import S/4HANA connection in SAP Analytics Cloud (SAC)
- Failed to upload data with error message:
Error 1:
---------------
status:500 body: {"error":{"code":"SY/530","message":{"lang":"en","value":"Unknown entity '$AE#CDS#<...>~*<...>' type 'SADL'"},
"innererror":{"application":{"component_id":"BC-ESI-ESF-GW","service_namespace":"/SAP/","service_id":"<...>","service_version":"0001"},
"transactionid":"<...>","timestamp":"<...>","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":[{"code":"CX_SADL_UNKNOWN_ENTITY","message":"Unknown entity '$AE#CDS#<...>~*<...>' type 'SADL'","propertyref":"","severity":"error","target":""},{"code":"CX_SADL_CONTRACT_VIOLATION","message":"The entity '*<...>' was not found","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_TECH_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}}
---------------
Error 2:
---------------
status:500 body:{"error":{"code":"SY/530","message":{"lang":"ja","value":"The entity '<...>' was not found"},"innererror":{"application":{"component_id":"FIN-FSCM-CLM","service_namespace":"/SAP/","service_id":"<...>","service_version":"0001"},"transactionid":"44E6640A04FD0120E005D08AA9BEF989","timestamp":"20190708034745.7331120","Error_Resolution":{"SAP_Transaction":"For backend administrators: 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":[{"code":"CX_SADL_CONTRACT_VIOLATION","message":"The entity '<...>' was not found","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_MED_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}}
---------------
Error 3:
---------------
status:500 body:{"error":{"code":"SY/530","message":{"lang":"ja","value":"The caller violated a precondition for a method call"},"innererror":{"application":{"component_id":"FIN-FSCM-CLM","service_namespace":"/SAP/","service_id":"<...>","service_version":"0001"},"transactionid":"44E6640A04FD0120E005D08AA9BEF98D","timestamp":"20190708034915.9854030","Error_Resolution":{"SAP_Transaction":"For backend administrators: 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":[{"code":"LCX_MISSING_PARAMETER","message":"The caller violated a precondition for a method call","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_MED_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}}
---------------
Environment
- SAP Analytics Cloud 2021.14.7
Reproducing the Issue
- Log on to SAC tenant.
- Try to create a model based on Import S/4HANA connection.
- Create a new query on the problematic custom CDS View.
- Select all or partial objects and then click Create button.
=> Upload failed with error message.
=> Unable to create model on the specific Custom CDS View.
Cause
- This is limitation of current SAC product, which does not take any URL parameters when acquiring data from S/4HANA.
Resolution
Please follow SAP KBA 2424376 to go to the SAP Analytics Cloud & SAP Digital Boardroom Customer Influence to create request a new feature, enhancement or improvement request that is not currently available in SAP Analytics Cloud (SAC).
Workaround: Use OData Service connection with Freehand query to pass any parameter you'd like to the specific OData Service from S/4HANA.
- Create an OData Service connection in the SAC to URL of the specific OData Service exposed by CDS view with parameters.
Example: https://<S/4HANA Host and port>/sap/opu/odata/sap/<OData Service Name> - Choose Freehand Query.
- Enter query to include parameters
=> Example: <EntitySet Name>(<Parameter 1 Name>='<WHATEVER-VALUE>',<Parameter 2 Name>='<WHATEVER-VALUE>')/<RESULTNAME>
=> You can also test the query firstly using the completely URL in browser according to SAP KBA 2600276 and 2688637.
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- SAP Analytics Cloud > Learning > Guided Playlists
Your feedback is important to help us improve our knowledge base.
Keywords
SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, S4, S4HC, S4HANA, Cloud, OData, CDS, Entity, service, model, query, custom, upload, failure, failed, SY/530, Unknown entity, SADL, CX_SADL_UNKNOWN_ENTITY, BC-ESI-ESF-GW, /IWFND/ERROR_LOG, parameter, Odata, URL, result, , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Product Enhancement