How to delete an offline device permanently from an Endura system?

Issue

Device that no longer exists on the Endura system is still showing up in the Endura WS5000 Workstation software as well as Endura Utilities.

Product Line

Pelco Video Management

Environment

Any Endura system

Cause

When devices are removed from an Endura system, the System Manager has no way of knowing that the device no longer exists and will continue to report it as offline.

Resolution

To delete an offline device that has been permanently removed from the Endura System, do the following:

  1. Start the Endura Utilities application.
  2. Login as an Endura Administrator. The default username is admin and the default password is admin.
  3. Click on the SM Search button located on the bottom of the application.
  4. Select the System Attributes tab.
  5. Click on the desired device type in the left column. 
  6. Right-click on the device that will be removed listed under the Group Tools tab.
  7. Select Device ActionsDelete from SM.  This will delete the device from the database on the SM5000.
    • Older versions of Endura Utilities will have 'Device Macros' rather than 'Device Actions'
  8. To reset the device cache on the WS5000, delete all instances of the DevicesOnline.dat file. Please see Lessons Learned Article #9095 for information on how to do this.

 

For SM5200 Only - If the above steps do not work, try the following:

  1. Start the Endura Utilities application.
  2. Login as an Endura Administrator. The default username is admin and the default password is admin.
  3. Click on the SM Search button located on the bottom of the application.
  4. Select the System Attributes tab.
  5. Click on SM5200 on the left window.
  6. Right-click on the SM5200 listed in the right-hand window and select Scripts --> One-time script.
  7. Copy and Paste the following command into the One-time script and click "OK" to run the command:

    /usr/local/pgsql/bin/psql -U postgres -d DeviceManager -c "alter table upnpstatedeltadvc drop constraint upnpstatedeltadvc_upnpudn_fkey"
     
  8. Once this is complete, you should now be able to go back to the first method and delete any offline devices you choose.