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

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

• SAP Analytics Cloud (Enterprise) 2024.15.16

1. Login to SAC.
2. Access the model.
3. Add a new column in column expression editor.
4. Apply the transformation for the whole model and save model.
5. 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"

This is due to a select on a view, with the view containing 96 rows, 51 million rows or 4.9 billion cells. 

This issue can be solved in below two workarounds:

1. 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. 
2. 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. 

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