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":""}]}]
Read more...
Environment
- SAP Analytics Cloud 2018.4.1
- SAP Business Planning and Consolidation, version for SAP NetWeaver
Product
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview