NOTICEPOTENTIAL FOR DATA LOSS.
The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure, please contact Product Support Services prior to attempting the procedure below.
- After a DS_Rebuild DS ControlPoint still appears with the "UNKNOWN ERROR" when trying to playback video
- DS ControlPoint times out when trying to playback video even though it can be found in the storage locations.
- DS Information displays error "Storage Service DB Connect SQL Connect Failed."
Pelco Video Management
- DigitalSentry version = ALL
- DS ControlPoint
- Micorsoft SQL database video pointers are not correctly referencing the video files or store locations of the video files.
- Video files have been moved to different storage locations.
- DS_Rebuild fails to correct the video file pointers in SQL.
- Buffer Corruption
Power Cycle Server to clear buffers
Note: Make sure your Windows user has full administrative rights to SQL.
1) The SQL databse video pointers have to be cleared.
- Perform a DS Backup
- In DS Admin, uncheck all storage locations for "Active" and "Copy to Network Storage"
- Open Services (START > Run or Search bar > type in services.msc and then press [ENTER] )
- STOP all DigitalSENTRY services, leave the SQL Server service running.
- Click on START > Programs > Microsoft SQL Server 2008 R2 (or 2005 for older DS versions) > SQL Server Management Studio.
- If prompted to carry over settings from SQL 2005, select No both times.
- The Connect to Server box will open, click Connect. (Verify that the DigitalSentry database is accessible [if not login using the "sa" account])
- Click the "New Query" button to start a new query
- Copy and paste the following script into the "New Query" window and hit the "! Execute" icon.
Set nocount on
Print 'Deleting all video pointers in the DigitalSENTRY database'
truncate table VideoArchive2
Select count(*) VideoArchive2_Count
select count(*) VideoFile_Count from videofile
if not exists(select * from VideoFile)
dbcc checkident (VideoFile, reseed, 1)
*To verify the script was successful right click and "Select Top 1000 Rows" for " dbo.VideoArchive2" and "dbo.VideoFile". If those tables are empty then the script was successful.
2) Clear the Storage Locations
- If there are Network Storage locations copy down the network drive paths.
- In the SQL Management Studio go to: Databases > DigitalSENTRY > Tables > dbo.StorageLocations
- Right Click dbo.StorageLocations and select "Edit Top 200 Rows"
Right Click each row to select it and choose "Delete" for all the rows.
3) Run the DS Rebuild
- Start the DigitalSENTRY services to repopulate the available storage locations. Verify that the storage locations are added and reconfigure any Network Storage.
- Stop the DigitalSENTRY services
- Run the DS Rebuild
- Start the DigitalSENTRY Video Server Service and the DigitalSENTRY Storage Service
- In DS Admin mark the Storage Locations for Active.
Testing the Repair
- Verify that the video files are being written to the storage drives by going to storage location and today's date and pressing "F5" to see if need data is being created.
- Verify that DS ControlPoint can play back video.