3.2

Table Of Contents
Running Database Maintenance Tools
80
Running Database Maintenance Tools
The Maintenance view in the Database section of the Interplay Administrator provides the
following tools that you can use to fix database problems. You can use these tools with Interplay
Engine databases v2.4.0.1 or later, except for Validate User Tree, which you can use only with
Interplay Engine v2.6. The tools are not displayed when connected to earlier versions of the
Interplay Engine.
Verify Link Consistency: Use this tool to detect and remove broken links and link
inconsistencies.
Broken links are objects visible in a database folder that do not refer to an existing asset.
They are displayed with a special X icon and are named with a mob ID (media object ID).
They should be removed because they can cause exceptions during browsing.
Link inconsistencies are not visible. They are obsolete or invalid entries in internal database
tables. A high number might cause slowdowns for certain operations.
Cleanup Invalid Dependencies: Use this tool to detect and remove dependency
inconsistencies.
Dependency inconsistencies are not visible. They are obsolete or invalid entries in internal
database tables. A high number might cause slowdowns for certain operations.
Remove Duplicated Locators: Use this tool to detect and remove duplicated locators.
Duplicated locators are locators that have the same comment, timestamp, and color as
another locator on the same asset. A high number might cause slowdowns for certain
operations. They were created because of a bug in certain Avid editing products.
Recover Lost Master Mobs: Use this tool to detect and recover assets without a visible
representation in a folder and display them in the Orphan Clips folder.
Lost master mobs are assets (such as sequences, master clips, and subclips) that are stored in
the database but have no visible representation in a folder.
Delete Lost File Mobs: Use this tool to detect and remove media file information objects
containing information about a specific media file, like the resolution, site or location, which
are not associated to an asset.
Lost file mobs are media file information objects that are stored in the database but are not
associated to a master clip or rendered effect.
Validate User Tree (Interplay Engine v2.6 or later): Use this tool to detect and fix
inconsistencies in the user structure.
The AvidWG or AvidAM database contains a copy of the CCS user database. If the internal
structure of this copy contains inconsistencies, then the synchronization of users between the
CCS and the database might fail.