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 data from an SAP Business Planning and Consolidation, version for SAP NetWeaver (BPC NW) model into SAP Analytics Cloud, one or more of the following errors occur:

  • 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
  • <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)

  • External source system terminated the import request due to data size limit: EPM_SERVICE : {packageld":"sap.fpa.services.resource.dm","objectName":message_r["(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> <JBODY> </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<HTML> </HEAD> <BODY> <H1,500 SAP Internal Server Error<1H1> 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
  • External source system terminated the import request due to data size limit: packageld":"sapipa.servicessesource.dm","object

  • 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}
  • Unable to retrieve the external data due to: (HTTP 400) EPM_SERVICE :...
    Unable to retrieve the external data due to: EPM_SERVICE :...
    EPM_SERVICE : {"packageId":"sap.fpa.services.resource.dm","objectName":"message...

The following error messages will also appear in transaction code ST22 on the BPC NetWeaver system:

  • 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 SAP NetWeaver 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:

You may also need to install the following SAP Note 2484356 - Support InfoCube type for delta service

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 , bpc , rabax , service_not_retrieved sac , error importing data from bpc to sac , error rabax sac sap analytics cloud , rows to an internal table. (termination: , rabax_state , no more memory available to add , ms, microsoft bpcms, bpcnw , 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