Dashboard SQL Exeception Errors

I have gotten the following Exception Errors in my log for the Dashboard App. Any ideas what could cause them, or if there is something I should look at correcting?


app:62020-07-21 17:54:43.957 errororg.h2.jdbc.JdbcSQLException: Column "disabled" not found [42122-197] on line 616 (dashboardDevices2)
app:62020-07-21 14:51:11.608 errororg.h2.jdbc.JdbcSQLException: Column "device_id" not found [42122-197] on line 625 (dashboardDevices2)

Following. I have the same error. I have no idea how to determine which device it might be.

app:12020-07-24 04:08:30.170 am errororg.h2.jdbc.JdbcSQLException: Column "device_id" not found [42122-197] on line 625 (dashboardDevices2)

1 Like

To know which device is the cause, there are 2 options.
1: Click on the “app” link on the left. This will add a filter to the log showing all log entries for that device, and highlighting the device name on top.
2. Click on “error”, “debug” or “info” after the date and time. It will brig you to the app or device in a new tab.

Hope this helps!

Some people see these error sometimes, and I'm not sure anyone has figured out a reason 100% why. The worst-case scenario is that you have database corruption, and a soft reset (from a downloaded, recent backup) might help; these errors do seem to be ones the platform's database is throwing at the app. However, some people have mentioned things that seem more likely to make this happen (I think removing child devices an app created? but Dashboard doesn't have any). If you removed a device without removing it from Dashboard first, maybe that could cause this. If you have "Use all devices" turned on, that still shouldn't cause this but it's usually better to select individual devices as needed, instead, so that's something you could try.

Since the error appears to be coming from the database, knowing which app or device/driver it is logged with might help you figure out if you happened to have changed anything recently, but it's unfortunately likely to be of little help in actually resolving the issue. I think many people see these disappear on their own (maybe overnight maintenance does something?), but if you can't figure anything out, letting Support know might be a good idea. Then let us know what they think. :laughing:

1 Like

Thanks @bertabcd1234. Other than the error, there is no symptom so not a big issue. I will however keep an eye on the log and contact support if the issue repeats often enough.

Not when it is the dashboard app