Resetting Analytics Storage Database

-----------------------------------

User Group: Administrator | Owner

Related Digital Watchdog VMS Apps: DW Spectrum IPVMS

Software Version: 6.0

Last Edit: March 17, 2025

-----------------------------------

 

Analytics Storage Issues

If you have recently updated the DW Spectrum Server or have re-indexed the archive and are experiencing an error message that states that the storage path is offline for analytics data, it is possible that the analytics storage location is corrupted. To resolve this problem, Administrators can delete the existing data from the archive to clear the corruption and return analytic storage to working order.

This article will outline how to delete existing analytic storage from Windows and Ubuntu systems, effectively resetting the server’s analytic database.

 

**NOTE: This process will result in the loss of searchable motion and object detection data from existing video archives. However, video recorded beyond the point of this reset will have searchable analytics in return.

 

Related Article

• Resolving Corrupted Database Index for DW Spectrum

 

Before You Begin

Before you begin, confirm the server’s archive storage location. Analytic data is saved in the media server storage folder, which can vary, depending on your preferred storage configuration.

For more information on storage management, refer to the article “Local Storage for DW Spectrum IVPMS Overview”.

 

Removing Analytic Data from a Windows OS Server

To delete analytic data from a Windows System:

1. Stop the Spectrum Media Server.

Close the DW Spectrum Client and right-click on the DW icon in the service tray and select “Stop Server (started)” to stop the Media Server.

2. After stopping the Media Server, use the File Explorer and navigate to “DW Spectrum Media” folder.

Locate the server archive folder, named with the server’s alphanumeric System ID.

 

3. Open the folder and locate the SQLITE file named “object_detection.sqlite”.

Delete the object detection file from the file directory.

 

4. Start the Media Server.

Right-click on the DW icon in the service tray and select “Start Server (stopped)” to start the Media Server.

 

Removing Analytic Data from an Ubuntu Linux Server

To delete analytic data from an Ubuntu System:

Part 1 – Stop the Spectrum Media Server

1. Close the DW Spectrum Client and open the Terminal (CTRL+ALT+T) application. Enter the following command to gain Super User access.

 

2. Enter the system password when prompted. The default Super User password for DW Blackjack Servers is:

 

**NOTE: When entering the system password, text will not appear as you type in the Terminal.

 

3. Enter the following command to stop the Media Server.

 

Part 2 – Delete the Analytics File

1. In the Terminal, enter the following command to access the DW Spectrum Media folder directory:

 

2. Enter the following command to list accessible directories.

 

3. Locate the server archive folder, named with the server’s alphanumeric System ID.  

Once identified, change to the archive folder directory with the following command:

 

4. Once in the archive directory, delete the object detection file from the directory with the command:

 

Part 3 – Start the Spectrum Media Server.

Enter the following command to start the Media Server.

 

The object detection file and corrupted analytics file will be deleted. After restarting the Spectrum Media Service, the system will automatically create a new analytics storage file and begin operating normally.

 

 

______________________________________________________________________________

For More Information or Technical Support

DW Technical Support: https://www.digital-watchdog.com/contact-tech-support/

DW Sales: sales@digital-watchdog.com | www.digital-watchdog.com

Rev: 06/25                              Copyright © DW. All rights reserved. Specifications and pricing subject to change without notice.