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