Digital Sentry fails to move video to network storage and reports error Could not load the DLL ...\Binn\DSXSP.dll in the Application log.

Issue

The Network Storage shows to be Online and is enabled under the VAU "Copy To Network Storage Locations" but does not move video to network storage system.


ISSUE#1

Event Viewer > Application log reports the following error:

  • Source:       MSSQL$DS_MSSQLSE
  • Type:           Error
  • Event ID:    17750
  • Description:  Could not load the DLL $(ProgramFiles)\Microsoft SQL Server\MSSQL\Binn\DSXSP.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)
     

 

 


ISSUE#2

  • Source:          MSSQL$DS_MSSQLSERVER
  • Type:              Error
  • Event ID:       17750
  • Description: Could not load the DLL C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Binn\DSXSP.dlls it references. Reason: 193 (C:\Program Files (x86)\Microsoft SQL Server\MSSQL\Binn\DSXSP.dll is not a valid Win32 application.)




     

Product Line

Pelco Video Management

Environment

  1. Digital Sentry  7.0.8 - 7.1.90
     
  2. DS NVs all versions
    • Microsoft® SQL Server® 2008 Enterprise SP2 64bit

Cause

  1. The SQL stored procedure responsible has incorrect data.
     
  2. Running Microsoft® SQL Server® 2008 Enterprise SP2 64bit which is not compatible with the 32bit DSXSP.dll.

Resolution

ISSUE 1 Resolution

Digital Sentry version 7.0.08 - 7.1.90

  1. Download the FixExtendedStoredProcedures.zip to the recorder, extract to the C:\DigitalSentry folder.
  2. Open a command prompt (Start > Run or Search Bar > type in cmd then OK or ENTER) and type sqlcmd -S localhost\ds_mssqlserver -i c:\digitalsentry\fixextendedstoredprocedures.sql then click ENTER.
  3. Open services (Start > Run or Search Bar > type in services.msc then OK or ENTER) and restart the SQL Server (DS_MSSQLSERVER) service and the DigitalSENTRY Video Server service. You should no longer be getting those errors in event viewer, network storage should start copying over again if setup correctly.



Digital Sentry version 7.2.30 and above

  1. Open a command prompt (Start > Run or Search Bar > type in cmd then OK or ENTER) and type sqlcmd -S localhost\ds_mssqlserver -i c:\digitalsentry\ds_refresh.sql then click ENTER.
     

Note: Windows 7, 2008 systems may require the command prompt be run as administrator, if so do not hit ENTER or OK after typing in Start > Search Bar > cmd, instead right-click the CMD.exe which is displayed in the search results and select "Run as administrator".




ISSUE 2 Resolution

The Digital Sentry NVs software does not support 64bit Microsoft SQL installations, the DS NVS installer will install Microsoft SQL Server 2008 R2 RTM - Express with Management Tools automatically which is 32bit. 

For information on where to download the DS NVs software, please refer to article: Where can I download the latest version of Digital Sentry software.