SAP Knowledge Base Article - Public

3621926 - Memory Error when running Transformation Flow

Symptom

Error{"correlationId":"XXXX","errorMessage":"SQL error 129: transaction rolled back by an internal error: \"XSPACE\".\"TRFFL_EXECUTE\": line 691 col 7 (at pos 27643): Allocation failed; Reason: booked memory limit reached (SAP Note 3191224) at SQLScript/Executor/Evaluator/SeEvaluatorImpl.cpp:808"}

Environment

SAP Datasphere

Reproducing the Issue

While running transformation flows performance and memory errors occur.

Cause

Unoptimized workload classes, lack of overall resource for the task on tenant's system.

Resolution

Consider using help page to prioritize space and flow execution, increasing threshold that the flow can use.

Help - Managing Workload with Workload Classes

Also as other option consider transformation flow partition. This is described in the blog below: 

Blog - Transformation Flow partition generation with SAP Datasphere CLI 

See Also

Help - Creating a Transformation Flow

Keywords

booked memory limit, TRF, performance, memory , KBA , DS-DI-TRF , Transformation Flows , DS-SM , Space Management , Problem

Product

SAP Datasphere all versions