Page 1 of 1
Remove bad data(gas usage) entry from database
Posted: Fri Oct 25, 2019 10:03 pm
by knug2
I have a bad datapoint in the toon gas 'usage' database ( see attachment) is it possible to remove this data? And how to do it?
Re: Remove bad data(gas usage) entry from database
Posted: Fri Oct 25, 2019 10:47 pm
by TheHogNL
On what firmware are you on? This is a well known issue (see eneco toon forum). If you have a subscription they will fix it for you.
If you are rooted you probably need to adjust it in the .rrd files. You are the first one with rooted toons so I don't know which rrd file (probably the gas sensor file) and how.
Re: Remove bad data(gas usage) entry from database
Posted: Sat Oct 26, 2019 12:06 pm
by marcelr
That's fairly screwed up.
Does it also occur in the monthly and daily data?
I need to check whether weekly data are read directly from the rra databases or calculated from other data. Will get back to you later this weekend.
EDIT: Weekly data are calculated from other data. Not entirely sure which database. So, if you have a subscription tot eneco's services, I would let them fix it. If not, we can discuss other options.
Re: Remove bad data(gas usage) entry from database
Posted: Mon Oct 28, 2019 9:43 pm
by knug2
@marcelR @ theHog, thanks for the reply!
Currently im on the latest (rooted) 5.15.6 firmware, and don't have a subscription(anymore) offcourse
! However this data is allready pretty old ( from when I had a subscription ), and never occured anymore after this one.
It also occurs in the day,(week),month and year data. I found the specific day which contains the bad data : 2 oktober 2018 .
I searched for the .rrd files, but was not able to find them anywhere ( used automatic search from winSCP ).
Would be nice if there is a solution, however it's not 'urgent'.
Thanks!!
marcelr wrote:That's fairly screwed up.
Does it also occur in the monthly and daily data?
I need to check whether weekly data are read directly from the rra databases or calculated from other data. Will get back to you later this weekend.
EDIT: Weekly data are calculated from other data. Not entirely sure which database. So, if you have a subscription tot eneco's services, I would let them fix it. If not, we can discuss other options.
Re: Remove bad data(gas usage) entry from database
Posted: Mon Oct 28, 2019 9:55 pm
by TheHogNL
Those are not real RRD files but a toon specific format (.rra file with seperate .dat file). You need some tools (which marcelr has) to decode/recode those.
As Eneco is also doing it from there support there is probably another easier method but I don't know how.
Re: Remove bad data(gas usage) entry from database
Posted: Mon Oct 28, 2019 10:32 pm
by marcelr
The files reside in : /qmf/var/hcb_rrd/
To be able to handle them, you will need the whole contents of this directory, and the file config_hcb_rrd.xml from /qmf/config/ (from the top of my head).
Re: Remove bad data(gas usage) entry from database
Posted: Tue Oct 29, 2019 6:55 pm
by knug2
Got the files, but indeed as TheHogNL already mentioned, you need some tools.... It's not readable within a normal editor.
@MarcelR do you have a solution? Otherwise I leave it as is!
Thanks in advance,
marcelr wrote:The files reside in : /qmf/var/hcb_rrd/
To be able to handle them, you will need the whole contents of this directory, and the file config_hcb_rrd.xml from /qmf/config/ (from the top of my head).