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
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
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 , to import data from bpc , customer getting below error when trying , 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