Error 500

🛎️ Get Help
1

My c7 was stuck at 15%

so i tried to do a soft reset from port:8081 and now i have an Error 500 message

any ideas on what i can do next?

2

Probably want to get support involved. @bobbyD - any suggestions?

Was your device set with a fixed IP address?

1 Like
3

yes my device is set with a static IP

4

hub-2.2.8.136

Hardware Version:

Rev C-7

5

dev:332021-08-03 06:26:28.405 pm errorjava.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. Query: UPDATE DEVICE D SET D.STATE = ? WHERE D.ID = ? Parameters: [{"energyTime":1615568300256}, 33] (parse)
dev:2792021-08-03 06:26:21.341 pm errorjava.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. Query: UPDATE DEVICE D SET D.STATE = ? WHERE D.ID = ? Parameters: [{"energyTime":1625927795909}, 279] (parse)
dev:2792021-08-03 06:26:21.246 pm errorjava.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. Query: UPDATE DEVICE D SET D.STATE = ? WHERE D.ID = ? Parameters: [{"energyTime":1625927795909}, 279] (parse)
dev:2792021-08-03 06:26:21.238 pm infoHDPS1 energyDuration is 24.45 Days
dev:2792021-08-03 06:26:21.141 pm errorjava.lang.RuntimeException: java.sql.SQLException: A problem occurred while trying to acquire a cached PreparedStatement in a background thread. Query: UPDATE DEVICE D SET D.STATE = ? WHERE D.ID = ? Parameters: [{"energyTime":1625927795909}, 279] (parse)

6

I see the hub is back online and responding to support tool requests, which happens when it gets to at least 90% point. Did another soft reset do the trick?

1 Like
7

I did a few more soft resets after a 30 minute power off

Then I did a restore but from a backup on the hub. Not sure why the hub backup worked and not my downloaded local files didn't. ( I have a windows job to download the file daily and I tried several of them)

Any ideas on why this happened?
My theory is it hadn't rebooted in a while.
I'm going to created a reboot schedule with the rebooter app (unless there's a better way?)

Thx

8

From the logs, it looks like locally downloaded backup was corrupted in some way. It doesn't usually provide the details when it happens.

9

Odd, I went through about 10 different backups locally downloaded. All the way back to July 1

The oldest July 30 backup on the hub itself ended up working

10

Ok, I've looked at the last failed restore. Will have to take a closer look.

3 Likes
11

Ok, thank you