-----------------------------------
Affected Roles: Owner, Administrator
Related Digital Watchdog VMS Apps: DW Spectrum
Complexity: Medium to High
Last Edit: April 7, 2020
-----------------------------------
If you have recently run the Rebuild Archive Index function and have noticed that the rebuilding process is experiencing issues or that it has completed, but you do not see the footage available on the Timeline, then it is likely that the archive may have a corrupted database.
This article will outline how to restore archives from a corrupt database, following failure of the Rebuild Archive Index function.
Before attempting to restore the archive files, perform the following:
Note: This process is for Servers that are using DW Spectrum v2.6 – Build 13867 (or newer). If you are using an older version than this, you will not be able to perform this process until the current version is updated.
Right-click on the DW Spectrum Tray Tool, then select Stop Server.
$sudo service dwspectrum-mediaserver stop
Locate and delete the file ending in _media.sqlite.
Example location: C:/DW Spectrum Media
Locate and delete the file ending in _media.sqlite.
Example location: /opt/digitalwatchdog/mediaserver/var
/opt/dwspectrum/mediaserver/var/storage_db/<storage directory>
Right-click on the DW Spectrum Tray Tool, then select Start Server.
$sudo service dwspectrum-mediaserver start
Right-click on the Server in the Resource Tree, then navigate Server Settings > Storage Management
Select Rebuild Archive Index.
During the archive rebuild process, the Server will continue to record and archive footage normally.
Once the rebuild is complete, the Server will be operating on a clean archive database and recorded video should be available for playback in the Timeline again.
Note: The rebuild process may take a significant amount of time, depending on the overall size of the archive.