SAP Knowledge Base Article - Public

3147640 - Unable to export Model as File due to Memory Error in SAP Analytics Cloud

Symptom

  • Get the following error while trying to export the model data as file:
    EPM_SERVICE : dberror(PreparedStatement.executeUpdate): 2 - general error: Remote export failed: export size exceeds 20% of available memory, please use server-local export.
    executeUpdate@/sap/fpa/services/core/db/CommonDbConnection.xsjslib:521:19
    Connection.prototype.executeUpdate@/sap/fpa/services/core/db/DbAsHdbConnection.xsjslib:174:88
    DataIntegrationDataAccess.prototype.executeUpdate@/sap/fpa/services/dm/DataIntegrationDataAccess.xsjslib:2183:23
    exportTableToCsvBlob@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:1119:9
    RestExportModelHana.prototype.exportCsvToFile@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:129:28
    _exportCsvToFile@/sap/fpa/services/dm/schedule/CSVDataExportJobAction.xsjslib:134:28
    ExportCSVToFileTask.prototype.run@/sap/fpa/services/dm/schedule/CSVDataExportJobAction.xsjslib:571:32
    _runTaskOnce@/sap/fpa/services/async/TaskManager.xsjslib:87:30
    _runTask@/sap/fpa/services/async/TaskManager.xsjslib:69:42
    executeNow@/sap/fpa/services/async/TaskManager.xsjslib:17:79
    CSVDataExportJobAction.prototype.execute@/sap/fpa/services/dm/schedule/CSVDataExportJobAction.xsjslib:90:9
    run@/sap/fpa/services/job/Schedule.xsjs:140:21
  • It may work when exporting 2 or 3 models. Then the issue might start to happen. After it happens, no model can be exported.
  • The issue might disappear sometimes but will happen again randomly.

Environment

  • SAP Analytics Cloud Enterprise(SAC)

Reproducing the Issue

  1. Open a model and go to Data Management.
  2. In Export jobs, choose Export Model As File and click Create New Schedule.
  3. Choose a Folder and click Export. The error will show.

Cause

  • The error is showing the backend HANA system running out of memory.

Resolution

Please create a support case under the component LOD-ANA-ADM to solve it.

Keywords

KBA , LOD-ANA-XUS , User assistance, performance statistics , LOD-ANA-ADM , SAC Administration , Problem

Product

SAP Analytics Cloud 1.0