Sample Code/Error:
DB Instance object cannot be deleted because Catalog object in project depends on it.
CAUSE:
Although the database instance was unchecked from the project it has still some dependency to the Warehouse catalog.
This can be verified by running the following SQL in DB Query tool directly against the metadata to see which object depends on this database instance:
SELECT a11.object_id,
a11.object_name,
a11.object_type,
a11.project_id,
a11.parent_id
FROM DSSMDOBJINFO a11,
DSSMDOBJDEPN a12
WHERE a11.object_id = a12.object_id
AND a12.DEPN_OBJID = `<ID>`
This SQL has been written to be applicable to Microsoft SQL Server use, and should work for most relational databases. Contact your DBA if you need this SQL to be modified for other Database Platforms.
ACTION:
Users can use the option "delete unused managed objects" to clean up the dependency and delete the database instance or in some cases, check the database instance in project configuration, and then un-check the database instance to resolve the issue.
This issue has been logged as Scopus ID: 550914 and KB39379
