SAP Knowledge Base Article - Public

3376996 - Data Flow fails in case of DELETE mode


The DELETE mode is set for Data Flow, then the running fails with error message:

DBS-070407: |Loader MapOperation_xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx SQL submitted to database <> resulted in error <General error;4 cannot allocate enough memory: Allocation failed $REASON$>. The SQL submitted is <UPDATE ....


SAP Datasphere

Reproducing the Issue

Run the Data Flow


There is a restriction in case of DELETE mode: The Delete mode fails for a target table when a mapped column contains NULL values. 
This information can be found in the SAP Help documentation.


Make sure to map only those columns where no NULL values, like map only the primary key columns or filter out the null value rows.


KBA , DS-DI-DF , Data Flows , Known Error


SAP Datasphere all versions