3613366 - 502 Bad Gateway Error When Deleting Local Table in SAP Datasphere

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

SAP Datasphere

1. Navigate to a local table in SAP Datasphere.
2. Attempt to delete the table.
3. Observe the 502 Bad Gateway error message.

The deletion fails due to memory limitations allocated to the HANA instance underlying SAP Datasphere. The operation exceeds available memory, resulting in the error.

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:

1. Create a Data Flow.
2. Set the local table as the target.
3. 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.

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