SAP Knowledge Base Article - Public

2685340 - Unable to retrieve the external data due to: EPM_SERVICE error while running the schedule for one model

Symptom

  • When running the schedule for one model, there is error "[Application Error]: Script error" shown in SAP Analytics Cloud (SAC).
  • The following error is shown in the System -> Monitor -> Trace screen:
    Unable to retrieve the external data due to: EPM_SERVICE : {"packageId":"sap.fpa.services.resource.dm","objectName":"message_dm","messageId":"SERVICE_NOT_RETRIEVED","args":["(HTTP 400) EPM_SERVICE : [{\"code\":\"SY_530\",\"description\":\"An exception was raised\",\"severity\":\"error\",\"log_id\":\"YbO{RpKK7jYfqjs7PPWB4G\",\"variables\":[{\"key\":\"DATA_TYPE\",\"value\":\"\"},{\"key\":\"EXPECTED\",\"value\":\"\"},{\"key\":\"FORMAT_STRING\",\"value\":\"\"},{\"key\":\"OPENING_CHAR\",\"value\":\"\"},{\"key\":\"POSITION\",\"value\":\"0 \"},{\"key\":\"RESERVED\",\"value\":\"\"}]}]"],"message":"Unable to retrieve the external data due to: (HTTP 400) EPM_SERVICE : [{\"code\":\"SY_530\",\"description\":\"An exception was raised\",\"severity\":\"error\",\"log_id\":\"YbO{RpKK7jYfqjs7PPWB4G\",\"variables\":[{\"key\":\"DATA_TYPE\",\"value\":\"\"},{\"key\":\"EXPECTED\",\"value\":\"\"},{\"key\":\"FORMAT_STRING\",\"value\":\"\"},{\"key\":\"OPENING_CHAR\",\"value\":\"\"},{\"key\":\"POSITION\",\"value\":\"0 \"},{\"key\":\"RESERVED\",\"value\":\"\"}]}]","stack":"Exception@/sap/fpa/services/core/system/Exception.xsjslib:120\nExceptionServiceProxy@/sap/fpa/services/dm/ServiceProxy.xsjslib:595\nServiceProxy.prototype._reconstructExecuteServiceResult@/sap/fpa/services/dm/ServiceProxy.xsjslib:1112\nServiceProxy.prototype._executeServiceAndReconstructResult@/sap/fpa/services/dm/ServiceProxy.xsjslib:929\nServiceProxy.prototype._executeServiceInternal@/sap/fpa/services/dm/ServiceProxy.xsjslib:1001\nServiceProxy.prototype.executeService@/sap/fpa/services/dm/ServiceProxy.xsjslib:832\nCloudConnector.prototype._addAuthorizationHeaderAndExecute@/sap/fpa/services/dm/CloudConnector.xsjslib:250\nCloudConnector.prototype.execute@/sap/fpa/services/dm/CloudConnector.xsjslib:215\nServiceProxy.prototype.startAsyncRequest@/sap/fpa/services/dm/ServiceProxy.xsjslib:1014\ninsertResults@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:452\n_schedulePrepareDataFromBPCCore@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:248\nschedulePrepareDataFromBPC@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:179\nBPC10Service.prototype.prepareDataFromBPC@/sap/fpa/services/dm/bpc/BPC10Service.xsjslib:3878\nDataIntegration.prototype.importDataFromBPCNWBySchedule@/sap/fpa/services/dm/bpc/DataIntegration.xsjslib:371\nrefreshBPCDataToModel@/sap/fpa/services/dm/schedule/BPCDataImportScheduler.xsjslib:579\ntempRunJob@/sap/fpa/services/dm/schedule/BPCDataImportScheduler.xsjslib:98\nrun@/sap/fpa/services/job/Schedule.xsjs:108\n","bUIMessage":false,"bWarning":false,"bpcRequestStatusCode":400}
  • The following error is also seen in the system log (transaction code SLG1) of the SAP NetWeaver Business Warehouse (SAP_BW) system:
    HTTP Status:400 [{"code":"SY_530","description":"An exception was raised","severity":"error","log_id":"YbO{RpKK7jYfqjs7PPWB4G","variables":[{"key":"DATA_TYPE","value":""},{"key":"EXPECTED","value":""},{"key":"FORMAT_STRING","value":""},{"key":"OPENING_CHAR","value":""},{"key":"POSITION","value":"0 "},{"key":"RESERVED","value":""}]}]

Environment

  • SAP Analytics Cloud 2018.14.2
  • SAP Business Planning and Consolidation

Reproducing the Issue

  1. Logon SAC and switch to Browser -> Models Screen.
  2. Select one Model and click DataSources.
  3. Run the schedule for this Model.

Cause

This issue is caused by an exception raised on BPC side.

Resolution

Implementing the following SAP Notes:

  • 2550738 - SY_530 error raised when select 'Base Level' in EPM Add-in report or load BPC data to SAC
  • 1858257 - How to enable SQE to support MDX member set functions

See Also

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 , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem

Product

SAP Analytics Cloud 1.0