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