SAP Knowledge Base Article - Preview

3545056 - Getting database error when adding a new column in the model in SAP Analytics Cloud (SAC)

Symptom

Getting database errors when adding a column using expression editor in the model in SAC:

  • dberror(PreparedStatement.executeQuery): 2048 - column store error: search table error: [1000002] Allocation failed ; $size$=2491580168; $name$=expr; $type$=pool; $inuse_count$=302; $allocated_size$=140034786024; $alignment$=8; $failure_type$=STATEMENT_MEMORY_LIMIT; $failure_flag$=
    Correlation ID: 26175877-1612-4658-8895-391157658392
  • dberror(PreparedStatement.executeQuery): 4 - cannot allocate enough memory: search table error: [9] Memory allocation failed;exception 1000002: Allocation failed ; $size$=2467479680; $name$=JEPreAggregate; $type$=pool; $inuse_count$=43; $allocated_size$=47291754464; $alignment$=8; $failure_type$=STATEMENT_MEMORY_LIMIT; $failure_flag$=
    Correlation ID: 33993338-5624-4917-8358-380900765637


Read more...

Environment

  • SAP Analytics Cloud (Enterprise) 2024.15.16

Product

SAP Analytics Cloud 1.0

Keywords

KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.