Page History
...
- Uptime Infrastructure Monitor is pointing to the wrong db host or instance.
- The Uptime Infrastructure Monitor schema has not been initialized or the object doesn't actually exist.
- The Uptime Infrastructure Monitor database user doesn't have permissions to access the specified object.
Example
...
stack trace from an uptime.log file:
...
| Code Block | ||
|---|---|---|
| ||
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'. |