Interesting error for dashboard

First time I have seen this error this morning. Everything is working fine, just noticed the error thrown for the dashboard. Any thoughts?

app:12020-10-14 06:38:52.933 am errororg.h2.jdbc.JdbcSQLException: Column "unit" not found [42122-197] on line 687 (deviceInfo)

app:12020-10-14 06:19:13.087 am errororg.h2.jdbc.JdbcSQLException: General error: "java.lang.NullPointerException" [50000-197] on line 687 (deviceInfo)

app:12020-10-13 09:31:57.904 am errororg.h2.jdbc.JdbcSQLException: Column "device_id" not found [42122-197] on line 625 (dashboardDevices2)

When you click on the error what does it take you to? Just a guess but is a dashboard referencing a device that no longer exists?

Hope you have a recent backup ready. Might need to do a soft reset and restore the DB. This is indicative of DB corruption.

@lewis.heidrick Clicking on the error takes me to the Hubitat Dashboard, it shows only 3 errors and nothing since then. I have had the same dashboards set since I installed the box the only change to dashboards is adding new devices (and all devices for all dashboards do show up fine) and a new test dashboard that is blank right now for trying out different looks

@cuboy29 I do have plenty of backups so not an issue there. I'll monitor for now as I would think if it is corruption it will happen again, at which point I'll continue with soft reset and restore of DB if needed.

1 Like