Symptom
When attempting to delete a local table in SAP Datasphere, the follow error message appears:
- Failed to delete the model. 502 Bad Gateway: Registered endpoint failed to handle the request
Environment
SAP Datasphere
Reproducing the Issue
- Navigate to a local table in SAP Datasphere.
- Attempt to delete the table.
- Observe the 502 Bad Gateway error message.
Cause
The deletion fails due to memory limitations allocated to the HANA instance underlying SAP Datasphere. The operation exceeds available memory, resulting in the error.
Resolution
SAP Datasphere development is planning to introduce logic that truncates the table before deletion, which will help reduce memory usage during the process.
Workaround (until the enhancement is available):
You can manually truncate the local table by using a Data Flow:
- Create a Data Flow.
- Set the local table as the target.
- Choose Truncate mode for the target table.
For detailed instructions, refer to Add or Create a Target Table in a Data Flow | SAP Help Portal.
Keywords
SAP Datasphere, local table, delete table, table deletion error, 502 Bad Gateway, Registered endpoint failed, memory limit, HANA instance, truncate table, Data Flow, truncate mode, deletion failure , KBA , DS-DI-TAB , Table Persistency , Problem