Remove bad data(gas usage) entry from database

If you don't know where to post, post here.

Moderators: marcelr, Toonz, TheHogNL, TerrorSource

Remove bad data(gas usage) entry from database

Postby knug2 » Fri Oct 25, 2019 9:03 pm

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?
Attachments
20191025_135512.jpg
Bad data in Gas usgage
20191025_135512.jpg (70.09 KiB) Viewed 1741 times
knug2
Starting Member
Starting Member
 
Posts: 19
Joined: September 2019

Re: Remove bad data(gas usage) entry from database

Postby TheHogNL » Fri Oct 25, 2019 9:47 pm

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.
Member of the Toon Software Collective
User avatar
TheHogNL
Forum Moderator
Forum Moderator
 
Posts: 1613
Joined: August 2017

Re: Remove bad data(gas usage) entry from database

Postby marcelr » Sat Oct 26, 2019 11:06 am

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.
marcelr
Global Moderator
Global Moderator
 
Posts: 1149
Joined: May 2012
Location: Ehv

Re: Remove bad data(gas usage) entry from database

Postby knug2 » Mon Oct 28, 2019 8:43 pm

@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.
Last edited by knug2 on Mon Oct 28, 2019 8:57 pm, edited 1 time in total.
knug2
Starting Member
Starting Member
 
Posts: 19
Joined: September 2019

Re: Remove bad data(gas usage) entry from database

Postby TheHogNL » Mon Oct 28, 2019 8:55 pm

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.
Member of the Toon Software Collective
User avatar
TheHogNL
Forum Moderator
Forum Moderator
 
Posts: 1613
Joined: August 2017

Re: Remove bad data(gas usage) entry from database

Postby marcelr » Mon Oct 28, 2019 9:32 pm

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).
marcelr
Global Moderator
Global Moderator
 
Posts: 1149
Joined: May 2012
Location: Ehv

Re: Remove bad data(gas usage) entry from database

Postby knug2 » Tue Oct 29, 2019 5:55 pm

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).
knug2
Starting Member
Starting Member
 
Posts: 19
Joined: September 2019


Return to Toon miscellaneous

Who is online

Users browsing this forum: No registered users and 1 guest