Jon00 DB Chart: Error: Too Many datapoints....

[Jon]

My log has been filling up with this error:

Warning: Too many datapoints to plot (142076) - Chart 1 not created

The number in the log increments for each log entry. My intention is to sample the values at 15 second intervals and keep 120 days of samples so i can analyze data later. I then have a chart set up (hopefully properly) to display the last 24 hours. So if it's sampling every 15 seconds, that should be 5760 datapoints. I'm not really sure how many is too many to plot. Is it some fixed number, or related to the chart setup?

I assume Chart 1 is the first one in the list. (Feature request: use the chart name instead of it's index in the error messages) I just noticed that on the device page, it's showing that this chart hasn't updated since Sept 12th. So that must be the one. It uses my "HVAC" database. It tracks 5 devices and has the following settings:

[DBTable1]
Name=HVAC
PurgeDays=120
Timer=1
Data1=$dvr:362
Data1Label=Calculated Average Indoor Temp
Data1Multiplier=1|
Data1MaxValue=110
Data1MinValue=0
Data2=$dvr:373
Data2Label=Dining Room Temp
Data2Multiplier=1|
Data2MaxValue=110
Data2MinValue=0
Data3=$dvr:376
Data3Label=Family Room Temperature
Data3Multiplier=1|
Data3MaxValue=110
Data3MinValue=0
Data4=$dvr:364
Data4Multiplier=1|
Data4Label=Cool Setpoint
Data4MaxValue=110
Data4MinValue=0
Data5=$dvr:363
Data5Label=Heat Setpoint
Data5Multiplier=1|
Data5MaxValue=110
Data5MinValue=0

The Chart setup looks like this: I'll be honest that some of these settings confuse me and I don't have a good grasp on how all of the settings are supposed to work.

[Create1]
Name=HVAC
DBTable=1
ChartStyle=20
ChartPalette=12
UseData1=1
UseData2=1
UseData3=1
UseData4=1
UseData5=1
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=hh:mm
ChartTimeStart=1440
ChartTimeFinish=0
AxisXFormat=hh:mm
CreateVD=1
AutoUpdate=1
CreateTable=1
ShowAllValues=0
SaveLastValues=0
XAxisText=Time
YAxisText=Temp
TitleText=HVAC System Temperatures

As a side note, the x axis labels have never worked correctly. Every point shows 00:00 across the bottom.

[Jon]

another side note. Not sure if it's worth mentioning or not. I only discovered this problem because I went to look at my log. I noticed my pond didn't turn on when I got home. So I went to check the log. Not only did I see it full of these errors, but I also noticed it seems to have stopped logging yesterday morning. So there's no clues for me to use to figure out why my pond didn't turn on when I got home.

[jon00]

Your ChartTimeFormat entry is wrong

Try the following

ChartTimeFormat=m

This will probably sort out both issues. For more info look at page 30 in the docs.

I suggest to restart the plugin after this change.

Regarding the log issues, there are a few posts on the board about this. One recently updated thread can be seen here.

[begunfx]

I'm getting the same error. My database table and charting were working fine for a long time, but recently I'm seeing this error fill my logs. I'm pretty sure I have my database and tables set up properly.

I have one database shared across three charts that is the subject of the error.

I'm using the latest version of the utility: 1.2.5

Here's the database .ini:

[DBTable5]

Name=Home Energy Meter (Hourly)
Delay=500
PurgeDays=1
Timer=0
Data1Multiplier=||
Data2Multiplier=||
Data3Multiplier=||
Data4Multiplier=||
Data5Multiplier=||
Data6Multiplier=||
Data7Multiplier=||
Data8Multiplier=||
Data9Multiplier=||
Data10Multiplier=||
Data1=$dvr:2908
Data1Label=Watts
Data2=$dvr:2910
Data2Label=Amperes
Data3=$dvr:2909
Data3Label=Volts
Data4=$ini:Hour,Diff1,Jon00DBChartingData.ini
Data4Label=kW Hours

[Differential]

Data1=$dvr:2907
Data2=$dvr:3849
Data3=
Data4=
Data5=
Data6=
Data7=
Data8=
Data9=
Data10=


Here are the charts referencing the above table/diff:

[Create5]

Name=Home Energy Meter Hourly (Volts - Amperes)
DBTable=5
ChartStyle=23
ChartPalette=12
UseData1=0
UseData2=1
UseData3=1
UseData4=0
UseData5=0
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=Today
ChartTimeStart=00:00:00
AxisXFormat=hh:mm
CreateVD=1
AutoUpdate=1
CreateTable=0
ShowAllValues=0
SaveLastValues=0
TitleText=Home Energy Meter Hourly (Volts - Amperes)
XAxisText=Time Of Day
YAxisText=Volts - Amperes
ChartTimeFinish=23:59:59

[Create6]

Name=Home Energy Meter Hourly (kWh)
DBTable=5
ChartStyle=23
ChartPalette=12
TitleText=Home Energy Meter Hourly (kWh)
XAxisText=Time Of Day
YAxisText=kW Hours
UseData1=0
UseData2=0
UseData3=0
UseData4=1
UseData5=0
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=Today
ChartTimeStart=00:00:00
ChartTimeFinish=23:59:59
AxisXFormat=hh:mm
CreateVD=1
AutoUpdate=1
CreateTable=0
ShowAllValues=0
SaveLastValues=0

Name=Home Energy Meter Hourly (Watts)
DBTable=5
ChartStyle=23
ChartPalette=12
TitleText=Home Energy Meter Hourly (Watts)
XAxisText=Time Of Day
YAxisText=Watts
UseData1=1
UseData2=0
UseData3=0
UseData4=0
UseData5=0
UseData6=0
UseData7=0
UseData8=0
UseData9=0
UseData10=0
ChartTimeFormat=Today
ChartTimeStart=00:00:00
ChartTimeFinish=23:59:59
AxisXFormat=hh:mm
CreateVD=1
AutoUpdate=1
CreateTable=0
ShowAllValues=0
SaveLastValues=0

Any help on this would be greatly appreciated.

[jon00]

The datapoints error is just telling you that your database has too many entries to plot against the time span selected for the chart. If this has been working before, something must of changed to increase the number of entries in your database. Remember this is updated on change of value.

If your device values are to 2 decimal places, this would cause lots of entries as a 0.01 change would be recorded in the database. If that is the case, you can restrict that using the Multiplier/Rounding setting i.e. to 1 decimal place:

Data1Multiplier=|1
Data2Multiplier=|1
Data3Multiplier=|1

Or even better to 0 decimal places:

Data1Multiplier=|0
Data2Multiplier=|0
Data3Multiplier=|0

You can change the datapoints maximum by changing the MaxDataPoints= setting under [Settings] in the Jon00DBCharting.ini

I think it is currently set to 8000

Be warned, if set too high, it may crash the plugin whilst trying to render the chart.

[begunfx]

The datapoints error is just telling you that your database has too many entries to plot against the time span selected for the chart. If this has been working before, something must of changed to increase the number of entries in your database. Remember this is updated on change of value.

If your device values are to 2 decimal places, this would cause lots of entries as a 0.01 change would be recorded in the database. If that is the case, you can restrict that using the Multiplier/Rounding setting i.e. to 1 decimal place:

Data1Multiplier=|1
Data2Multiplier=|1
Data3Multiplier=|1

Or even better to 0 decimal places:

Data1Multiplier=|0
Data2Multiplier=|0
Data3Multiplier=|0

You can change the datapoints maximum by changing the MaxDataPoints= setting under [Settings] in the Jon00DBCharting.ini

I think it is currently set to 8000

Be warned, if set too high, it may crash the plugin whilst trying to render the chart.

Thanks, Jon. I'll give the rounding a try and see if that keeps the database from filling up.