Tasmota device ("Hichi" infraread head) brings error

[imautohuttraeger]

I have an infraread reading head on my electric meter ("Hichi" with Tasmota). Transfering the data via MQTT to Domotics works, but for at least one of the figures I get this error:

Error: Invalid Number sValue: '%' for device idx: '%'
Error: GetJSonDevices: exception occurred : 'stoull'

For those of you who are savvy with Tasmota: This is the code of the customized script that runs there and it displays correct data in the Tasmota web interface:

>D
>B
=>sensor53 r
>M 1
+1,3,s,0,9600,,1
1,77070100010800FF@100000000,Zählerstand Import ,kWh,1_8_0,8
1,77070100010801FF@1000,Zählerstand Import T1 ,kWh,1_8_1,8
;1,77070100010802FF@100000000,Energie Bezug T2,kWh,1_8_2,8
1,77070100020800FF@100000000,Zählerstand Export,kWh,2_8_0,8
1,77070100100700FF@1,Summe Verbrauch ,W,16_7_0,16
1,77070100240700FF@1,akt. Verbrauch L1,W,36_7_0,16
1,77070100380700FF@1,akt. Verbrauch L2,W,56_7_0,16
1,770701004C0700FF@1,akt. Verbrauch L3,W,76_7_0,16
#

But even the non-customized Script from the Tasmota wiki shows the same error:
https://tasmota.github.io/docs/Smart-Me ... d3-obissml

Any hints are highly welcome

[waltervl]

Please supply the MQTT message payloads that give issues.
You can do that with for example MQTT Explorer https://wiki.domoticz.com/MQTT#Debugging_MQTT

Edit The "stoull" error when showing a graph is related to incorrect values in your database. Search the forum for this error.
Edit: 2 see for example viewtopic.php?p=331228&hilit=stoull#p331228

[imautohuttraeger]

In MQTT ExplorerI have found two entries for this tasmota device:

Code: Select all

{"ip":"192.168.1.112","dn":"Hichi_Stromzaehler","fn":["@@4ecwdbR{ *```@`f@@|@` d0x",null,null,null,null,null,null,null],"hn":"Hichi-Lesekopf-6802","mac":"F4CFA2DF5A92","md":"Sonoff Basic","ty":0,"if":0,"ofln":"Offline","onln":"Online","state":["OFF","ON","TOGGLE","HOLD"],"sw":"13.2.0","t":"Hichi_Lesekopf","ft":"%prefix%/%topic%/","tp":["cmnd","stat","tele"],"rl":[1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"swc":[-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1],"swn":[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null],"btn":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"so":{"4":0,"11":0,"13":0,"17":0,"20":0,"30":0,"68":0,"73":0,"82":0,"114":1,"117":0},"lk":0,"lt_st":0,"bat":0,"dslp":0,"sho":[],"sht":[],"ver":1}

and

Code: Select all

{"sn":{"Time":"2026-02-09T22:00:54","SML":{"1_8_0":10409.59198526,"1_8_1":0.10408596,"1_8_2":0.00000995,"2_8_0":5620.10674508,"2_8_0":5620.10674508,"16_7_0":15,"36_7_0":-51,"56_7_0":-29,"76_7_0":95,"96_1_0":"090145425a0100241cd8"}},"ver":1}

Anything strange here form an expert point of view?

[waltervl]

I dont know. How do you import the data into Domoticz? As this seems a payload that is not designed for Domoticz's default MQTT interface. https://wiki.domoticz.com/MQTT#MQTT_to_Domoticz

Do you use MQTTMapper plugin? Or the MQTT AD gateway?

[imautohuttraeger]

For Tasmota devices I use the "configure domoticz" section of the web interface. There I type in the IDX of the virtual domoticz devices. See screenshot (but the caption is not corresponding to the values here because it is not a switch device. It is about power in Watt and meter counts of import and export in kWh

[waltervl]

I have no idea how this works.
Domoticz MQTT expects something like below in MQTT Domoticz/in topic (when using default MQTT settings. Read the Domoticz Wiki for more info.

Code: Select all

{  "command": "udevice",  "idx" : 7,  "nvalue" : 0,  "svalue" : "90;2975.00" }
or short:
{  "idx" : 7,  "nvalue" : 0,  "svalue" : "90;2975.00" }

You perhaps have to change something on the Tasmota side?

[waltervl]

In the following Topic you want to use the MQTT mapper plugin to map values from tasmota into Domoticz. viewtopic.php?p=307270#p307270

So check that.

[imautohuttraeger]

In the following Topic you want to use the MQTT mapper plugin to map values from tasmota into Domoticz. viewtopic.php?p=307270#p307270

So check that.

You are right. It was my intention to user MQTT Mapper but I have to admit that I haven't done it because I have too much concerns that editing the mqttMapper.json file for each device is too sophisticated and time intensiv for me ... However maybe I should finally start now ...

[imautohuttraeger]

Please supply the MQTT message payloads that give issues.
You can do that with for example MQTT Explorer https://wiki.domoticz.com/MQTT#Debugging_MQTT

Edit The "stoull" error when showing a graph is related to incorrect values in your database. Search the forum for this error.
Edit: 2 see for example viewtopic.php?p=331228&hilit=stoull#p331228

Thx, this really seems to be a hint that goes into the right direction. I could now verify that opening the log graph causes an error. But not the "stoull" but this:

Error: Invalid Number sValue: '%' for device idx: '%'

It occurres with several different energy devices, no matter from which manufacturer or OS (Tasmota, Shelly). But not each one. Very strange ...

EDIT: Meanwhile I have recognizes, that the error can be forced by opening a graph log. But not only. Both errors are coming even without interaction, but only from time to time.

[imautohuttraeger]

I have checked the databsae according to the troubleshooting page
https://wiki.domoticz.com/Troubleshooti ... k_database

The list of tables does not show "Preferences"

Code: Select all

pi@Raspberry:~/domoticz $ sudo sqlite3 domoticz.db  'SELECT name as Tablename ,SUM("pgsize")/4096 Size FROM "dbstat" WHERE name IN (SELECT name FROM "sqlite_master" WHERE type == "table" ) GROUP BY name HAVING Size > 10 ORDER BY size DESC;'
lost_and_found|7391
Temperature_Calendar|1132
Meter_Calendar|923
LightingLog|776
Meter|594
Floorplans|390
Percentage_Calendar|272
MultiMeter_Calendar|225
Temperature|181
EventMaster|79
Wind_Calendar|70
Percentage|65
Rain_Calendar|56
UV_Calendar|37
SceneLog|20
DeviceStatus|19
Rain|16
UV|15
KWHStats|13
Wind|12
pi@Raspberry:~/domoticz $

And the integrity check and foreign key check are showing no errors:

Code: Select all

pi@Raspberry:~/domoticz $ sudo sqlite3 domoticz.db "PRAGMA integrity_check(10000)"
ok
pi@Raspberry:~/domoticz $ sudo sqlite3 domoticz.db "PRAGMA foreign_key_check"
pi@Raspberry:~/domoticz $ 

However I have proceeded the repair process anyhow, but of course with no result.

Is there anything else I can do?

[waltervl]

It is not a error in the database, there is an incorrect value for reporting in the database.

viewtopic.php?p=331228&hilit=stoull#p331228