Endpoint Protection

 View Only

  • 1.  Upgrade to Symantec_Endpoint_Protection_11.0.6A_Xplat failed on a load balanced servers

    Posted May 03, 2010 03:09 AM
    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 ?


  • 2.  RE: Upgrade to Symantec_Endpoint_Protection_11.0.6A_Xplat failed on a load balanced servers

    Posted May 03, 2010 03:15 AM
    Before doing the upgrade process you have to first delete all replication partners then stop the SEPM service in both the servers and you have to upgrade it one by one by one .Do you done like this only?


  • 3.  RE: Upgrade to Symantec_Endpoint_Protection_11.0.6A_Xplat failed on a load balanced servers

    Posted May 03, 2010 03:23 AM
    Of course I've deleted all replication partners and stopped the SEPM services on both primary servers before performing the upgrade. As I see it in the log, it is not an installation issue, but a configuration one.

    You should see the message "Message:  Cannot find the object "ALERTS" because it does not exist or you do not have permissions". I think it is a tablespace in the database that something is wrong with it.