Endpoint Protection

Expand all | Collapse all

upgrade to SEPM 14.3ru1 failed

  • 1.  upgrade to SEPM 14.3ru1 failed

    Posted 01-22-2021 04:12 AM
    hello to all,
    we upgraded to 14.3ru1 and apparently something went wrong with the automatic migration required with this release from the symantec embedded db to the sql server express. So upgrade failed an the console is of course not avaible.  I try to attach the log, we have a ticket open for a few days but for now there is no solution except to roll back to the previous version. thanks

    2021-01-21 12:22:50.311 THREAD 1 SEVERE: ================== Server Environment ===================
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: os.name = Windows Server 2016
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: os.version = 10.0
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: os.arch = x64
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: java.version = 11.0.7
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: java.vendor = AdoptOpenJDK
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: java.vm.name = OpenJDK 64-Bit Server VM
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: java.vm.version = 11.0.7+10
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: java.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre11
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: catalina.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: java.user = null
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: user.language = en
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: user.country = US
    2021-01-21 12:22:50.311 THREAD 1 SEVERE: scm.server.version = 14.3.3385.1000
    2021-01-21 12:22:50.311 THREAD 1 INFO: Main> Main>> Checking upgrade arguments... Command-line argument is empty.
    2021-01-21 12:22:50.311 THREAD 1 INFO: Main> Main>> Server Home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
    2021-01-21 12:22:50.326 THREAD 1 INFO: ServerXml>> verifyAndRetrieveROOTXml>> Verifying ROOT.xml...
    2021-01-21 12:22:50.373 THREAD 1 INFO: ServerXml>> verifyAndRetrieveXmlFile>> .xml file is valid, deleting backup file...
    2021-01-21 12:22:50.373 THREAD 1 INFO: ServerXml>> verifyAndRetrieveXmlFile>> .xml file is valid, deleting backup file...
    2021-01-21 12:22:50.389 THREAD 1 INFO: create a new RootXMLHandler
    2021-01-21 12:22:50.389 THREAD 1 INFO: readJdbcParameters >> jdbcURL: jdbc:sqlanywhere:CommLinks=Shmem,tcpip(dobroadcast=none;TO=60;host=127.0.0.1;port=2638;verify=no);ServerName=localhost
    2021-01-21 12:22:50.389 THREAD 1 INFO: readJdbcParameters >> jdbcDriverClass: sybase.jdbc4.sqlanywhere.IDriver
    2021-01-21 12:22:50.436 THREAD 1 INFO: DatabaseUtilities> initDataSource>> jdbcDriverClass: sybase.jdbc4.sqlanywhere.IDriver
    2021-01-21 12:22:50.436 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Server has not been configured yet.
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: com.sygate.scm.util.db.JDBCDriverNotConfiguredException: no match found for jdbc driver name
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: at com.sygate.scm.server.db.util.JDBCDriver.getInstance(JDBCDriver.java:87)
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.initDataSource(DatabaseUtilities.java:3706)
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.initDataSource(DatabaseUtilities.java:3688)
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.initDataSource(DatabaseUtilities.java:3674)
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: at com.sygate.scm.server.upgrade.ui.Main.<init>(Main.java:365)
    2021-01-21 12:22:50.436 THREAD 1 SEVERE: at com.sygate.scm.server.upgrade.ui.Main.main(Main.java:1142)
    2021-01-21 12:22:50.436 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Can't initialize Datasource. Exception message = no match found for jdbc driver name
    2021-01-21 12:22:50.436 THREAD 1 INFO: Main> Main>> DataSource initialization failed. Cannot run the upgrade tool.
    2021-01-21 12:22:50.451 THREAD 1 INFO: ServiceUtil> execCmd >> Started. Command = [C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\..\bin\ServiceUtil.exe, -queryIISAnonymousUserName],Start time: Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.529 THREAD 1 INFO: ServiceUtil> execCmd>> Finished. Return code = 12,Finish time: Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.529 THREAD 1 WARNING: ServiceUtil> execCmd>> Process output:
    -1 Unable to obtain pointer to IUnknown interface. Error Code = 0x800401e4


    2021-01-21 12:22:50.529 THREAD 1 INFO: ServiceUtil> getIISAnonymousAccountName>> Returning IIS anonymouse account name : null
    2021-01-21 12:22:50.529 THREAD 1 INFO: UserAccount > getSid >> BUILTIN\USERS : S-1-5-32-545
    2021-01-21 12:22:50.529 THREAD 1 INFO: verifyAndSetSepmInstallFolderPermissions>> Setting ACL for jre11Path: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre11
    2021-01-21 12:22:50.561 THREAD 1 INFO: ACLUtil> setACLs>> Setting permission(s) for Object = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre11 having type = file, permission to be given for list of trusteeSIDs and their permissions = {S-1-5-32-545=read_ex}, is add permission? = true, keep other existing ACEs? ('false' means, we need to clear the existing one(s)) = true, inherit from parent? = nc, reset children files/folders? = false,Propogate Flag? =so,Start time: Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.561 THREAD 1 INFO: ACLUtil> executeSetACLExe >> Started. Command = [C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\SetACL.exe, -on, C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre11, -ot, file, -actn, setprot, -op, dacl:nc;sacl:nc, -actn, ace, -ace, n:S-1-5-32-545;p:read_ex;s:y;m:grant;i:so],Start time: Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.639 THREAD 1 INFO: ACLUtil> executeSetACLExe>> Finished. Return code = 0,Finish time: Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.639 THREAD 1 INFO: ACLUtil> setACLs>> Succeed to set permission(s) for Object = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre11,Finish time: Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.639 THREAD 1 INFO: verifyAndSetJre11FolderPermissions: Fisnished!
    2021-01-21 12:22:50.639 THREAD 1 INFO: applyAclsPreUpgrade: Finished!
    2021-01-21 12:22:50.639 THREAD 1 INFO: Main> Main>> Current DB schema version (14.3.1.1000), Testing DB connection... Current time = Thu Jan 21 12:22:50 CET 2021
    2021-01-21 12:22:50.701 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2021-01-21 12:22:50.701 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2021-01-21 12:22:50.701 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_NOT_STARTED
    2021-01-21 12:22:50.701 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:50.701 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:50.701 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2021-01-21 12:22:50.701 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2021-01-21 12:22:50.701 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_NOT_STARTED
    2021-01-21 12:22:50.701 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:50.701 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:50.701 THREAD 1 INFO: Main> executePreLaunchSteps>> dbConnected: false, isEmbeddedDb: false
    2021-01-21 12:22:50.701 THREAD 1 INFO: Main> executePreLaunchSteps>> Config schema format is getting upgraded from (schema version from upgrade backup properties created by installer): 14.3.0.0100
    2021-01-21 12:22:50.701 THREAD 1 INFO: Main> executePreLaunchSteps>>isTelemetryOptedInFromDB is (isTelemetryOptedInFromDB from upgrade backup properties created by installer): true
    2021-01-21 12:22:50.701 THREAD 1 INFO: Main> executePreLaunchSteps>> isTelemetryOptedInFromDB from upgrade backup properties:true
    2021-01-21 12:22:50.701 THREAD 1 INFO: Main> executePreLaunchSteps>> DbVersion: 14.3.0.0100 schemaVersionFromDB: 14.3.0.0100 isSpm51Mr7: false hasOtherOSAgents: false dbcompanySize: 2 dbConnected: false isTelemetryOptedInFromDB: true
    2021-01-21 12:22:50.701 THREAD 1 INFO: Main> checkUpgradeFeasibility>> Checking for upgrade feasibility, current schema version = 14.3.1.1000, schema version from db = 14.3.0.0100
    2021-01-21 12:22:50.701 THREAD 1 INFO: VersionToBeSupported: 14.3.0.0100
    2021-01-21 12:22:50.701 THREAD 1 INFO: SchemaVersion>> isSupported> versionToBeSupported '14.3.0.0100 is supported for this release
    2021-01-21 12:22:50.920 THREAD 1 INFO: SchemaVersion>> isSupported> ignored, semLocalSettingsFrom is null!
    2021-01-21 12:22:50.920 THREAD 1 INFO: Main> launchMainFrame>> isSpm51Mr7AndHasOtherOSAgents: false, isAutomated: false, dbServerVendor: null
    2021-01-21 12:22:51.061 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2021-01-21 12:22:51.061 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2021-01-21 12:22:51.061 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_NOT_STARTED
    2021-01-21 12:22:51.061 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:51.061 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:51.061 THREAD 1 INFO: SQL server with SQL Auth mode. Display User Credential panel
    2021-01-21 12:22:51.061 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> needChooseLaunchServicePort=false serverVersionPreUpgrade=14.3.1169.0100
    2021-01-21 12:22:51.076 THREAD 1 INFO: MainFrame> MainFrame>> needToShowUpgradeServerPropPanel: false
    2021-01-21 12:22:51.342 THREAD 1 WARNING: SQLExpressDbHelper>>executePowshellCommand processing:
    args[0]: C:\WINDOWS\system32\reg.exe
    args[1]: query
    args[2]: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\RunOnce
    args[3]: /v
    args[4]: Symantec Management Server Upgrade Wizard

    2021-01-21 12:22:51.404 THREAD 1 WARNING: SQLExpressDbHelper>>executePowshellCommand processing result: 1
    2021-01-21 12:22:51.404 THREAD 1 WARNING: DbUtil>>executePowshellCommand standard output:



    Error Output:
    ERROR: The system was unable to find the specified registry key or value.

    2021-01-21 12:22:57.536 THREAD 23 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2021-01-21 12:22:57.536 THREAD 23 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2021-01-21 12:22:57.536 THREAD 23 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_NOT_STARTED
    2021-01-21 12:22:57.536 THREAD 23 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:57.536 THREAD 23 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:57.567 THREAD 29 WARNING: Upgrade> doUpgrade>> Upgrade process started @ : 0
    2021-01-21 12:22:57.567 THREAD 29 INFO: Upgrade> doUpgrade>> Initializing upgrade steps...
    2021-01-21 12:22:57.567 THREAD 29 INFO: UpgradeStep >> checkUpgradeStatus.
    2021-01-21 12:22:57.567 THREAD 29 INFO: Upgrade> doUpgrade>> Initializing upgrade steps done!
    2021-01-21 12:22:57.567 THREAD 29 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2021-01-21 12:22:57.567 THREAD 29 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2021-01-21 12:22:57.567 THREAD 29 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_NOT_STARTED
    2021-01-21 12:22:57.567 THREAD 29 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:57.567 THREAD 29 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:57.567 THREAD 29 INFO: UpgradeStep >> checkUpgradeStatus.
    2021-01-21 12:22:57.567 THREAD 29 INFO: UpgradeStep >> checkUpgradeStatus.
    2021-01-21 12:22:57.567 THREAD 29 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2021-01-21 12:22:57.567 THREAD 29 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2021-01-21 12:22:57.567 THREAD 29 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_NOT_STARTED
    2021-01-21 12:22:57.567 THREAD 29 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:57.567 THREAD 29 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip
    2021-01-21 12:22:57.614 THREAD 29 INFO: The service name is invalid.More help is available by typing NET HELPMSG 2185.
    2021-01-21 12:22:57.630 THREAD 29 INFO: SemServiceManager> serviceControl>> Executed command - stop SQLANYs_sem5, process return value = 2
    2021-01-21 12:22:57.630 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: SQLANYs_sem5
    2021-01-21 12:22:57.630 THREAD 29 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5
    2021-01-21 12:22:57.645 THREAD 29 SEVERE: SemServiceManager> getServiceStatus>> Error code from sc query: 1060
    2021-01-21 12:22:57.645 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2021-01-21 12:22:57.661 THREAD 29 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2021-01-21 12:22:57.661 THREAD 29 INFO: ServerXml> backupServerROOTXmlFiles>> Is ROOT.xml.bak file created ? true
    2021-01-21 12:22:57.661 THREAD 29 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2021-01-21 12:22:57.661 THREAD 29 INFO: ServerXml> backupServerROOTXmlFiles>> Is Server.xml.bak file deleted ? true
    2021-01-21 12:22:57.661 THREAD 29 WARNING: SQLExpress Database Creating and Backup unzipping(mutiple threads)...
    2021-01-21 12:24:33.723 THREAD 29 WARNING: SQLExpress Database Creating and Backup unzipping(mutiple threads), cost(minutes): 1.6023333333333334, instanceName: SQLEXPRESSSYMC0, port: 2638, isDbCreatedBefore: false, backupFileUnzipDir: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2021-Jan-21_11-57-57.zip-unzipped
    2021-01-21 12:24:33.723 THREAD 29 WARNING: SQLExpress>>migrationRestore, Update ROOT.xml...
    2021-01-21 12:24:33.723 THREAD 29 INFO: ServerXml> createBackupFile>> Is existing backup file deleted ? true
    2021-01-21 12:24:33.723 THREAD 29 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2021-01-21 12:24:33.723 THREAD 29 INFO: ServerXml> backupServerROOTXmlFiles>> Is ROOT.xml.bak file created ? true
    2021-01-21 12:24:33.723 THREAD 29 INFO: ServerXml> createBackupFile>> Is existing backup file deleted ? true
    2021-01-21 12:24:33.723 THREAD 29 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2021-01-21 12:24:33.723 THREAD 29 INFO: ServerXml> backupServerROOTXmlFiles>> Is Server.xml.bak file deleted ? true
    2021-01-21 12:24:33.832 THREAD 29 WARNING: SQLExpress>>migrationRestore, Updated ROOT.xml, instanceName: SQLEXPRESSSYMC0, port: 2638
    2021-01-21 12:24:33.832 THREAD 29 WARNING: SQLExpress>>migrationRestore, Update Site DB property and client tool path and restart SemLaunch Service...
    2021-01-21 12:24:33.832 THREAD 29 INFO: saveConfProp: done
    2021-01-21 12:24:33.895 THREAD 29 INFO: The Symantec Endpoint Protection Manager API Service service is not started.More help is available by typing NET HELPMSG 3521.
    2021-01-21 12:24:33.895 THREAD 29 INFO: SemServiceManager> serviceControl>> Executed command - stop semapisrv, process return value = 2
    2021-01-21 12:24:33.895 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semapisrv
    2021-01-21 12:24:33.895 THREAD 29 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semapisrv
    2021-01-21 12:24:33.910 THREAD 29 INFO: SemServiceManager> getServiceStatus>> The status for semapisrv' service is 1
    2021-01-21 12:24:33.910 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2021-01-21 12:24:33.942 THREAD 29 INFO: The Symantec Endpoint Protection Manager service is not started.More help is available by typing NET HELPMSG 3521.
    2021-01-21 12:24:33.942 THREAD 29 INFO: SemServiceManager> serviceControl>> Executed command - stop semsrv, process return value = 2
    2021-01-21 12:24:33.942 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semsrv
    2021-01-21 12:24:33.942 THREAD 29 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semsrv
    2021-01-21 12:24:33.957 THREAD 29 INFO: SemServiceManager> getServiceStatus>> The status for semsrv' service is 1
    2021-01-21 12:24:33.957 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2021-01-21 12:24:34.004 THREAD 29 INFO: The Symantec Endpoint Protection Launcher service is not started.More help is available by typing NET HELPMSG 3521.
    2021-01-21 12:24:34.004 THREAD 29 INFO: SemServiceManager> serviceControl>> Executed command - stop semlaunchsrv, process return value = 2
    2021-01-21 12:24:34.004 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semlaunchsrv
    2021-01-21 12:24:34.004 THREAD 29 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semlaunchsrv
    2021-01-21 12:24:34.020 THREAD 29 INFO: SemServiceManager> getServiceStatus>> The status for semlaunchsrv' service is 1
    2021-01-21 12:24:34.020 THREAD 29 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2021-01-21 12:24:36.162 THREAD 29 INFO: The Symantec Endpoint Protection Launcher service is starting.The Symantec Endpoint Protection Launcher service was started successfully.
    2021-01-21 12:24:36.162 THREAD 29 INFO: SemServiceManager> serviceControl>> Executed command - start semlaunchsrv, process return value = 0
    2021-01-21 12:24:36.162 THREAD 29 INFO: UpgradeStep >> checkUpgradeStatus.
    2021-01-21 12:24:36.162 THREAD 29 INFO: UpgradeStep >> checkUpgradeStatus.
    2021-01-21 12:24:36.162 THREAD 29 WARNING: SQLExpress>>migrationRestore, Connecting to database by DBA...
    2021-01-21 12:24:36.162 THREAD 29 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://SEPMANAGER:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.224 THREAD 29 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:33559139-94f4-49cf-8516-ee66d6d4115a
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3151)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1912)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2708)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2362)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2213)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1276)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDriverManager(DBConnectionProxy.java:414)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.MSJDBCDriver.getConnection(MSJDBCDriver.java:182)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.JDBCDriver.getDatabaseConnectionWithNTLMv2Retry(JDBCDriver.java:192)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDatabaseConnectionWithNTLMv2Retry(DatabaseUtilities.java:617)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.tryGetSQLExpressDbaConnection(SQLExpressDbHelper.java:1966)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.getSQLExpressDbaConnection(SQLExpressDbHelper.java:1994)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.migrationRestore(SQLExpressDbHelper.java:1886)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:359)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:147)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:248)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/java.lang.Thread.run(Thread.java:834)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:326)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:269)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:645)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:464)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:360)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:444)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:422)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:183)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1144)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1055)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:395)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1820)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: ... 19 more
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:439)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:306)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.validator.Validator.validate(Validator.java:264)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:313)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:233)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:110)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel$HostNameOverrideX509TrustManager.checkServerTrusted(IOBuffer.java:1498)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1510)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:629)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: ... 30 more
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434)
    2021-01-21 12:24:36.224 THREAD 29 SEVERE: ... 38 more
    2021-01-21 12:24:36.224 THREAD 29 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://SEPMANAGER:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.240 THREAD 29 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target". ClientConnectionId:898ceefe-16a9-4417-bddf-060a1d27990c
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3151)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1912)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2708)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2362)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2213)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1276)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDriverManager(DBConnectionProxy.java:414)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.MSJDBCDriver.getConnection(MSJDBCDriver.java:182)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.JDBCDriver.getDatabaseConnectionWithNTLMv2Retry(JDBCDriver.java:192)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDatabaseConnectionWithNTLMv2Retry(DatabaseUtilities.java:617)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.tryGetSQLExpressDbaConnection(SQLExpressDbHelper.java:1966)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.getSQLExpressDbaConnection(SQLExpressDbHelper.java:1997)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.migrationRestore(SQLExpressDbHelper.java:1886)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:359)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:147)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:248)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/java.lang.Thread.run(Thread.java:834)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: Caused by: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:326)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:269)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:645)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:464)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:360)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:444)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:422)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:183)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1144)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1055)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:395)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1820)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: ... 19 more
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:439)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.validator.PKIXValidator.engineValidate(PKIXValidator.java:306)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.validator.Validator.validate(Validator.java:264)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.X509TrustManagerImpl.validate(X509TrustManagerImpl.java:313)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.X509TrustManagerImpl.checkTrusted(X509TrustManagerImpl.java:233)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.X509TrustManagerImpl.checkServerTrusted(X509TrustManagerImpl.java:110)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel$HostNameOverrideX509TrustManager.checkServerTrusted(IOBuffer.java:1498)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1510)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:629)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: ... 30 more
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: Caused by: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.provider.certpath.SunCertPathBuilder.build(SunCertPathBuilder.java:141)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.provider.certpath.SunCertPathBuilder.engineBuild(SunCertPathBuilder.java:126)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/java.security.cert.CertPathBuilder.build(CertPathBuilder.java:297)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: at java.base/sun.security.validator.PKIXValidator.doBuild(PKIXValidator.java:434)
    2021-01-21 12:24:36.240 THREAD 29 SEVERE: ... 38 more
    2021-01-21 12:24:36.240 THREAD 29 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://SEPMANAGER:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.318 THREAD 29 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.". ClientConnectionId:50482edb-4d2a-4217-9265-864f0207e2fb
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3151)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1912)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2708)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2362)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2213)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1276)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDriverManager(DBConnectionProxy.java:414)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.MSJDBCDriver.getConnection(MSJDBCDriver.java:182)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.JDBCDriver.getDatabaseConnectionWithNTLMv2Retry(JDBCDriver.java:192)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDatabaseConnectionWithNTLMv2Retry(DatabaseUtilities.java:617)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.tryGetSQLExpressDbaConnection(SQLExpressDbHelper.java:1966)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.getSQLExpressDbaConnection(SQLExpressDbHelper.java:1994)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.migrationRestore(SQLExpressDbHelper.java:1886)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:359)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:147)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:248)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/java.lang.Thread.run(Thread.java:834)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: Caused by: javax.net.ssl.SSLHandshakeException: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:326)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:269)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:645)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:464)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:360)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:444)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:422)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:183)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1144)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1055)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:395)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1820)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: ... 19 more
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: Caused by: java.security.cert.CertificateException: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel$HostNameOverrideX509TrustManager.validateServerNameInCertificate(IOBuffer.java:1595)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel$HostNameOverrideX509TrustManager.checkServerTrusted(IOBuffer.java:1506)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1510)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:629)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: ... 30 more
    2021-01-21 12:24:36.318 THREAD 29 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://SEPMANAGER:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: exception retrieving connection
    2021-01-21 12:24:36.318 THREAD 29 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.". ClientConnectionId:0109b14b-ccf4-43e0-859f-ec8f6923249d
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3151)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1912)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2708)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2362)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2213)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1276)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:861)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDriverManager(DBConnectionProxy.java:414)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.MSJDBCDriver.getConnection(MSJDBCDriver.java:182)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.JDBCDriver.getDatabaseConnectionWithNTLMv2Retry(JDBCDriver.java:192)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDatabaseConnectionWithNTLMv2Retry(DatabaseUtilities.java:617)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.tryGetSQLExpressDbaConnection(SQLExpressDbHelper.java:1966)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.getSQLExpressDbaConnection(SQLExpressDbHelper.java:1997)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.migrationRestore(SQLExpressDbHelper.java:1886)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:359)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:147)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:248)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/java.lang.Thread.run(Thread.java:834)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: Caused by: javax.net.ssl.SSLHandshakeException: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.Alert.createSSLException(Alert.java:131)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:326)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:269)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.fatal(TransportContext.java:264)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:645)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.onCertificate(CertificateMessage.java:464)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.consume(CertificateMessage.java:360)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLHandshake.consume(SSLHandshake.java:392)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:444)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.HandshakeContext.dispatch(HandshakeContext.java:422)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.TransportContext.dispatch(TransportContext.java:183)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:164)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1144)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.readHandshakeRecord(SSLSocketImpl.java:1055)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:395)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1820)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: ... 19 more
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: Caused by: java.security.cert.CertificateException: Failed to validate the server name in a certificate during Secure Sockets Layer (SSL) initialization.
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel$HostNameOverrideX509TrustManager.validateServerNameInCertificate(IOBuffer.java:1595)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at com.microsoft.sqlserver.jdbc.TDSChannel$HostNameOverrideX509TrustManager.checkServerTrusted(IOBuffer.java:1506)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:1510)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: at java.base/sun.security.ssl.CertificateMessage$T12CertificateConsumer.checkServerCerts(CertificateMessage.java:629)
    2021-01-21 12:24:36.318 THREAD 29 SEVERE: ... 30 more
    2021-01-21 12:24:36.318 THREAD 29 INFO: ServerXml> restoreServerROOTXmlBackupFiles>> Is ROOT.xml file was restored!
    2021-01-21 12:24:36.318 THREAD 29 INFO: ServerXml> restoreServerROOTXmlBackupFiles>> Is ROOT.xml file was restored!
    2021-01-21 12:24:36.334 THREAD 29 WARNING: migrationRestoreTableSizePrint>> Table Size:
    CONTENT_EVENTS: -1ROWS 1.14MB
    COMPUTER_APPLICATION: -1ROWS 0.46MB
    SEM_APPLICATION: -1ROWS 0.63MB
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: java.sql.SQLException: Can not get DBA connection
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.getSQLExpressDbaConnection(SQLExpressDbHelper.java:2002)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at com.sygate.scm.server.db.util2.SQLExpressDbHelper.migrationRestore(SQLExpressDbHelper.java:1886)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:359)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:147)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:248)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: at java.base/java.lang.Thread.run(Thread.java:834)
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: Upgrade.doUpgrade java.sql.SQLException: Can not get DBA connection
    2021-01-21 12:24:36.334 THREAD 29 INFO: ServerXml> deleteBackupFile>> backup file does not exist.
    2021-01-21 12:24:36.334 THREAD 29 INFO: ServerXml> deleteServerROOTXmlBackupFiles>> Is ROOT.xml.bak file deleted ? false
    2021-01-21 12:24:36.334 THREAD 29 INFO: ServerXml> deleteBackupFile>> backup file does not exist.
    2021-01-21 12:24:36.334 THREAD 29 INFO: ServerXml> deleteServerROOTXmlBackupFiles>> Is Server.xml.bak file deleted ? false
    2021-01-21 12:24:36.334 THREAD 29 WARNING: Upgrade> doUpgrade>> Upgrade process completed in (ms) : 98767
    2021-01-21 12:24:36.334 THREAD 29 SEVERE: auditUpgradeEvent failed to log upgrade
    2021-01-21 12:24:36.334 THREAD 29 WARNING: java.sql.SQLException: SEM: Connect to database failed
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:539)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:448)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:417)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:405)
    at com.sygate.scm.server.upgrade.Upgrade.auditUpgradeEvent(Upgrade.java:2562)
    at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:1877)
    at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:147)
    at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:248)
    at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:151)
    at java.base/java.lang.Thread.run(Thread.java:834)
    Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or in an application resource file: java.naming.factory.initial
    at java.naming/javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:691)
    at java.naming/javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:305)
    at java.naming/javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:342)
    at java.naming/javax.naming.InitialContext.lookup(InitialContext.java:409)
    at com.sygate.scm.server.db.util.DBConnectionProxy.getDataSource(DBConnectionProxy.java:235)
    at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionBasedOnDataSource(DBConnectionProxy.java:248)
    at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDataSource(DBConnectionProxy.java:332)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:470)
    ... 9 more

    2021-01-21 12:24:36.349 THREAD 23 INFO: MainFrame>> doInitFinalPanel> Upgrade.serviceInstallState = 0
    2021-01-21 12:25:41.194 THREAD 23 INFO: Upgrade> updateVSICorSVAClientExistsOrNotStatus>> Started. started@ 1611228341194ms
    2021-01-21 12:25:41.226 THREAD 23 INFO: UpgradeFinalPanel> updateVSICClientWarning>> exception:
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: com.sygate.scm.server.metadata.MetadataException:
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1590)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1548)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1603)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doVSICorSVAClientExists(Upgrade.java:1959)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeFinalPanel.updateVSICClientWarning(UpgradeFinalPanel.java:641)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame.getStagePanel(MainFrame.java:428)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame.showWizard(MainFrame.java:396)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:351)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame$2.actionPerformed(MainFrame.java:261)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.processMouseEvent(Component.java:6631)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.processEvent(Component.java:6396)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Container.processEvent(Container.java:2263)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5007)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.dispatchEvent(Component.java:4839)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2772)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.dispatchEvent(Component.java:4839)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.AccessController.doPrivileged(Native Method)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.AccessController.doPrivileged(Native Method)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: Caused by: java.sql.SQLException: SEM: Connect to database failed
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:539)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:448)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:417)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:405)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1588)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: ... 43 more
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or in an application resource file: java.naming.factory.initial
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:691)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:305)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:342)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.InitialContext.lookup(InitialContext.java:409)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getDataSource(DBConnectionProxy.java:235)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionBasedOnDataSource(DBConnectionProxy.java:248)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDataSource(DBConnectionProxy.java:332)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:470)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: ... 47 more
    2021-01-21 12:25:41.226 THREAD 23 INFO: Upgrade> updateVSICorSVAClientExistsOrNotStatus>> Started. started@ 1611228341226ms
    2021-01-21 12:25:41.226 THREAD 23 INFO: UpgradeFinalPanel> updateVSICClientWarning>> exception:
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: com.sygate.scm.server.metadata.MetadataException:
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1590)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1548)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnection(MetadataManager.java:1603)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doVSICorSVAClientExists(Upgrade.java:1959)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeFinalPanel.updateVSICClientWarning(UpgradeFinalPanel.java:641)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame.getStagePanel(MainFrame.java:428)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame.showWizard(MainFrame.java:397)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:351)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.upgrade.ui.MainFrame$2.actionPerformed(MainFrame.java:261)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.processMouseEvent(Component.java:6631)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.processEvent(Component.java:6396)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Container.processEvent(Container.java:2263)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5007)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.dispatchEvent(Component.java:4839)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2772)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.Component.dispatchEvent(Component.java:4839)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.AccessController.doPrivileged(Native Method)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.AccessController.doPrivileged(Native Method)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: Caused by: java.sql.SQLException: SEM: Connect to database failed
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:539)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:448)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:417)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:405)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1588)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: ... 43 more
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: Caused by: javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or in an application resource file: java.naming.factory.initial
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.spi.NamingManager.getInitialContext(NamingManager.java:691)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.InitialContext.getDefaultInitCtx(InitialContext.java:305)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.InitialContext.getURLOrDefaultInitCtx(InitialContext.java:342)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at java.naming/javax.naming.InitialContext.lookup(InitialContext.java:409)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getDataSource(DBConnectionProxy.java:235)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionBasedOnDataSource(DBConnectionProxy.java:248)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DBConnectionProxy.getConnectionFromDataSource(DBConnectionProxy.java:332)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:470)
    2021-01-21 12:25:41.226 THREAD 23 SEVERE: ... 47 more
    2021-01-21 12:25:55.473 THREAD 23 INFO: Utility>> runScmHelper: props#0, File=C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\scmhelper_1611228355426.ini
    2021-01-21 12:25:55.473 THREAD 23 INFO: Utility>> runScmHelper: props#1, Command=SetRegistryForSymQual
    2021-01-21 12:25:55.473 THREAD 23 INFO: Utility>> runScmHelper: props#2, ErrorCode=0
    2021-01-21 12:25:55.473 THREAD 23 INFO: Utility>> runScmHelper: OK!
    2021-01-21 12:25:55.473 THREAD 23 INFO: UpgradeFinalPanel> saveStage>> Launching log file...


  • 2.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-01-2021 12:12 PM
    Looks like you may be hitting the same issue I just hit:

    Upgrade Wizard fails with Warning: Failed to create audit log event for this Server (broadcom.com)

    I was going to try the workaround in the resolution section, but when I look at my root.xml file, trustServerCertificate doesn't even exist in the url parameter.


  • 3.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-02-2021 02:30 AM
    hi Jason,
    yes support ha suggested the same KB.
    we tried to follow it and among other things, intervening on the certificate to be sure to have distributed it to all clients was a very time expensive operation. In the end we then repeated the upgrade and it failed again. We have a ticket open for a couple of weeks, we rolled back to the 14.3mp1 version 4 times, all following the instructions provided by the support. We are currently unable to update at 14.3ru1 an very very tired of this situation.


  • 4.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-03-2021 04:11 AM
    Edited by Wayne1 02-03-2021 04:11 AM
    Same here and I'm shocked that the resolution in the KB means "Perform a Disaster Recovery to the previous version"!
    That's not a solution, that's always the Worst-Case-Scenario" and they could solve it in a way better professional manner than that!
    Is this now the consequence of Broadcom?
    And we are still not able to upgrade, also have restored plenty times, always the same, doesn't matter how often we created a new Certificate.





  • 5.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-16-2021 11:02 PM
    Any news about this topic? I have the same problem here....


  • 6.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-18-2021 04:53 PM
    I am 1 for 2 on this upgrade. Just created a case on this. Waiting for a call back.


  • 7.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-18-2021 04:52 PM
    Support told me to uninstall and reinstall previous version. Glad I exported all my policies.


  • 8.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-18-2021 04:52 PM
    I will never go to any RU again.


  • 9.  RE: upgrade to SEPM 14.3ru1 failed

    Posted 02-24-2021 02:57 AM
    Facing the same issue, support told me to reinstall SEPM and restore the database and server certificate..

    Any news?


  • 10.  RE: upgrade to SEPM 14.3ru1 failed

    Broadcom Employee
    Posted 02-24-2021 09:29 AM
    Hello,

    I would wait for ru1mp1 to be released in the future.  I dont have an eta on that but should contain the code fix for the issue listed in the thread.  To validate you have this issue you would need to create a support case and work with that technician.

    Ron