I have two primary SEPM servers 11.0.5002.333 configured for load balancing using MS SQL 2005 server for the database. They server more than 2000 clients. I've tried upgrading to 11.0.6A today but the following error occured during the server configuration wizard:
"
Server HomeC:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat
Has valid SAV license
Has valid SNAC license
Config schema format is upgraded from: 11.0.3.0
Launch FRame
net stop semsrv
execCommandFromScript cmdSeparator;;
SQL Exception:
SQL Command: IF NOT EXISTS (SELECT C.NAME FROM SYSOBJECTS S, SYSCOLUMNS C WHERE C.ID=S.ID AND S.NAME='ALERTS' AND C.NAME = 'LOCAL_HOST_IP' )BEGIN ALTER TABLE ALERTS ADD LOCAL_HOST_IP bigint NULL DEFAULT 0 END
SQLState: S1000
Message: Cannot find the object "ALERTS" because it does not exist or you do not have permissions.
Vendor: 1088
java.sql.SQLException: Cannot find the object "ALERTS" because it does not exist or you do not have permissions.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:364)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2754)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2195)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:625)
at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:483)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:445)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:623)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1042)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:999)
at com.sygate.scm.server.db.util.DatabaseUtilities.execCommandFromScript(DatabaseUtilities.java:1253)
at com.sygate.scm.server.db.util.DbHelper.execCommandFromScript(DbHelper.java:188)
at com.sygate.scm.server.db.util.SqlDbHelper.upgrade(SqlDbHelper.java:316)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1083)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:288)
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: java.sql.SQLException: Cannot find the object "ALERTS" because it does not exist or you do not have permissions.
at com.sygate.scm.server.db.util.DatabaseUtilities.execCommandFromScript(DatabaseUtilities.java:1264)
at com.sygate.scm.server.db.util.DbHelper.execCommandFromScript(DbHelper.java:188)
at com.sygate.scm.server.db.util.SqlDbHelper.upgrade(SqlDbHelper.java:316)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1083)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:288)
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: java.sql.SQLException: Cannot find the object "ALERTS" because it does not exist or you do not have permissions.
at com.sygate.scm.server.db.util.SqlDbHelper.upgrade(SqlDbHelper.java:324)
at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1083)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:288)
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 ...
Does any one have an idea what does this mean ?