SYMPTOM:
In Strategy Developer 9.x, when users attempt to delete a database instance from a project, the following warning message appears:
DB Instance object 'DB Name' cannot be deleted because other objects depend on it.
After running SQL directly against the metadata to determine which objects are dependent on the database instance object, a user may find that the database instance is dependent on a server definition, as shown in the example below:
Note: The query tool used above is Toad for Oracle.
This object is of type '33', meaning that it is a server definition object.
CAUSE:
The database instance that the user is trying to delete is selected as a database instance in at least one of the projects for at least one of the settings below:
ACTION:
Ensure that the database instance that is to be deleted is not selected in any of these project configuration settings for all the projects in your project source.
For other possible causes of this issue, please refer to the Tech Note below:
KB9468: "DB Instance object 'DB Name' cannot be deleted because other objects depend on it." error message appears when attempting to delete a database instance in Strategy Developer 9.x.
Metadata Modification:
WARNING:
Manually editing values in the Strategy Metadata incorrectly may cause serious, project-wide problems that may make your project unusable. Since these are user-initiated changes, they are not covered by any Strategy warranty. Users are strongly encouraged to backup Metadata prior to any alteration.
KB417873
