HI all.
I'm try to upgrade our server to RU5 but i've got an error where upgrading the database:
Server HomeC:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat
initDatasource dbport:2638
Config schema format is upgraded from: 11.0.0.1
Launch FRame
net stop semsrv
initDatasource dbport:2638
Le service Base de donn?es int?gr?e Symantec s'arr?te.
Le service Base de donn?es int?gr?e Symantec a ?t? arr?t?.
Adaptive Server Anywhere Service Utility Version 9.0.2.3654
Service "sem5" was created successfully.
C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\..\bin\ServiceUtil.exe -service ASANYs_sem5 -setservicerecovery
net start ASANYs_sem5
Le service Base de donn?es int?gr?e Symantec d?marre.
Le service Base de donn?es int?gr?e Symantec a d?marr?.
Has valid SAV license
Info>> No SNAC license file in C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\license
execCommandFromScript cmdSeparator;;
SQL Exception:
SQL Command: ALTER TABLE ANOMALYDETECTIONS ADD ID CHAR(32) NOT NULL DEFAULT upper(replace(newid(),'-',''))
SQLState: 52010
Message: ASA Error -110: Item 'ID' already exists
Vendor: 12006
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -110: Item 'ID' already exists
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:3277)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2544)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc2.jdbc.SybStatement.updateLoop(SybStatement.java:1720)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1703)
at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:444)
at com.sygate.scm.server.db.util.DatabaseUtilities.execCommandFromScript(DatabaseUtilities.java:1241)
at com.sygate.scm.server.db.util.DbHelper.execCommandFromScript(DbHelper.java:170)
at com.sygate.scm.server.db.util.EmbededDbHelper.upgrade(EmbededDbHelper.java:194)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1014)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:271)
at com.sygate.scm.server.upgrade.ui.UpgradeTask$ActualTask.<init>(UpgradeTask.java:190)
at com.sygate.scm.server.upgrade.ui.UpgradeTask$1.construct(UpgradeTask.java:95)
at com.sygate.scm.server.upgrade.ui.SwingWorker$2.run(SwingWorker.java:121)
at java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -110: Item 'ID' already exists
at com.sygate.scm.server.db.util.DatabaseUtilities.execCommandFromScript(DatabaseUtilities.java:1252)
at com.sygate.scm.server.db.util.DbHelper.execCommandFromScript(DbHelper.java:170)
at com.sygate.scm.server.db.util.EmbededDbHelper.upgrade(EmbededDbHelper.java:194)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1014)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:271)
at com.sygate.scm.server.upgrade.ui.UpgradeTask$ActualTask.<init>(UpgradeTask.java:190)
at com.sygate.scm.server.upgrade.ui.UpgradeTask$1.construct(UpgradeTask.java:95)
at com.sygate.scm.server.upgrade.ui.SwingWorker$2.run(SwingWorker.java:121)
at java.lang.Thread.run(Thread.java:619)
java.sql.SQLException: Failed to upgrade schema: java.sql.SQLException: com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -110: Item 'ID' already exists
at com.sygate.scm.server.db.util.EmbededDbHelper.upgrade(EmbededDbHelper.java:235)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1014)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:271)
at com.sygate.scm.server.upgrade.ui.UpgradeTask$ActualTask.<init>(UpgradeTask.java:190)
at com.sygate.scm.server.upgrade.ui.UpgradeTask$1.construct(UpgradeTask.java:95)
at com.sygate.scm.server.upgrade.ui.SwingWorker$2.run(SwingWorker.java:121)
at java.lang.Thread.run(Thread.java:619)
Launching log file ...
Someone get this error too?
Best regards.
Eric B.