This feature allows you to find and report inconsistent clips and media files.

Note
The operations may be quite time consuming, depending on the size of your database and the load on your SQL Server.
Caution
Never use the same file locations for different databases. This may cause deletion of files in another Cinegy Archive database!
Caution
Never use the base path for different media file type shares nested inside each other as file locations; this will lead to the incorrect results when performing the consistency checking operations and to the accidental deletion of media files.
Caution
To be able to perform the "Populate a list" operation, ensure that the shares monitored by consistency checker are available for the group of users under which the SQL Server services are started.

MOGs without Essences

Populate a List

This function will search for MOGs (Media Object Groups) without any essence. In the "File types" and "Node types" fields correspondingly select those file and node types that should be included into the list.

You can also define a number of rows to be displayed in the populated list by entering the desired value via the keyboard or by pressing the audit_up_down_buttonsbuttons. The default value is 0, i.e. all rows of the populated list will be displayed.

Press the "Populate a list" button to list all missing media files. For every file link, the system checks if the file is physically present in the specified location.

38_DBM_ConsistencyChecking_populate

The dialog shows the type and deletion status of the detected media files.

Export the List

If you want to have a better overview about missing media files, you can export and save the result of the population as a TXT file.

38_DBM_ConsistencyChecking_export

Essences without MOGs

38_DBM_ConsistencyChecking_populate_02

The "Essences without MOGs" function is necessary to find all files that do not correspond to a MOG (Media Object Group).

Populate a List

Caution
To perform the "Populate a list" operation, user under which the SQL Server is running should have enough rights.

Select a file location from the "All available file locations" list and move it to the right side to the "Selected file locations" by pressing the corresponding arrow button.

To check availability of a shared file location on the SQL Server side, select it in the "Selected file locations" list and press the check_share_buttonbutton; the following "Check share" dialog appears:

check_share_dialog

Press the "Check" button; a progress bar will show the check-up progress. When checking is finished, a list of available files on the selected file share is displayed with a number of records in it shown in the corresponding field:

check_share_dialog_filled

When the file share is not accessible, you will be informed about it with the corresponding message.

Press "Close" to exit the dialog and return to the "Consistency checking" window.

Press the "Populate a list" button to create a list of broken linkages. If Cinegy Enterprise Manager finds broken references, the results will be listed in the table on the "Files" tab.

You can also define a number of rows to be displayed in the populated list by entering the desired value via the keyboard or by pressing the audit_up_down_buttonsbuttons. The default value is 0, i.e. all rows of the populated list will be displayed.

38_DBM_ConsistencyChecking_populate_03

Export the List

You can use an exported list for file maintenance and cleanup. The log file contains full file names; every name is in a separate line, saved as a TXT file. Press the "Export" button:

38_DBM_ConsistencyChecking_export_02

Delete the Files

To clear the server of no longer needed file(s), press the "Delete selected" or "Delete all" button.

38_DBM_ConsistencyChecking_deletion

Purge Deleted Nodes

38_DBM_ConsistencyChecking_purge

"Purge deleted" removes nodes with the "deleted" status. Press the "Refresh" button to see the latest status. Choose "top" and define the number of nodes marked as 'deleted' to be deleted permanently or "all" to purge all nodes; press "Purge" to start the process.

Caution
This operation is permanent and cannot be undone!

Check for Deleted Documents

Cinegy Archive database consists of the SQL Server database nodes, referenced to the physical media files. Documents as well as media files are located on the disk storages.

When deleting a DocumentBin or the documents inside it, the SQL Server database nodes are only marked as deleted. These nodes become invisible in the explorer tree but still exist in the database structure. The physical media files and documents are not affected.

To delete the documents permanently, go to the "Check documents" tab.

38_DBM_ConsistencyChecking_check_documents

Press the "Populate a list" button to retrieve the list of physical document files referenced by the marked as deleted nodes. These are the files available for deletion.

Choose "top" and define the number of documents marked as 'deleted' to be deleted permanently or "all" to purge all documents and press the "Delete all" button. Alternatively you can manually select the files to be deleted and press the "Delete selected" button to purge them.

Select the "delete only files" checkbox to delete only physical files not deleting the database nodes. As purging marked as deleted database nodes is a time consuming operation, the deletion of physical files only may save some time in case of high disk space usage.

Caution
If the "Purge" operation was previously executed, the references from the marked as deleted documents to their physical document files will be deleted and the list of documents available for deletion will not be populated.