Error: GetJSonDevices: exception occurred : 'stoull'

Moderator: leecollings

Post Reply
Filnet
Posts: 53
Joined: Tuesday 06 March 2018 13:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.2 ß
Location: FR
Contact:

Error: GetJSonDevices: exception occurred : 'stoull'

Post by Filnet »

Hello,

This message appears in log ans I can't find to solve it.
I disable all my scripts: The problem is not here.
It appears when I click on log button of a device Smart P1 and a second time when I close the log graphs, for instance.

Thanks for your help
User avatar
waltervl
Posts: 6677
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2025.1
Location: NL
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by waltervl »

You have an incorrect value in your database, see for example
viewtopic.php?t=43351
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Filnet
Posts: 53
Joined: Tuesday 06 March 2018 13:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.2 ß
Location: FR
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by Filnet »

Deleting and recreating a device is the key? (but I lost all old datas...)
User avatar
waltervl
Posts: 6677
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2025.1
Location: NL
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by waltervl »

Or make a backup of the database and examine and modify it with for example https://sqlitebrowser.org
If you just want to examine it you can make a backup dump with menu Setup-Settings -tab Backup/restore and open the file in the online viewer https://sqliteviewer.app/
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Filnet
Posts: 53
Joined: Tuesday 06 March 2018 13:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.2 ß
Location: FR
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by Filnet »

Yes, I have already done it.
Integrity check is OK.

but I don't know where I search in the DB.
This message appears each time I click 'Log' regardless of the device.
User avatar
waltervl
Posts: 6677
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2025.1
Location: NL
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by waltervl »

Then it gets data out of the database so probably look in the meter_calendar or multimeter_calendar table. It could also be in the short term meter or multimeter tables but those get cleaned up every x days (depends on your short log settings). So probably not the root cause of your issue.
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Filnet
Posts: 53
Joined: Tuesday 06 March 2018 13:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.2 ß
Location: FR
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by Filnet »

I put 1 day in short log settings and I see tomorrow...

Thank for your help
imautohuttraeger
Posts: 172
Joined: Saturday 14 March 2020 13:40
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.1
Location: Germany
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by imautohuttraeger »

Filnet wrote: Thursday 29 January 2026 17:18 I put 1 day in short log settings and I see tomorrow...

Thank for your help
@Filnet
I have a similar problem. Could you solve it?
Filnet
Posts: 53
Joined: Tuesday 06 March 2018 13:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.2 ß
Location: FR
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by Filnet »

No, the problem is not solved. I inspected the database with DB browser for sqlite and found no anomalies, especially in the stored Strings.
imautohuttraeger
Posts: 172
Joined: Saturday 14 March 2020 13:40
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.1
Location: Germany
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by imautohuttraeger »

OK. Will keep you updated if I should find something. But as me as a non-tech-guy the likelihood is not very high ...
Filnet
Posts: 53
Joined: Tuesday 06 March 2018 13:55
Target OS: Raspberry Pi / ODroid
Domoticz version: 2025.2 ß
Location: FR
Contact:

Re: Error: GetJSonDevices: exception occurred : 'stoull'

Post by Filnet »

Thank you for your feedback. Hopefully someone will have an idea.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest