SAP Knowledge Base Article - Public

2617519 - Error: Unable to retrieve the external data due to SERVICE_NOT_RETRIEVED SY530 An exception was raised UJ0_EXCEPTION_005 SY_530 when Importing a BPC model into SAP Analytics Cloud

Symptom

The following errors occurs when you try to import a BPC model into SAP Analytics Cloud:

Unable to retrieve the external data due to SERVICE_NOT_RETRIEVED UJ0_EXCEPTION_005

Full error:

Unable to retrieve the external data due to: S{"packageId":"sap.fpa.services.resource.dm","objectName":"message_dm","messageId":"SERVICE_NOT_RETRIEVED","args":["(HTTP 400) S[{\"code\":\"SY530\",\"description\":\"An exception was raised\",\"severity\":\"error\",\"log_id\":\"051MY3G47kY6vSqv4p51SG\",\"variables\":[{\"key\":\"DATAVALUE\",\"value\":\"\"},{\"key\":\"MDX\",\"value\":\"\"},{\"key\":\"V1\",\"value\":\"\"},{\"key\":\"V2\",\"value\":\"\"},{\"key\":\"V3\",\"value\":\"\"},{\"key\":\"V4\",\"value\":\"\"}]},{\"code\":\"UJ0_EXCEPTION_005\",\"description\":\"An exception was raised   \",\"severity\":\"error\",\"log_id\":\"051MY3G47kY6vSqv4p51SG\",\"variables\":[{\"key\":\"FUN_NAME\",\"value\":\"\"},{\"key\":\"OBJ_NAME\",\"value\":\"\"}]}]"],"message":"Unable to retrieve the external data due to: (HTTP 400) S[{\"code\":\"SY_530\",\"description\":\"An exception was raised\",\"severity\":\"error\",\"log_id\":\"051MY3G47kY6vSqv4p51SG\",\"variables\":[{\"key\":\"DATAVALUE\",\"value\":\"\"},{\"key\":\"MDX\",\"value\":\"\"},{\"key\":\"V1\",\"value\":\"\"},{\"key\":\"V2\",\"value\":\"\"},{\"key\":\"V3\",\"value\":\"\"},{\"key\":\"V4\",\"value\":\"\"}]},{\"code\":\"UJ0_EXCEPTION_005\",\"description\":\"An exception was raised\",\"severity\":\"error\",\"log_id\":\"051MY3G47kY6vSqv4p51SG\",\"variables\":[{\"key\":\"FUN_NAME\",\"value\":\"\"},{\"key\":\"OBJ_NAME\",\"value\":\"\"}]}]","stack":"Exception@/sap/fpa/services/core/system/Exception.xsjslib:123\nExceptionServiceProxy@/sap/fpa/services/dm/ServiceProxy.xsjslib:574\nServiceProxy.prototype._reconstructExecuteServiceResult@/sap/fpa/services/dm/ServiceProxy.xsjslib:1091\nServiceProxy.prototype._executeServiceAndReconstructResult@/sap/fpa/services/dm/ServiceProxy.xsjslib:908\nServiceProxy.prototype._executeServiceInternal@/sap/fpa/services/dm/ServiceProxy.xsjslib:980\nServiceProxy.prototype.executeService@/sap/fpa/services/dm/ServiceProxy.xsjslib:811\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:993\ninsertResults@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:375\n_schedulePrepareDataFromBPCCore@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:181\nschedulePrepareDataFromBPC@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:112\nAsyncPrepareDataTask.prototype.run@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:861\n_runTaskOnce@/sap/fpa/services/async/TaskManager.xsjslib:68\n_runTask@/sap/fpa/services/async/TaskManager.xsjslib:50\nexecuteNow@/sap/fpa/services/async/TaskManager.xsjslib:23\nBPC10Service.prototype.prepareDataFromBPC@/sap/fpa/services/dm/bpc/BPC10Service.xsjslib:3570\nDataIntegration.prototype.prepareDataFromBPC@/sap/fpa/services/dm/bpc/DataIntegration.xsjslib:220\nRestDataIntegration.prototype.doPost@/sap/fpa/services/dm/RestDataIntegration.xsjslib:456\nhandleRequest@/sap/fpa/services/GetResponse.xsjs:535\n@/sap/fpa/services/GetResponse.xsjs:584\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:

External ID: <Environment>;<Model>;CL_UJXO_QUERY

HTTP Status:400
[{"code":"SY_530","description":"An exception was raised","severity":"error","log_id":"051MY3G47kY6vQIqLZs1FG","variables":[{"key":"DATAVALUE","value":""},{"key":"MDX","value":""},{"key":"V1","value":""},{"key":"V2","value":""},{"key":"V3","value":""},{"key":"V4","value":""}]},{"code":"UJ0_EXCEPTION_005","description":"An exception was raised","severity":"error","log_id":"051MY3G47kY6vQIqLZs1FG","variables":[{"key":"FUN_NAME","value":""},{"key":"OBJ_NAME","value":""}]}]

Environment

  • SAP Analytics Cloud 2018.4.1
  • SAP Business Planning and Consolidation, version for SAP NetWeaver

Cause

An unsupported virtual InfoCube was added to the standard BPC generated multiprovider.

Resolution

Remove all unsupported custom virtual InfoCubes from the standard BPC generated multiprovider.

In the Data Warehousing Workbench modelling screen (transaction code RSA1) , your BPC model (BW multiprovider) should appear as follows (Using the Planning model in EnvironmentShell as an example):

Business Planning and Consolidation /CPMB/BPC Technical Name

Environment Shell /CPMB/ENVIRONMENTSHELL Technical Name

Planning (Infocube)

Planning (MultiProvider)

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, 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,multi-provider. , KBA , customer getting below error when trying , to import data from bpc , an error dump within bpc is here. , 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