Dashboard historical kwh data

cpreecs · Post by **cpreecs** » Mon Dec 23, 2013 11:09 am

Hello,
I have an ECM-1240 with the Dashboard setup that has been running well for several months. However, recently the kwh views in the Historical Data tab are not working. That tab comes up but the charts don't show. I've tried reinstalling Dashboard but with no luck. Any help?

Chuck.

Post by **ben** » Mon Dec 23, 2013 11:19 am

cpreecs wrote:Hello,
I have an ECM-1240 with the Dashboard setup that has been running well for several months. However, recently the kwh views in the Historical Data tab are not working. That tab comes up but the charts don't show. I've tried reinstalling Dashboard but with no luck. Any help?

Chuck.

How often are you sending to the database? Do you have any of the automatic compression methods enabled under the Database section?

Ben

cpreecs · Post by **cpreecs** » Mon Dec 23, 2013 11:56 am

I'm sending every 20 seconds (the default as I recall?).

I condense the minute data every 7 days.

I delete minute data older than 30 days.

Post by **ben** » Mon Dec 23, 2013 12:20 pm

cpreecs wrote:I'm sending every 20 seconds (the default as I recall?).

I condense the minute data every 7 days.

I delete minute data older than 30 days.

Did you copy/move your database at all while the Engine was running? Performing operations on an active database can cause the copy to corrupt.

Ben

cpreecs · Post by **cpreecs** » Mon Dec 23, 2013 1:32 pm

Not that I'm aware of. Is there a way to check the db for problems? I've got backups but I would lose several days of data...

Post by **ben** » Mon Dec 23, 2013 1:48 pm

cpreecs wrote:Not that I'm aware of. Is there a way to check the db for problems? I've got backups but I would lose several days of data...

If you have a way to send some SQL to the database, I would send a "SELECT * FROM monitordata_minute ORDER BY date limit 1;" and see if it throws an error. Usually corruption like this is easily recoverable by dumping to SQL and rebuilding from SQL.

Ben

cpreecs · Post by **cpreecs** » Mon Dec 23, 2013 2:04 pm

I was able to get good results back against all of the tables. I used SQLite Administrator (http://sqliteadmin.orbmu2k.de/).

Post by **ben** » Mon Dec 23, 2013 2:42 pm

Any recent switch in web browsers?

Very strange that it just suddenly stopped working.

Ben

cpreecs · Post by **cpreecs** » Thu Dec 26, 2013 2:36 pm

I think I found the problem. When I select Other (Un-monitored) Loads, the Historical kwh chart will not display. When I have it selected in the Live data kw chart, it just doesn't show up on the chart. I reinstalled Dashboard but no luck there. My config in the Engine seems to look right also. Ideas?

cpreecs · Post by **cpreecs** » Tue Dec 31, 2013 11:10 am

I finally got this fixed. My Engine config was messed up. It somehow thought I had two devices setup. Once I changed that and it prompted me to fix the db, all is working properly now.

Dashboard historical kwh data

Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data

Re: Dashboard historical kwh data