Endpoint Protection Manager upgrade fails during the database migration
Article ID: 164664
Updated On:
Products
Issue/Introduction
When attempting to upgrade the Symantec Endpoint Protection Manager (SEPM) to 14.0, the upgrade fails during the database migration of the embedded database.
The following error is seen in the upgrade log:
2017-02-15 03:24:13.180 THREAD 22 WARNING: Upgrade> createReporterRole>> Add report user!
2017-02-15 03:24:13.181 THREAD 22 INFO: ServerUtil>createReporterRole>ENTER CREATE REPORTER ROLE
2017-02-15 03:24:13.841 THREAD 22 INFO: ServerUtil>createReporterRole>Created user REPORTER_DBA
2017-02-15 03:24:13.897 THREAD 22 INFO: ServerUtil>createReporterRole>granted connect REPORTER_DBA
2017-02-15 03:24:13.899 THREAD 22 SEVERE: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]System Privileges and Roles feature is not supported in this database
2017-02-15 03:24:13.899 THREAD 22 SEVERE: at sybase.jdbc4.sqlanywhere.IIStatement.nativeExecuteUpdate(Native Method)
2017-02-15 03:24:13.899 THREAD 22 SEVERE: at sybase.jdbc4.sqlanywhere.IIStatement.executeUpdate(IStatement.java:563)
2017-02-15 03:24:13.899 THREAD 22 SEVERE: at sybase.jdbc4.sqlanywhere.IStatement.executeUpdate(IStatement.java:312)
2017-02-15 03:24:13.899 THREAD 22 SEVERE: at com.sygate.scm.server.util.ServerUtil.createReporterRole(ServerUtil.java:1624)
2017-02-15 03:24:13.899 THREAD 22 SEVERE: at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:1863)
2017-02-15 03:24:13.900 THREAD 22 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:123)
2017-02-15 03:24:13.900 THREAD 22 SEVERE: at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:251)
2017-02-15 03:24:13.900 THREAD 22 SEVERE: at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
2017-02-15 03:24:13.900 THREAD 22 SEVERE: at java.lang.Thread.run(Thread.java:745)
You may see additional errors as below in the Upgrade log:
2017-04-25 11:03:47.042 THREAD 23 WARNING: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]Not allowed while 'DBA' is using the database
at sybase.jdbc4.sqlanywhere.IIStatement.execute(Native Method)
at sybase.jdbc4.sqlanywhere.IStatement.execute(IStatement.java:327)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDBBinaryFileFormat(Upgrade.java:5245)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:453)
at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:123)
at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:251)
at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
at java.lang.Thread.run(Thread.java:745)
2017-02-15 05:51:21.947 THREAD 30 WARNING: java.sql.SQLException: [Sybase][JDBC Driver][SQL Anywhere]User ID 'REPORTER' does not exist
at sybase.jdbc4.sqlanywhere.IIStatement.nativeExecuteUpdate(Native Method)
at sybase.jdbc4.sqlanywhere.IIStatement.executeUpdate(IStatement.java:563)
at sybase.jdbc4.sqlanywhere.IStatement.executeUpdate(IStatement.java:312)
at com.sygate.scm.server.util.ServerUtil.grantReporterRightsForEmbedded(ServerUtil.java:1690)
at com.sygate.scm.server.util.ServerUtil.createReporterRole(ServerUtil.java:1650)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:1863)
at com.sygate.scm.server.upgrade.ui.UpgradeTask.go(UpgradeTask.java:123)
at com.sygate.scm.server.upgrade.ui.UpgradeProgressPanel$2.construct(UpgradeProgressPanel.java:251)
at com.sygate.scm.util.SwingWorker$2.run(SwingWorker.java:159)
at java.lang.Thread.run(Thread.java:745)
Cause
This error can occur if another process is accessing the embedded database during the upgrade. (For example, "ArcSight Symantec Endpoint Protection DB" service)
Resolution
Ensure that all services and processes that may access the embedded database are disabled before upgrading the Symantec Endpoint Protection Manager.
Feedback
