SAP Knowledge Base Article - Public

3376996 - Data Flow fails in case of DELETE mode

Symptom

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

Environment

SAP Datasphere

Reproducing the Issue

Run the Data Flow

Cause

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.

Resolution

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.

Keywords

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

Product

SAP Datasphere all versions