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.