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
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