db backup issues

db backup issues

I've been trying to backup OpManager 8 so it could be set up on a new server, but when attempting to run the db backup script, I get a series of warnings and java errors. Here's a copy of the output:


 C:\Program Files\AdventNet\ME\OpManager\bin\backup>backupdb.bat


Please wait ! Backup in Progress..................... |Jun 8, 2009 7:40:46 AM co
m.adventnet.db.persistence.metadata.parser.DataDictionaryParser getPrimaryKey
WARNING: The PKName :: TempDependentUnavailableHourly_PK of tableName :: TempDep
endentUnavailableHourly has 33 characters.
Jun 8, 2009 7:40:46 AM com.adventnet.db.persistence.metadata.parser.DataDictiona
ryParser getPrimaryKey
WARNING: The PKName :: ProcessInstanceCountThreshold_PK of tableName :: ProcessI
nstanceCountThreshold has 32 characters.
Jun 8, 2009 7:40:46 AM com.adventnet.db.persistence.metadata.parser.DataDictiona
ryParser getForeignKey
WARNING: The FKName :: ProcessInstanceCountThreshold_FK of tableName :: ProcessI
nstanceCountThreshold has 32 characters.
/Jun 8, 2009 7:40:46 AM com.adventnet.db.persistence.metadata.parser.DataDiction
aryParser getPrimaryKey
WARNING: The PKName :: DefaultVOIPJitterSettingsTemplate_PK of tableName :: Defa
ultVOIPJitterSettingsTemplate has 36 characters.
Jun 8, 2009 7:40:46 AM com.adventnet.db.persistence.metadata.parser.DataDictiona
ryParser getForeignKey
WARNING: The FKName :: DefaultVOIPJitterSettingsTemplate_FK of tableName :: Defa
ultVOIPJitterSettingsTemplate has 36 characters.
/com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'opmanagerdb.statsda
ta_hourly_2007_11_03_11' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1332)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1467)
        at jdbc.BackUpImpl.getNumberOfRows(BackUpImpl.java:1402)
        at jdbc.BackUpImpl.getIterativeQueries(BackUpImpl.java:1359)
        at jdbc.BackUpImpl.getQueriesForTables(BackUpImpl.java:1335)
        at jdbc.BackUpImpl.backupInsertCommands(BackUpImpl.java:985)
        at jdbc.BackUpImpl.runBackUpThrowsException(BackUpImpl.java:501)
        at jdbc.BackUpImpl.main(BackUpImpl.java:1630)
-com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'opmanagerdb.statsda
ta_hourly_2007_11_03_11' doesn't exist
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1332)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:
1467)
        at jdbc.BackUpImpl.fillInsertStrings(BackUpImpl.java:1440)
        at jdbc.BackUpImpl.backupInsertCommands(BackUpImpl.java:994)
        at jdbc.BackUpImpl.runBackUpThrowsException(BackUpImpl.java:501)
        at jdbc.BackUpImpl.main(BackUpImpl.java:1630)
java.lang.Exception: Error writing queries to file
\       at jdbc.BackUpImpl.fillInsertStrings(BackUpImpl.java:1539)
        at jdbc.BackUpImpl.backupInsertCommands(BackUpImpl.java:994)
        at jdbc.BackUpImpl.runBackUpThrowsException(BackUpImpl.java:501)
        at jdbc.BackUpImpl.main(BackUpImpl.java:1630)
Exception in thread "main" java.lang.Exception: Error writing queries to file
        at jdbc.BackUpImpl.fillInsertStrings(BackUpImpl.java:1539)
        at jdbc.BackUpImpl.backupInsertCommands(BackUpImpl.java:994)
        at jdbc.BackUpImpl.runBackUpThrowsException(BackUpImpl.java:501)
        at jdbc.BackUpImpl.main(BackUpImpl.java:1630)

































































It just hangs at the end of this, never going back to the command prompt or anything. I've tried running the DB Repair script, which completed successfully, but the backup script didn't perform differently.

Is there any other way to create a clean backup of all the servers and settings within OpManager? If not and this is the only way, I'd appreciate any advice that could help resolve this issue. Thanks.





                  New to ADSelfService Plus?