Unable to patch the Database on upgrade from Sentinel 5.1.0 to 5.1.2

  • 3816421
  • 02-Aug-2006
  • 26-Apr-2012

Environment

Sentinel Server 5.1.2
Windows 2003
MS SQL 2000
MS SQL 2005

Situation

[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]Connection-open (Connect()

Attempting to run patchdb.bat or setup.exe for the 5.1.2 upgrade of the database.

Resolution

The database port number was a non-default port of 2005. If you are using a non-standard port number you must manually configure the .bat file and change the appropriate authentication type line for SQL_Auth or Windows_Auth to include the port number you are using. As you can see from the example below, there is a parameter "-port" this needs to be changed to reflect the port number for your database.

Patch_Sql_Auth
java -Desecurity.log.console=true -cp %LOCAL_CLASSPATH% esecurity.db.install.PatchDB -db mssql -host %DB_HOST% -port 1433 -dbname %DB% -to %TARGET_VERSION% -os windows -installdir"%INSTALL_DIR%" -logdir "%LOG_DIR%" -password %ESECDBA_PASS%
GOTO End_Patch

:Patch_Win_Auth
java -Desecurity.log.console=true -cp %LOCAL_CLASSPATH% esecurity.db.install.PatchDB -db mssql -host %DB_HOST% -port 1433 -dbname %DB% -to %TARGET_VERSION% -os windows -installdir"%INSTALL_DIR%" -logdir "%LOG_DIR%"

1. Copy the patchdb.bat to another location
2. Edit the patchdb.bat and replace -port 1433 to -port
3. Save the patchdb.bat and re run from the command line.

This has since been fixed in version 5.1.3 for Sentinel.

Status

Reported to Engineering