Endpoint Protection

 View Only

  • 1.  SEPM 11RU6a Upgrade to MP1 Errors

    Posted Dec 02, 2010 02:08 PM

    Hi all I've tried to recently upgrade to MP1 from RU6a  but am having a lot of problems getting this working.

    Every time attempt to login via the SEPM Console get the following error 

    "You cannot log on to the console because the server is not synchronised with the database Upgrade the Server, and then log on to the console"

     

    SQL is of box and everything was working with RU6a no problems but though as new udpate out should be easy to follow as had earlier upgraded from 6 to ru6a.

     

    Attempted the upgrade but get initialising errors. and the following.

    Then tried the upgrade.bat but the same error message as below occurs when attempting to install always occurs around 10%

     

    The SQL is offbox and called Symantec_Endpoint can confirm odbc connections work to it as it allows for me to test data source and also go through the management configuration Wizard again which completes successfully.

     

    So then took a backup of the Private Key Folder un-installed SEPM and then installed MP1 the installation completed successfully but still receive the error when logging into the console.!

     

    Please Help!!

     

     

    Looking at the log file I do not understand why it is looking for the SEM_CLIENT?

     

     Server HomeD:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat

    Has valid SAV license
    Info>> No SNAC license file in D:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\license
    Config schema format is upgraded from: 11.0.6.0
    Launch FRame
    net stop semsrv
     
     
     
     
     
    execCommandFromScript cmdSeparator;;
    SQL Exception:
    SQL Command: IF NOT EXISTS (SELECT NAME FROM SYSINDEXES WHERE NAME = 'I_SEM_CLIENT_HASH' ) BEGIN CREATE INDEX I_SEM_CLIENT_HASH ON SEM_CLIENT(HASH) END
    SQLState:  S1000
    Message:  Cannot find the object "SEM_CLIENT" because it does not exist or you do not have permissions.
    Vendor:  1088
    java.sql.SQLException: Cannot find the object "SEM_CLIENT" 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:321)
    at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1094)
    at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:289)
    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 "SEM_CLIENT" 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:321)
    at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1094)
    at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:289)
    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 "SEM_CLIENT" because it does not exist or you do not have permissions.
    at com.sygate.scm.server.db.util.SqlDbHelper.upgrade(SqlDbHelper.java:329)
    at com.sygate.scm.server.upgrade.Upgrade.upgradeDatabaseSchema(Upgrade.java:1094)
    at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:289)
    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 ...


  • 2.  RE: SEPM 11RU6a Upgrade to MP1 Errors

    Posted Dec 02, 2010 02:57 PM

    Have uninstalled again rebooted and installed MP2 now install was successful connected to database had to install as additional management server on same site server but still same issue ran update.bat same errors :( 



  • 3.  RE: SEPM 11RU6a Upgrade to MP1 Errors

    Posted Dec 02, 2010 03:16 PM

    How many other SEPMs do you have ?

    You can install SEPM and point it to the SQL database.



  • 4.  RE: SEPM 11RU6a Upgrade to MP1 Errors

    Posted Dec 02, 2010 05:40 PM

    This was the only SEPM.

     

    it is pointing correctly to the SQL database as I can run a odbc connection test successfully.

     

    but SEPM Console still shows "You cannot log onto the console because the server is not synchronized with the database."



  • 5.  RE: SEPM 11RU6a Upgrade to MP1 Errors

    Posted Dec 02, 2010 05:58 PM

    Run Management server configuration wizard once..



  • 6.  RE: SEPM 11RU6a Upgrade to MP1 Errors

    Posted Dec 02, 2010 07:30 PM

    ran the mangement server configuration wizard which completes successfully but still unable to log back into the console.

    Have given up for now with install MP1 or MP2 both of which have been failures.

    Have reinstalled RU6a and have been able to log back into the console now

     

    Now a new problem looks to be occuring Clients in SEPM are showing the green dot but when checking the clients themselves no green dot they are not even looking at the right policy location.  6000 Clients there is going to be no chance im going to run the sylink tool on each client!!!

     

    Policies on client and on sepm match but no green dot to confirm sync between client and SEPM. 



  • 7.  RE: SEPM 11RU6a Upgrade to MP1 Errors
    Best Answer

    Posted Dec 03, 2010 12:49 PM

    Resolved!

     

    Ran the Management Server Certificate merge from with SEPM > ADMIN imported the previous Private key and now the clients have started to respond!!