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
Environment
- SAP Analytics Cloud (Enterprise) 2024.15.16
Reproducing the Issue
- Login to SAC.
- Access the model.
- Add a new column in column expression editor.
- Apply the transformation for the whole model and save model.
- Got error:
"dberror(PreparedStatement.executeQuery): 2048 - column store error: search table error: [1000002] Allocation failed ; $size$=2627505672; $name$=expr; $type$=pool; $inuse_count$=362; $allocated_size$=174305085976; $alignment$=8; $failure_type$=STATEMENT_MEMORY_LIMIT; $failure_flag$=
Correlation ID: 18723164-4829-4226-9622-015419770512"
Cause
This is due to a select on a view, with the view containing 96 rows, 51 million rows or 4.9 billion cells.
Resolution
This issue can be solved in below two workarounds:
- Use calculated measure which is a better solution as newly imported data will have correct values instead of creating new measures based on expressions within transform data, especially there is daily recurring import job.
- Create a new blank measure, then import data to this measure via an import job. In this scenario, the issue should not arise since it's a different work flow than the creation via transform data.
Keywords
KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem