Unable to delete/modify object because it is referenced by other database objects

Symptoms

When you attempt to delete an object or make certain modifications, one of these error messages may appear.

Unable to delete/modify object because it is referenced by other database object(s). To delete/modify the object, you need to remove these dependencies first.

Unable to delete/modify object because it is referenced by other database object(s). To delete/modify the object, you need to remove these dependencies first. To view the full list of an object's dependencies, just open it and click Actions>Show Dependencies on the window toolbar.

Cause

Objects in Alloy Navigator Express are interconnected. This error occurs when an object is referenced by other objects via their fields. For example, if an asset is assigned to an owner, the owner's person record is referenced by that asset via the Owner field.

Objects with such dependencies cannot be deleted directly.

Resolution

To delete an object with dependencies, you must first identify and remove all references to it. In the example above, if you want to delete a person record linked to a computer record via its Owner field, you can either reassign the computer to a new owner or clear the Owner field.

Deletion restrictions apply only when other objects directly reference the current object via their fields. For example, assets reference persons through the Owner field, or tickets reference assets through the Related Asset field. However, links that could be found on the object's Related Objects tab or within the object's attributes do not prevent deletion.

TIP: Object deletion is not a standard practice in Alloy Navigator Express. Typically, the lifecycle of an object ends with it being marked as inactive. This approach helps preserve the integrity of related data and ensures that links between objects are not disrupted. Instead of deleting an object, consider marking it as inactive. For example, rather than deleting a record for a disposed computer, you can mark it as "retired."

Related Information:

Marking IT assets as retired

Marking Person records as inactive