Video Screencast Help
Search Video Help Close Back
to help
Not able to make it to Vision this year? Get a sampling in the Best of Vision on Demand group.

Upgrade to RU6

Updated: 20 Oct 2010 | 2 comments
Chris Bulovic's picture
0 0 Votes
Login to vote

Hello all!

I have just tried upgrading to version 11.0.6 and, let me start by saying I messed it up! I forgot to delete replication on both partners and it's been a heck of a job getting things up and running again...

I'm nearly finished but have an issue I can't seem to get passed.
After the install is complete, the Management Server Upgrade runs and gets 80% through. This is an SQL 2008 and Server 2008 64-bit setup with 2 servers. Both servers have the same issue at this point..
It goes like this:
Initializing...Done
Database already has the latest schema (I successfully did that)
Importing packages...
Upgrading Templates...Done
Error Occurred.

Here is the log file:


Server HomeE:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat
Has valid SAV license
Info>> No SNAC license file in E:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\etc\license
Config schema format is upgraded from: 11.0.6.0
Launch FRame
net stop semsrv
 
Upgrade.reregisterLiveUpdateEntries.. Started
com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
java.lang.ClassNotFoundException: com.sygate.scm.util.i18n.ErrorMsg_en_NZ
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.sygate.scm.util.ErrorMsg.setLocale(ErrorMsg.java:229)
at com.sygate.scm.util.ErrorMsg.<clinit>(ErrorMsg.java:222)
at com.sygate.scm.server.util.ServerException.getMessage(ServerException.java:47)
at java.lang.Throwable.getLocalizedMessage(Throwable.java:267)
at java.lang.Throwable.toString(Throwable.java:343)
at java.lang.String.valueOf(String.java:2826)
at java.io.PrintStream.println(PrintStream.java:771)
at java.lang.Throwable.printStackTrace(Throwable.java:461)
at com.sygate.scm.server.util.ServerException.printStackTrace(ServerException.java:79)
at java.lang.Throwable.printStackTrace(Throwable.java:451)
at com.sygate.scm.server.util.ServerException.printStackTrace(ServerException.java:72)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:829)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:876)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
... 10 more
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:876)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
... 10 more
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:876)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
... 10 more
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:830)
at com.sygate.scm.server.upgrade.Upgrade.doUpgrade(Upgrade.java:617)
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)
Caused by: com.sygate.scm.server.util.ServerException: Unexpected server error.
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:876)
at com.sygate.scm.server.configmanager.ConfigManager.updateTopLevelObject(ConfigManager.java:673)
at com.sygate.scm.server.configmanager.ConfigManager.updateLuSesmContentCatalog(ConfigManager.java:2840)
at com.sygate.scm.server.util.LuServerUtility.updateLuSesmContentCatalogInDB(LuServerUtility.java:1513)
at com.sygate.scm.server.util.LuServerUtility.syncCatalogWithLuPackageContent(LuServerUtility.java:1236)
at com.sygate.scm.server.upgrade.Upgrade.reregisterLiveUpdateEntries(Upgrade.java:821)
... 5 more
Caused by: com.sygate.scm.server.metadata.MetadataException: No current row in the ResultSet.
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:183)
at com.sygate.scm.server.configmanager.ConfigManager.lockTopLevelObject(ConfigManager.java:874)
... 10 more
Caused by: java.sql.SQLException: No current row in the ResultSet.
at net.sourceforge.jtds.jdbc.JtdsResultSet.getColumn(JtdsResultSet.java:278)
at net.sourceforge.jtds.jdbc.JtdsResultSet.getLong(JtdsResultSet.java:647)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUsnInternal(DatabaseUtilities.java:753)
at com.sygate.scm.server.db.util.DatabaseUtilities.getLatestUSN(DatabaseUtilities.java:737)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:802)
at com.sygate.scm.server.db.util.DatabaseUtilities.lockRowByUsn(DatabaseUtilities.java:830)
at com.sygate.scm.server.metadata.BaseMetadataCollection.lockMetadata(BaseMetadataCollection.java:294)
at com.sygate.scm.server.metadata.MetadataManager.lockMetadata(MetadataManager.java:181)
... 11 more
Launching log file ...
 

I'm really keen to finish this baby up and see what is left to fix! Can someone tell me what fails? I'm guessing it's SQL because of the "No current row in the ResultSet" error...

Thanks heaps :)

Comments

zer0's picture
15
Apr
2010
2 Votes +2
Login to vote

Do you have a backup of your

Do you have a backup of your database, keystore and server certificates?
If you do, I would just restore from scratch:

- Recover database backup
- install fresh SEPM's with the same name/ip address as before
- Restore server cert

It is a very easy process once you have done it a couple of times and is usually a lot quicker than troubleshooting broken installs.
Even quicker if it is all virtualised and you have snap shots etc.

Check here: http://service1.symantec.com/support/ent-security....

Good luck!

Chris Bulovic's picture
19
Apr
2010
0 Votes 0
Login to vote

Well, I ended up opting for

Well, I ended up opting for the disaster recovery scenario - all is up and running again :)