2647627 - Error: Unable to retrieve the external data due to: SERVICE_NOT_RETRIEVED / UJO_WB_EXCEPTION_011 / Error obtaining concurrency lock (foreign_lock) when exporting data from SAP Analytics Cloud into a BPC model

SAP Knowledge Base Article - Public

2647627 - Error: Unable to retrieve the external data due to: SERVICE_NOT_RETRIEVED / UJO_WB_EXCEPTION_011 / Error obtaining concurrency lock (foreign_lock) when exporting data from SAP Analytics Cloud into a BPC model

Symptom

The following errors occur when you try to export data from SAP Analytics Cloud into a BPC model:

Unable to retrieve the external data due to: 4_{"packageId":"sap.fpa.services.resource.dm","objectName":"message_dm","messageId":"SERVICE_NOT_RETRIEVED"

Full error:

Unable to retrieve the external data due to: 4_{"packageId":"sap.fpa.services.resource.dm","objectName":"message_dm","messageId":"SERVICE_NOT_RETRIEVED","args":["(HTTP 500) 4_<?xml version=\"1.0\" encoding=\"utf-8\"?><CustomApplicationMessages xmlns=\"http://xml.sap.com/2010/02/bpc\"><CustomApplicationMessage><code>UJO_WB_EXCEPTION_011</code><description>Error obtaining concurrency lock (foreign_lock)</description><severity>error</severity><log_id>hbEHjuSK7jYNr{qYqa{VWG</log_id><variables><variable><key>APPL_STORAGE_TYPE</key><value/></variable><variable><key>ERROR_REASON</key><value>foreign_lock</value></variable><variable><key>MEASURE_FORMULA</key><value/></variable></variables></CustomApplicationMessage></CustomApplicationMessages>"],"message":"Unable to retrieve the external data due to: (HTTP 500) 4_<?xml version=\"1.0\" encoding=\"utf-8\"?><CustomApplicationMessages xmlns=\"http://xml.sap.com/2010/02/bpc\"><CustomApplicationMessage><code>UJO_WB_EXCEPTION_011</code><description>Error obtaining concurrency lock (foreign_lock)</description><severity>error</severity><log_id>hbEHjuSK7jYNr{qYqa{VWG</log_id><variables><variable><key>APPL_STORAGE_TYPE</key><value/></variable><variable><key>ERROR_REASON</key><value>foreign_lock</value></variable><variable><key>MEASURE_FORMULA</key><value/></variable></variables></CustomApplicationMessage></CustomApplicationMessages>","stack":"Exception@/sap/fpa/services/core/system/Exception.xsjslib:120\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:920\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\nBPC10Service.prototype.exportData@/sap/fpa/services/dm/bpc/BPC10Service.xsjslib:2147\nDataIntegration.prototype.exportData@/sap/fpa/services/dm/bpc/DataIntegration.xsjslib:111\nRestDataIntegration.prototype.doPost@/sap/fpa/services/dm/RestDataIntegration.xsjslib:242\nhandleRequest@/sap/fpa/services/GetResponse.xsjs:535\n@/sap/fpa/services/GetResponse.xsjs:584\n","bUIMessage":false,"bWarning":false,"bpcRequestStatusCode":500}

Environment

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

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 , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0