SAP Note 20251 - Delete BOM: DBIF_RSQL_NO_MEMORY.

Symptom

Update termination when you delete large BOMs: error DBIF_RSQL_NO_MEMORY

Cause and prerequisites

When you delete a BOM, a change document line is created for every field of every item. Because this is created in the main update task, the cluster for tables CDPOS, CDHDR reaches the maximum value of 7.5 megabytes without a COMMIT taking place.

Solution

There are currently two ways of deleting the BOM:

1. Multiple-step procedure: delete and post around 200 items, then delete the BOM itself at the end of the process.

2. Alter the change document object such that the individual field names are not listed.

You can then delete the BOMs normally. To do this, call Transaction SCD0; then select change document object STUE for maintenance.

In this object, reset the flag "Documentation of individual fields when deleting" in table STPO. Then call the function "Generate update task" in the Utilities menu to regenerate the update task.

Additional key words

CS80