SAP Knowledge Base Article - Public

3439166 - Datasphere cannot delete connection - Repository SQL Error


While deleting connection in Datasphere, below error happens:

Connection couldn’t be deleted.

We can provide the following information to assist either you or an SAP engineer to solve the issue:

Correlation ID: <correlation_ID>
HTTP Status: 500 Internal Server Error
Error Code:
Technical Message: Repository SQL Error


SAP Datasphere

Reproducing the Issue

Delete the connection in SAP Datasphere.


Connection still be used in some views or remote tables.


Please delete all tables/views which uses this connection.

See Also

Below SQL statement can be used in HANA DB for issue analysis:

select * from remote_sources;

To find the corresponding connection name.

select * from object_dependencies where base_object_name = 'xxxxxxxxxx';

base_object_name is found from remote_sources.


Datasphere, connection , KBA , DS-DI-CON , Connections , Problem


SAP Datasphere all versions