2407230 - Unable to retrieve the external data due to: EPM_SERVICE error / exception in SAP Analytics Cloud

SAP Knowledge Base Article - Public

2407230 - Unable to retrieve the external data due to: EPM_SERVICE error / exception in SAP Analytics Cloud

Symptom

When you try to import an SAP Business Planning and Consolidation, version for SAP NetWeaver (BPC NW) model into SAP Analytics Cloud, the following errors appear:

  • Unable to retrieve the external data due to: EPM_SERVICE:
    "packageId":"sap.fpa.services.resource.dm","objectName":"message_dm","messageId":"SERVICE_NOT_RETRIEVED","args":["EPM_SERVICE : <HTML><HEAD>"],
    "message":"Unable to retrieve the external data due to: EPM_SERVICE : <HTML><HEAD>","stack":"Exception@/sap/fpa/services/core/system/Exception.xsjslib:102\nExceptionServiceProxy@/sap/fpa/services/dm/ServiceProxy.xsjslib:502\n@/sap/fpa/services/dm/ServiceProxy.xsjslib:742\n@/sap/fpa/services/dm/CloudConnector.xsjslib:173\nschedulePrepareDataFromBPC@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:209\nrun@/sap/fpa/services/job/Schedule.xsjs:102\n","bUIMessage":false,"bWarning":false

    Unable to retrieve the external data due to EPM_SERVICE.jpg
  • <TITLE>500 SAP Internal Server Error</TITLE></HEAD><BODY><H1>500 SAP Internal Server Error</H1> ERROR: Access using a &#39ZERO&#39: object reference is not possible. (termination: RABAX_STATE)<P></BODY></HTML> "message":"External source system terminated the import request due to data size limit: (HTTP 500) <HTML><HEAD> <TITLE>500 SAP Internal Server Error</TITLE> </HEAD> <BODY> <H1>500 SAP Internal Server Error</H1> ERROR: Access using a &#392ERO&#39; object reference is not possible. (termination: RABAX_STATE)

    29-Sep-17 5-23-32 PM-1.png

  • External source system terminated the import request due to data size limit: packageld":"sapipa.servicessesource.dm","object

    29-Sep-17 5-23-32 PM-2.png

  • External source system terminated the import request due to data size limit: EPM_SERVICE : {"packageId":"sap.fpa.services.resource.dm","objectName":"message_dm","messageId":"DATA_IMPORT_TERMINATED_BY_EXTERNAL_LIMIT","args":["(HTTP 500) EPM_SERVICE : <HTML><HEAD> <TITLE>500 SAP Internal Server Error</TITLE> </HEAD><BODY> <H1>500 SAP Internal Server Error</H1> ERROR: No more memory available to add rows to an internal table. (termination: RABAX_STATE)<P> </BODY></HTML> "],"message":"External source system terminated the import request due to data size limit: (HTTP 500) EPM_SERVICE : <HTML><HEAD> <TITLE>500 SAP Internal Server Error</TITLE> </HEAD><BODY> <H1>500 SAP Internal Server Error</H1> ERROR: No more memory available to add rows to an internal table. (termination: RABAX_STATE)<P> </BODY></HTML> ","stack":"Exception@/sap/fpa/services/core/system/Exception.xsjslib:123\nExceptionServiceProxy@/sap/fpa/services/dm/ServiceProxy.xsjslib:583\nServiceProxy.prototype._reconstructExecuteServiceResult@/sap/fpa/services/dm/ServiceProxy.xsjslib:1098\nServiceProxy.prototype._executeServiceAndReconstructResult@/sap/fpa/services/dm/ServiceProxy.xsjslib:917\nServiceProxy.prototype._executeServiceInternal@/sap/fpa/services/dm/ServiceProxy.xsjslib:989\nServiceProxy.prototype.pollAsyncResponse@/sap/fpa/services/dm/ServiceProxy.xsjslib:1012\ninsertResults@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:361\n_schedulePrepareDataFromBPCCore@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:180\n_resumeSchedulePrepareDataFromBPC@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:135\nAsyncPrepareDataTask.prototype.run@/sap/fpa/services/dm/bpc/BPC10ServiceSchedule.xsjslib:860\n_runTaskOnce@/sap/fpa/services/async/TaskManager.xsjslib:68\n_runTask@/sap/fpa/services/async/TaskManager.xsjslib:50\n_runScheduledTask@/sap/fpa/services/async/TaskManager.xsjslib:33\n_runScheduledTask@/sap/fpa/services/async/TaskManager.xsjslib:220\nrun@/sap/fpa/services/job/Schedule.xsjs:108\n","bUIMessage":false,"bWarning":false,"bpcRequestStatusCode":500}

In the case of a BPC for NetWeaver (BPC NW) system, the following error message appears in transaction code ST22:

  • Runtime Error: TSV_TNEW_PAGE_ALLOC_FAILED
  • Terminated Program: CL_UJO_QRES_TRANS

  • Runtime Error: TSV_TNEW_PAGE_ALLOC_FAILED
  • Terminated Program: CL_RSR_MDX_OLAP_REQUEST

Environment

  • SAP Analytics Cloud

Reproducing the Issue

Import a model from a BPC NW model data source.

Cause

  • An out of memory condition occurred in the source SAP NetWeaver system. The BPC NW internal table was filled / exhausted before it could send the data to SAP Analytics Cloud.
  • The default internal table size is 1 million records.

Resolution

Increase the memory parameters:

  • ztta/roll_extension
  • abap/heap_area_total
  • abap/heap_area_dia
  • abap/heap_area_nondia
  • rdisp/PG_MAXFS

See SAP Note 1322182 - Memory consumption of ABAP Shared Objects and the following page for more information:

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, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, ERROR: No more memory available to add rows to an internal table. (termination: RABAX_STATE), CL_UJO_QRES_TRANS=======CP, CL_RSR_MDX_OLAP_REQUEST=======CP , KBA , rabax_state , rows to an internal table. (termination: , no more memory available to add , ms, microsoft bpcms, bpcnw , error importing data from bpc to sac , service_not_retrieved sac , bpc , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0