Endpoint Protection

 View Only
Expand all | Collapse all

SEPM 14.2 to 14.3 RU6 upgrade - Fails to connect to new SQL Express database

  • 1.  SEPM 14.2 to 14.3 RU6 upgrade - Fails to connect to new SQL Express database

    Posted Nov 23, 2022 09:15 AM
    Hi!

    Anyone had similar issues when upgrading ?
    I've seen some similar posts but not any great solutions.. Any help would be greatly appreciated!

    I'll post my errorlog here : 

    2022-11-23 12:18:42.327 THREAD 1 SEVERE: ================== Server Environment ===================
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: os.name = Windows Server 2019
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: os.version = 10.0
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: os.arch = x64
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: java.version = 11.0.16
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: java.vendor = Eclipse Adoptium
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: java.vm.name = OpenJDK 64-Bit Server VM
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: java.vm.version = 11.0.16+8
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: java.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\jre11
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: catalina.home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: java.user = null
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: user.language = en
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: user.country = US
    2022-11-23 12:18:42.327 THREAD 1 SEVERE: scm.server.version = 14.3.9205.6000
    2022-11-23 12:18:42.327 THREAD 1 INFO: Main> Main>> Checking upgrade arguments... Command-line argument is empty.
    2022-11-23 12:18:42.327 THREAD 1 INFO: Main> Main>> Server Home = C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
    2022-11-23 12:18:42.358 THREAD 1 INFO: ServerXml>> verifyAndRetrieveROOTXml>> Verifying ROOT.xml...
    2022-11-23 12:18:42.390 THREAD 1 INFO: ServerXml>> verifyAndRetrieveXmlFile>> .xml file is valid, deleting backup file...
    2022-11-23 12:18:42.390 THREAD 1 INFO: ServerXml>> verifyAndRetrieveXmlFile>> .xml file is valid, deleting backup file...
    2022-11-23 12:18:42.405 THREAD 1 INFO: create a new RootXMLHandler
    2022-11-23 12:18:42.405 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
    2022-11-23 12:18:42.405 THREAD 1 INFO: readJdbcParameters >> jdbcDriverClass: sybase.jdbc4.sqlanywhere.IDriver
    2022-11-23 12:18:42.452 THREAD 1 INFO: DatabaseUtilities> initDataSource>> jdbcDriverClass: sybase.jdbc4.sqlanywhere.IDriver
    2022-11-23 12:18:42.452 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Server has not been configured yet.
    2022-11-23 12:18:42.468 THREAD 1 INFO: DatabaseUtilities> initDataSource>> Can't initialize Datasource. Exception message = no match found for jdbc driver name
    2022-11-23 12:18:42.468 THREAD 1 INFO: Main> Main>> DataSource initialization failed. Cannot run the upgrade tool.
    2022-11-23 12:18:42.483 THREAD 1 INFO: verifyAndSetJre11FolderPermissions: Fisnished!
    2022-11-23 12:18:42.483 THREAD 1 INFO: applyAclsPreUpgrade: Finished!
    2022-11-23 12:18:42.483 THREAD 1 INFO: Main> Main>> Current DB schema version (14.3.6.6000), Testing DB connection... Current time = Wed Nov 23 12:18:42 CET 2022
    2022-11-23 12:18:42.546 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2022-11-23 12:18:42.546 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2022-11-23 12:18:42.546 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_FAILED
    2022-11-23 12:18:42.546 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:42.546 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:42.749 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2022-11-23 12:18:42.749 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2022-11-23 12:18:42.749 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_FAILED
    2022-11-23 12:18:42.749 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:42.749 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:42.765 THREAD 1 INFO: Main> executePreLaunchSteps>> dbConnected: false, isEmbeddedDb: false
    2022-11-23 12:18:42.765 THREAD 1 INFO: Main> executePreLaunchSteps>> Config schema format is getting upgraded from (schema version from upgrade backup properties created by installer): 14.2.2.2000
    2022-11-23 12:18:42.765 THREAD 1 INFO: Main> executePreLaunchSteps>>isTelemetryOptedInFromDB is (isTelemetryOptedInFromDB from upgrade backup properties created by installer): false
    2022-11-23 12:18:42.765 THREAD 1 INFO: Main> executePreLaunchSteps>> isTelemetryOptedInFromDB from upgrade backup properties:false
    2022-11-23 12:18:42.765 THREAD 1 INFO: Main> executePreLaunchSteps>> DbVersion: 14.2.2.2000 schemaVersionFromDB: 14.2.2.2000 isSpm51Mr7: false hasOtherOSAgents: false dbcompanySize: 2 dbConnected: false isTelemetryOptedInFromDB: false
    2022-11-23 12:18:42.765 THREAD 1 INFO: Main> checkUpgradeFeasibility>> Checking for upgrade feasibility, current schema version = 14.3.6.6000, schema version from db = 14.2.2.2000
    2022-11-23 12:18:42.765 THREAD 1 INFO: VersionToBeSupported: 14.2.2.2000
    2022-11-23 12:18:42.765 THREAD 1 INFO: SchemaVersion>> isSupported> versionToBeSupported '14.2.2.2000 is supported for this release
    2022-11-23 12:18:42.827 THREAD 1 INFO: SchemaVersion>> isSupported> ignored, semLocalSettingsFrom is null!
    2022-11-23 12:18:42.843 THREAD 1 INFO: Main> launchMainFrame>> isSpm51Mr7AndHasOtherOSAgents: false, isAutomated: false, dbServerVendor: null
    2022-11-23 12:18:42.999 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2022-11-23 12:18:42.999 THREAD 1 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2022-11-23 12:18:42.999 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_FAILED
    2022-11-23 12:18:42.999 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:42.999 THREAD 1 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:42.999 THREAD 1 INFO: SQL server with SQL Auth mode. Display User Credential panel
    2022-11-23 12:18:42.999 THREAD 1 INFO: ServerConfigurationRemediator >> needChooseLaunchServicePort >> needChooseLaunchServicePort=false serverVersionPreUpgrade=14.2.5323.2000
    2022-11-23 12:18:42.999 THREAD 1 INFO: MainFrame> MainFrame>> needToShowUpgradeServerPropPanel: false
    2022-11-23 12:18:43.030 THREAD 1 INFO: Privacy link = http://ced.broadcom.com/entt?product=sep&version=14.3.6000&language=english&module=console&error=sep_privacy&build=symantec_ent
    2022-11-23 12:18:43.202 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

    2022-11-23 12:18:43.249 THREAD 1 WARNING: SQLExpressDbHelper>>executePowshellCommand processing result: 1
    2022-11-23 12:18:43.249 THREAD 1 WARNING: DbUtil>>executePowshellCommand standard output:



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

    2022-11-23 12:18:46.201 THREAD 27 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2022-11-23 12:18:46.201 THREAD 27 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2022-11-23 12:18:46.201 THREAD 27 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_FAILED
    2022-11-23 12:18:46.201 THREAD 27 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:46.201 THREAD 27 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:46.233 THREAD 33 WARNING: Upgrade> doUpgrade>> Upgrade process started @ : 0
    2022-11-23 12:18:46.233 THREAD 33 INFO: Upgrade> doUpgrade>> Initializing upgrade steps...
    2022-11-23 12:18:46.233 THREAD 33 INFO: UpgradeStep >> checkUpgradeStatus.
    2022-11-23 12:18:46.233 THREAD 33 INFO: Upgrade> doUpgrade>> Initializing upgrade steps done!
    2022-11-23 12:18:46.233 THREAD 33 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2022-11-23 12:18:46.233 THREAD 33 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2022-11-23 12:18:46.233 THREAD 33 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_FAILED
    2022-11-23 12:18:46.248 THREAD 33 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:46.248 THREAD 33 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:46.248 THREAD 33 INFO: UpgradeStep >> checkUpgradeStatus.
    2022-11-23 12:18:46.248 THREAD 33 INFO: UpgradeStep >> checkUpgradeStatus.
    2022-11-23 12:18:46.248 THREAD 33 WARNING: SQLExpressDbHelper >> isInMigrationProcess, checking file: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\bin\migrationSummary.txt
    2022-11-23 12:18:46.248 THREAD 33 WARNING: SQLExpressDbHelper >> isInMigrationProcess, found target line!
    2022-11-23 12:18:46.248 THREAD 33 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: RESTORE_STATUS: RESTORE_FAILED
    2022-11-23 12:18:46.248 THREAD 33 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, line: DB_BACKUP_FILE: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:46.248 THREAD 33 INFO: SQLExpressDbHelper >> migrationGetSummary, key: DB_BACKUP_FILE, value: 2022-Nov-23_11-38-34.migration.zip
    2022-11-23 12:18:46.311 THREAD 33 INFO: The service name is invalid.More help is available by typing NET HELPMSG 2185.
    2022-11-23 12:18:46.326 THREAD 33 INFO: SemServiceManager> serviceControl>> Executed command - stop SQLANYs_sem5, process return value = 2
    2022-11-23 12:18:46.326 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: SQLANYs_sem5
    2022-11-23 12:18:46.326 THREAD 33 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service SQLANYs_sem5
    2022-11-23 12:18:46.358 THREAD 33 SEVERE: SemServiceManager> getServiceStatus>> Error code from sc query: 1060
    2022-11-23 12:18:46.358 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2022-11-23 12:18:46.358 THREAD 33 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2022-11-23 12:18:46.358 THREAD 33 INFO: ServerXml> backupServerROOTXmlFiles>> Is ROOT.xml.bak file created ? true
    2022-11-23 12:18:46.358 THREAD 33 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2022-11-23 12:18:46.358 THREAD 33 INFO: ServerXml> backupServerROOTXmlFiles>> Is Server.xml.bak file deleted ? true
    2022-11-23 12:18:46.358 THREAD 33 WARNING: SQLExpress Database Creating and Backup unzipping(mutiple threads)...
    2022-11-23 12:18:46.420 THREAD 33 WARNING: SQLExpress Database Creating and Backup unzipping(mutiple threads), cost(minutes): 0.0026, instanceName: SQLEXPRESSSYMC0, port: 2638, isDbCreatedBefore: true, backupFileUnzipDir: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\data\backup\2022-Nov-23_11-38-34.migration.zip-unzipped
    2022-11-23 12:18:46.420 THREAD 33 INFO: testingJdbcUrlServerName>> testing host name: WIN-12RU7281OTT\SQLEXPRESSSYMC0
    2022-11-23 12:18:46.436 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2022-11-23 12:18:46.436 THREAD 33 INFO: initializing DBConnectionProxy
    2022-11-23 12:18:46.436 THREAD 33 INFO: loading impersonate library
    2022-11-23 12:18:46.436 THREAD 33 INFO: successfully loaded impersonate library
    2022-11-23 12:18:46.436 THREAD 33 INFO: create a new RootXMLHandler
    2022-11-23 12:18:46.451 THREAD 33 INFO: readJdbcParameters >> jdbcURL: jdbc:sqlanywhere:CommLinks=Shmem,tcpip(dobroadcast=none;TO=60;host=127.0.0.1;port=2638;verify=no);ServerName=localhost
    2022-11-23 12:18:46.451 THREAD 33 INFO: readJdbcParameters >> jdbcDriverClass: sybase.jdbc4.sqlanywhere.IDriver
    2022-11-23 12:18:46.451 THREAD 33 INFO: DatabaseUtilities> initDataSource>> jdbcDriverClass: sybase.jdbc4.sqlanywhere.IDriver
    2022-11-23 12:18:46.451 THREAD 33 INFO: DatabaseUtilities> initDataSource>> Server has not been configured yet.
    2022-11-23 12:18:46.451 THREAD 33 INFO: Exception loading SQLSetLogin dll
    2022-11-23 12:18:46.451 THREAD 33 SEVERE: com.sygate.scm.util.db.JDBCDriverNotConfiguredException: no match found for jdbc driver name
    2022-11-23 12:18:46.654 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.670 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.670 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa due to: 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:6fcbd456-be02-430b-be3b-679a4705be2b
    2022-11-23 12:18:46.670 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2022-11-23 12:18:46.686 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.686 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.686 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA due to: 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:90192c77-8165-4727-9e0d-88dc75eadcc4
    2022-11-23 12:18:46.686 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2022-11-23 12:18:46.779 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.779 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.779 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa due to: 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:a72845ed-5ae4-4949-bdaa-7005629ae5c8
    2022-11-23 12:18:46.779 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2022-11-23 12:18:46.795 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.795 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.795 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA due to: 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:32f90f3a-624c-4093-a1d7-ad990b36cfff
    2022-11-23 12:18:46.795 THREAD 33 WARNING: testingJdbcUrlServerName>> Can not get DBA connection
    2022-11-23 12:18:46.795 THREAD 33 INFO: testingJdbcUrlServerName>> testing host name: WIN-12RU7281OTT\SQLEXPRESSSYMC0
    2022-11-23 12:18:46.795 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2022-11-23 12:18:46.811 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.811 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.811 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa due to: 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:7fe4703e-8e59-4399-94dd-ee715f4a8b76
    2022-11-23 12:18:46.811 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2022-11-23 12:18:46.811 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.811 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.811 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA due to: 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:f8d31b15-5070-446f-8c03-4e8302ac0257
    2022-11-23 12:18:46.811 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2022-11-23 12:18:46.842 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.842 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.842 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa due to: 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:8406c860-aefe-4b8b-8d54-b174ec51fe0f
    2022-11-23 12:18:46.857 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2022-11-23 12:18:46.857 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.857 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:46.857 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA due to: 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:a173a28d-2ed4-4a6d-b1cd-9aceb47058ae
    2022-11-23 12:18:46.857 THREAD 33 WARNING: testingJdbcUrlServerName>> Can not get DBA connection
    2022-11-23 12:18:46.857 THREAD 33 WARNING: testingJdbcUrlServerName>> use default host name: WIN-12RU7281OTT\SQLEXPRESSSYMC0
    2022-11-23 12:18:46.857 THREAD 33 WARNING: SQLExpress>>migrationRestore, Update ROOT.xml...
    2022-11-23 12:18:46.857 THREAD 33 INFO: ServerXml> createBackupFile>> Is existing backup file deleted ? true
    2022-11-23 12:18:46.857 THREAD 33 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2022-11-23 12:18:46.857 THREAD 33 INFO: ServerXml> backupServerROOTXmlFiles>> Is ROOT.xml.bak file created ? true
    2022-11-23 12:18:46.857 THREAD 33 INFO: ServerXml> createBackupFile>> Is existing backup file deleted ? true
    2022-11-23 12:18:46.857 THREAD 33 INFO: ServerXml> createBackupFile>> Is backup file created ? true
    2022-11-23 12:18:46.857 THREAD 33 INFO: ServerXml> backupServerROOTXmlFiles>> Is Server.xml.bak file deleted ? true
    2022-11-23 12:18:46.951 THREAD 33 WARNING: SQLExpress>>migrationRestore, Updated ROOT.xml, instanceName: SQLEXPRESSSYMC0, port: 2638
    2022-11-23 12:18:46.951 THREAD 33 WARNING: SQLExpress>>migrationRestore, Update Site DB property and client tool path and restart SemLaunch Service...
    2022-11-23 12:18:46.967 THREAD 33 INFO: saveConfProp: done
    2022-11-23 12:18:47.014 THREAD 33 INFO: The Symantec Endpoint Protection Manager API Service service is not started.More help is available by typing NET HELPMSG 3521.
    2022-11-23 12:18:47.014 THREAD 33 INFO: SemServiceManager> serviceControl>> Executed command - stop semapisrv, process return value = 2
    2022-11-23 12:18:47.014 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semapisrv
    2022-11-23 12:18:47.014 THREAD 33 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semapisrv
    2022-11-23 12:18:47.045 THREAD 33 INFO: SemServiceManager> getServiceStatus>> The status for semapisrv' service is 1
    2022-11-23 12:18:47.045 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2022-11-23 12:18:47.092 THREAD 33 INFO: The Symantec Endpoint Protection Manager service is not started.More help is available by typing NET HELPMSG 3521.
    2022-11-23 12:18:47.107 THREAD 33 INFO: SemServiceManager> serviceControl>> Executed command - stop semsrv, process return value = 2
    2022-11-23 12:18:47.107 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semsrv
    2022-11-23 12:18:47.107 THREAD 33 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semsrv
    2022-11-23 12:18:47.139 THREAD 33 INFO: SemServiceManager> getServiceStatus>> The status for semsrv' service is 1
    2022-11-23 12:18:47.139 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2022-11-23 12:18:47.232 THREAD 33 INFO: The Symantec Endpoint Protection Launcher service was stopped successfully.
    2022-11-23 12:18:47.232 THREAD 33 INFO: SemServiceManager> serviceControl>> Executed command - stop semlaunchsrv, process return value = 0
    2022-11-23 12:18:47.232 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Waiting for service termination: semlaunchsrv
    2022-11-23 12:18:47.232 THREAD 33 INFO: SemServiceManager> getServiceStatus>> Retrieve status for service semlaunchsrv
    2022-11-23 12:18:47.295 THREAD 33 INFO: SemServiceManager> getServiceStatus>> The status for semlaunchsrv' service is 1
    2022-11-23 12:18:47.295 THREAD 33 INFO: SemServiceManager> waitForServiceTermination>> Service is stopped.
    2022-11-23 12:18:49.451 THREAD 33 INFO: The Symantec Endpoint Protection Launcher service is starting.The Symantec Endpoint Protection Launcher service was started successfully.
    2022-11-23 12:18:49.451 THREAD 33 INFO: SemServiceManager> serviceControl>> Executed command - start semlaunchsrv, process return value = 0
    2022-11-23 12:18:49.451 THREAD 33 INFO: UpgradeStep >> checkUpgradeStatus.
    2022-11-23 12:18:49.451 THREAD 33 INFO: UpgradeStep >> checkUpgradeStatus.
    2022-11-23 12:18:49.451 THREAD 33 WARNING: SQLExpress>>migrationRestore, Connecting to database by DBA...
    2022-11-23 12:18:49.451 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2022-11-23 12:18:49.482 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.482 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.482 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa due to: 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:e3ea6e69-f7a1-4f01-998f-c5a8d8e25b9b
    2022-11-23 12:18:49.482 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2022-11-23 12:18:49.482 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.482 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.482 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA due to: 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:69fbfb20-1bf6-4497-88a8-df07f21e4b7c
    2022-11-23 12:18:49.482 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: sa
    2022-11-23 12:18:49.529 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.529 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.529 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: sa due to: 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:a6308904-dbf8-4618-814b-0aa1b311f6cb
    2022-11-23 12:18:49.529 THREAD 33 INFO: getDatabaseConnectionWithNTLMv2Retry, jdbcURL: jdbc:sqlserver://WIN-12RU7281OTT:2638;instanceName=SQLEXPRESSSYMC0;integratedSecurity=false;encrypt=true;trustServerCertificate=false, user: DBA
    2022-11-23 12:18:49.529 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.529 THREAD 33 SEVERE: exception retrieving connection
    2022-11-23 12:18:49.529 THREAD 33 WARNING: tryGetSQLExpressDbaConnection: can not get exception for: DBA due to: 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:e00f4707-ddef-486b-903a-3c08d0919967
    2022-11-23 12:18:49.544 THREAD 33 INFO: ServerXml> restoreServerROOTXmlBackupFiles>> Is ROOT.xml file was restored!
    2022-11-23 12:18:49.544 THREAD 33 INFO: ServerXml> restoreServerROOTXmlBackupFiles>> Is ROOT.xml file was restored!
    2022-11-23 12:18:49.544 THREAD 33 WARNING: migrationRestoreTableSizePrint>> Table Size:
    AGENT_SECURITY_LOG_2: 2ROWS 0.01MB
    AGENT_TRAFFIC_LOG_2: 23694ROWS 14.59MB
    AGENT_SECURITY_LOG_1: 1ROWS 0.01MB
    AGENT_TRAFFIC_LOG_1: 49946ROWS 30.88MB
    SERVER_CLIENT_LOG_1: 6152ROWS 1.6MB
    SERVER_CLIENT_LOG_2: 9902ROWS 2.44MB
    CONTENT_EVENTS: 142ROWS 0.05MB
    COMPUTER_APPLICATION: 61ROWS 0.02MB
    SEM_APPLICATION: 60ROWS 0.02MB
    2022-11-23 12:18:49.544 THREAD 33 INFO: ServerXml> deleteBackupFile>> backup file does not exist.
    2022-11-23 12:18:49.544 THREAD 33 INFO: ServerXml> deleteServerROOTXmlBackupFiles>> Is ROOT.xml.bak file deleted ? false
    2022-11-23 12:18:49.544 THREAD 33 INFO: ServerXml> deleteBackupFile>> backup file does not exist.
    2022-11-23 12:18:49.544 THREAD 33 INFO: ServerXml> deleteServerROOTXmlBackupFiles>> Is Server.xml.bak file deleted ? false
    2022-11-23 12:18:49.544 THREAD 33 WARNING: Upgrade> doUpgrade>> Upgrade process completed in (ms) : 3311
    2022-11-23 12:18:49.560 THREAD 33 SEVERE: auditUpgradeEvent failed to log upgrade
    2022-11-23 12:18:49.560 THREAD 33 WARNING: java.sql.SQLException: SEM: Connect to database failed
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:528)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:444)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:413)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:401)
    at com.sygate.scm.server.upgrade.Upgrade.auditUpgradeEvent(Upgrade.java:2326)
    at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:1191)
    at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:156)
    at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:249)
    at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:147)
    at java.base/java.lang.Thread.run(Thread.java:829)
    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:702)
    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:466)
    ... 9 more

    2022-11-23 12:18:49.560 THREAD 27 INFO: MainFrame>> doInitFinalPanel> Upgrade.serviceInstallState = 0
    2022-11-23 12:18:53.669 THREAD 27 WARNING: CloudUtil.isEnrolled>> Unable to query EPMP Cloud enrollment details. Exception: com.sygate.scm.server.util.ServerException: Unexpected server error.
    2022-11-23 12:18:53.669 THREAD 27 INFO: Updating TelemetryOptions for server upgrade
    2022-11-23 12:18:53.669 THREAD 27 INFO: Privacy link = http://ced.broadcom.com/entt?product=sep&version=14.3.6000&language=english&module=console&error=sep_privacy&build=symantec_ent
    2022-11-23 12:18:53.684 THREAD 27 INFO: Updating TelemetryOptions for server upgrade done
    2022-11-23 12:18:53.684 THREAD 27 WARNING: CloudUtil.isEnrolled>> Unable to query EPMP Cloud enrollment details. Exception: com.sygate.scm.server.util.ServerException: Unexpected server error.
    2022-11-23 12:18:53.684 THREAD 27 INFO: Updating TelemetryOptions for server upgrade
    2022-11-23 12:18:53.684 THREAD 27 INFO: Privacy link = http://ced.broadcom.com/entt?product=sep&version=14.3.6000&language=english&module=console&error=sep_privacy&build=symantec_ent
    2022-11-23 12:18:53.684 THREAD 27 INFO: Updating TelemetryOptions for server upgrade done
    2022-11-23 12:18:57.230 THREAD 27 INFO: Telemetry opt-in status =false
    2022-11-23 12:18:57.246 THREAD 27 WARNING: com.sygate.scm.server.metadata.MetadataException:
    at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1612)
    at com.sygate.scm.server.metadata.MetadataManager.startTransaction(MetadataManager.java:132)
    at com.sygate.scm.server.metadata.MetadataManager.startTransaction(MetadataManager.java:121)
    at com.sygate.scm.server.configmanager.ConfigManager.startTransaction(ConfigManager.java:350)
    at com.sygate.scm.server.upgrade.ui.TelemetryPanel.saveStage(TelemetryPanel.java:125)
    at com.sygate.scm.server.upgrade.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:347)
    at com.sygate.scm.server.upgrade.ui.MainFrame$2.actionPerformed(MainFrame.java:264)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
    at java.desktop/java.awt.Component.processMouseEvent(Component.java:6635)
    at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342)
    at java.desktop/java.awt.Component.processEvent(Component.java:6400)
    at java.desktop/java.awt.Container.processEvent(Container.java:2263)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5011)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4843)
    at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918)
    at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
    at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2772)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4843)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(Native Method)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(Native Method)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
    Caused by: java.sql.SQLException: SEM: Connect to database failed
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:528)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:444)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:413)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:401)
    at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1610)
    ... 41 more
    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:702)
    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:466)
    ... 45 more
    com.sygate.scm.server.util.ServerException: Unexpected server error.
    at com.sygate.scm.server.configmanager.ConfigManager.startTransaction(ConfigManager.java:352)
    at com.sygate.scm.server.upgrade.ui.TelemetryPanel.saveStage(TelemetryPanel.java:125)
    at com.sygate.scm.server.upgrade.ui.MainFrame.nextBtnActionPerformed(MainFrame.java:347)
    at com.sygate.scm.server.upgrade.ui.MainFrame$2.actionPerformed(MainFrame.java:264)
    at java.desktop/javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1967)
    at java.desktop/javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2308)
    at java.desktop/javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:405)
    at java.desktop/javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:262)
    at java.desktop/javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:279)
    at java.desktop/java.awt.Component.processMouseEvent(Component.java:6635)
    at java.desktop/javax.swing.JComponent.processMouseEvent(JComponent.java:3342)
    at java.desktop/java.awt.Component.processEvent(Component.java:6400)
    at java.desktop/java.awt.Container.processEvent(Container.java:2263)
    at java.desktop/java.awt.Component.dispatchEventImpl(Component.java:5011)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2321)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4843)
    at java.desktop/java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4918)
    at java.desktop/java.awt.LightweightDispatcher.processMouseEvent(Container.java:4547)
    at java.desktop/java.awt.LightweightDispatcher.dispatchEvent(Container.java:4488)
    at java.desktop/java.awt.Container.dispatchEventImpl(Container.java:2307)
    at java.desktop/java.awt.Window.dispatchEventImpl(Window.java:2772)
    at java.desktop/java.awt.Component.dispatchEvent(Component.java:4843)
    at java.desktop/java.awt.EventQueue.dispatchEventImpl(EventQueue.java:772)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:721)
    at java.desktop/java.awt.EventQueue$4.run(EventQueue.java:715)
    at java.base/java.security.AccessController.doPrivileged(Native Method)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:95)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:745)
    at java.desktop/java.awt.EventQueue$5.run(EventQueue.java:743)
    at java.base/java.security.AccessController.doPrivileged(Native Method)
    at java.base/java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:85)
    at java.desktop/java.awt.EventQueue.dispatchEvent(EventQueue.java:742)
    at java.desktop/java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:203)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:124)
    at java.desktop/java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:113)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:109)
    at java.desktop/java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    at java.desktop/java.awt.EventDispatchThread.run(EventDispatchThread.java:90)
    Caused by: com.sygate.scm.server.metadata.MetadataException:
    at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1612)
    at com.sygate.scm.server.metadata.MetadataManager.startTransaction(MetadataManager.java:132)
    at com.sygate.scm.server.metadata.MetadataManager.startTransaction(MetadataManager.java:121)
    at com.sygate.scm.server.configmanager.ConfigManager.startTransaction(ConfigManager.java:350)
    ... 38 more
    Caused by: java.sql.SQLException: SEM: Connect to database failed
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:528)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:444)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:413)
    at com.sygate.scm.server.db.util.DatabaseUtilities.getDefaultDatabaseConnection(DatabaseUtilities.java:401)
    at com.sygate.scm.server.metadata.MetadataManager.getConnectionNoCheckRequireTransactionId(MetadataManager.java:1610)
    ... 41 more
    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:702)
    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:466)
    ... 45 more

    2022-11-23 12:18:57.246 THREAD 27 INFO: Upgrade> updateVSICorSVAClientExistsOrNotStatus>> Started. started@ 1669202337246ms
    2022-11-23 12:18:57.246 THREAD 27 INFO: UpgradeFinalPanel> updateVSICClientWarning>> exception:
    2022-11-23 12:18:57.246 THREAD 27 INFO: Upgrade> updateVSICorSVAClientExistsOrNotStatus>> Started. started@ 1669202337246ms
    2022-11-23 12:18:57.246 THREAD 27 INFO: UpgradeFinalPanel> updateVSICClientWarning>> exception:
    2022-11-23 12:18:58.730 THREAD 27 INFO: Utility>> runScmHelper: props#0, File=C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\bin\scmhelper_1669202338636.ini
    2022-11-23 12:18:58.730 THREAD 27 INFO: Utility>> runScmHelper: props#1, Command=SetRegistryForSymQual
    2022-11-23 12:18:58.730 THREAD 27 INFO: Utility>> runScmHelper: props#2, ErrorCode=0
    2022-11-23 12:18:58.730 THREAD 27 INFO: Utility>> runScmHelper: OK!
    2022-11-23 12:18:58.730 THREAD 27 INFO: UpgradeFinalPanel> saveStage>> Launching log file...


  • 2.  RE: SEPM 14.2 to 14.3 RU6 upgrade - Fails to connect to new SQL Express database

    Posted Nov 25, 2022 09:11 AM
    Hi,
    did you stop all SEP processes prior to upgrade?

    kind regards
    Damir