Invalid object name errors indicate that Uptime Infrastructure Monitor is not able to find required objects in the database. This is typically caused by one of the following problems:

  1. Uptime Infrastructure Monitor is pointing to the wrong db host or instance.
  2. The Uptime Infrastructure Monitor schema has not been initialized or the object doesn't actually exist.
  3. The Uptime Infrastructure Monitor database user doesn't have permissions to access the specified object.

Example stack trace from an uptime.log file:

2020-03-05 16:11:39,847 INFO (UptimeInstance:75) - up.time 4.6.25 R G starting... 2020-03-05 16:11:39,863 INFO (UptimeInstance:78) - © 2020 uptime software inc. 2020-03-05 16:11:39,878 INFO (UptimeInstance:79) - Starting up.time... 2020-03-05 16:11:39,878 INFO (UptimeInstance:81) - Java heap size: 1065484288 bytes 2020-03-05 16:11:40,800 INFO (UptimeInstance:159) - Checking database version... 2020-03-05 16:12:02,082 WARN (JDBCExceptionReporter:71) - SQL Error: 208, SQLState: 42S02 2020-03-05 16:12:02,082 ERROR (JDBCExceptionReporter:72) - Invalid object name 'dbversion'. 2020-03-05 16:12:02,097 WARN (JDBCExceptionReporter:71) - SQL Error: 208, SQLState: 42S02 2020-03-05 16:12:02,097 ERROR (JDBCExceptionReporter:72) - Invalid object name 'dbversion'. 2020-03-05 16:12:02,097 INFO (Upgrader:36) - Upgrading database to version 4.6.25 R G 2020-03-05 16:12:06,754 WARN (JDBCExceptionReporter:71) - SQL Error: 208, SQLState: 42S02 2020-03-05 16:12:06,754 ERROR
(JDBCExceptionReporter:72) - Invalid object name 'tip'. 2020-03-05 16:12:06,769 WARN (JDBCExceptionReporter:48) - SQL Warning: 208, SQLState: 42S02 2020-03-05 16:12:06,769 WARN (JDBCExceptionReporter:49) - Preparing the statement failed: Invalid object name 'tip'. 2020-03-05 16:12:06,769 ERROR (UptimeInstance:165) - Upgrade failed java.lang.RuntimeException: org.hibernate.exception.SQLGrammarException: could not execute update query at com.uptimesoftware.setup.install.InstallerSaver.save(InstallerSaver.java:16) at com.uptimesoftware.hibernate.HibernateManager.executeSave (HibernateManager.java:285) at com.uptimesoftware.hibernate.Saver.save(Saver.java:23) at com.uptimesoftware.setup.install.Installer.install(Installer.java: 14) at com.uptimesoftware.setup.upgrade.Upgrader.doUpgrade(Upgrader.java:38) at com.uptimesoftware.uptime.base.UptimeInstance.checkForUpgrade (UptimeInstance.java:163) at com.uptimesoftware.uptime.base.UptimeInstance.runUptime(UptimeInstance.java:90) at com.uptimesoftware.uptime.base.
Uptime.main(Uptime.java:275) at com.uptimesoftware.uptime.base.Uptime$1.run(Uptime.java:222) at java.lang.Thread.run(Unknown Source) Caused by: org.hibernate.exception.SQLGrammarException: could not execute update query at org.hibernate.exception.SQLStateConverter.convert (SQLStateConverter.java:59) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.hql.ast.
UpdateStatementExecutor.execute(UpdateStatementExecutor.java:99) at org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl. java:297) at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:871) at org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:89) at com.uptimesoftware.setup.install.ToolTipDeleter.delete(ToolTipDeleter.java:13) at com.uptimesoftware.setup.install.ToolTipInstaller.clearCurrentToolTips (ToolTipInstaller.java:16) at com.uptimesoftware.setup.install.ToolTipInstaller.install(ToolTipInstaller.java:21) at com.uptimesoftware.setup.upgrade.Update. install(Update.java:22) at com.uptimesoftware.setup.install.InstallerSaver.save(InstallerSaver.java:14) ... 9 more Caused by: java.sql.SQLException:
Invalid object name 'tip'.


  • No labels