Error: GetJSonDevices: exception occurred : 'stoull'

[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

[waltervl]

You have an incorrect value in your database, see for example
viewtopic.php?t=43351

[Filnet]

Deleting and recreating a device is the key? (but I lost all old datas...)

[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/

[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.

[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.

[Filnet]

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

Thank for your help

[imautohuttraeger]

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]

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]

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]

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

[Filnet]

Hello, I come back...
I manage two homes with Domoticz. They work correctly.
The second one, which I recently installed, displays the following message in the log:

Code: Select all

Error: GetJSonDevices: exception occurred: 'stoll'

It appears every time I log in and/or refresh the web interface (in the tabs: Dashboard, Utility, Setup/Parameters). If I don't log in to the web interface, this message never appears (log monitored via SSH).

I've disabled all dzVents and all hardware without success.

I've checked the Domoticz SQL database, and I don't see anything unusual.
Has anyone else experienced this problem?

[waltervl]

In beta you can now activate extra logging options in menu settings, tab log. Perhaps add webserver logging so it becomes more clear what it does,

[Filnet]

Great idea, these debug options! I found this:

Code: Select all

2026-03-18 18:33:22.393  Debug: Query:SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')
2026-03-18 18:33:22.393  Error: GetJSonDevices: exception occurred : 'stoll'
2026-03-18 18:33:22.393  Debug: Query:SELECT nValue, sValue FROM Preferences WHERE (Key='MeterDividerEnergy')
2026-03-18 18:33:22.393  Debug: Query:SELECT MIN(Value1), MIN(Value2), MIN(Value5), MIN(Value6) FROM MultiMeter WHERE (DeviceRowID='280' AND Date>='2026-03-18')

In the database, the sValue of 'MeterDividerEnergy' is empty. That might be the problem. I retyped the nValue and saved. But the sValue remains empty. What should I do?

[waltervl]

It should be 1000 . That is the normal value. I dont know if that is n- or svalue

[Filnet]

nValue : 1000
sValue : is empty

These values are the sames than in my other domoticz (which it have no problem of stoll).

[gizmocuz]

Sorry, I forgot to press 'Submit' yesterday

you probably have a device that has invalid data in the sValue, maybe you used a plugin or you changed it yourself via dzVents.
Something is not correct.
The default nValue = 1000 and sValue should be empty, it is not the problem you are seeing.

The issue is probably with one of your devices, and that is what caused an issue in GetJSonDevices (and it continues, but for that device you won't get data)

In the latest beta (17425) I added the device idx and name when this exception occurs. This should help you find the device that is causing this

[Filnet]

Thank you for help.

Code: Select all

Error: GetJSonDevices: exception occurred: 'stoll' (18446744073709551615/)

I see the ID but not the name
No ID in my device's table with this ID.

[gizmocuz]

Ahhh that is actually -1

Found the reason... I declared the variables (idx/name) twice and did not use the correct once for the try/catch

If you update to beta 17446, then it should work

[Filnet]

Success!

I was able to retrieve the device's ID and name. However, this device no longer existed in the Domoticz device table. Using an SQLite database editor, I found the missing device with an incorrect sValue. I modified the sValue to the correct value (it was a P-counter). It then reappeared in the Domoticz device list, and I was able to delete it.
The 'stoull' error message no longer appears.

Thank you for your help and quick response.