SAP Knowledge Base Article - Public

2781481 - Unable to create model on OData service exposed by CDS view with parameters through Import S/4HANA connection in SAP Analytics Cloud (SAC)

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

  1. Log on to SAC tenant.
  2. Try to create a model based on Import S/4HANA connection.
  3. Create a new query on the problematic custom CDS View.
  4. 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.

  1. 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>
  2. Choose Freehand Query.
  3. 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

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

Product

SAP Analytics Cloud 1.0