SAP Knowledge Base Article - Public

3439166 - Datasphere cannot delete connection - Repository SQL Error

Symptom

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

Environment

SAP Datasphere

Reproducing the Issue

Delete the connection in SAP Datasphere.

Cause

Connection still be used in some views or remote tables.

Resolution

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.

Keywords

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

Product

SAP Datasphere all versions