Temperature Graphs not displaying when 24hr filter selected..

[manaesh]

Hi

I had to rebuild my homeseer server, and copied across my mcstemperature database from my old server.

It is working fine - however, I cannot display 24hr graphs for any temperature sensors. All other periods (6hr & 72hr etc) display fine, just this period.

I can display 24hr graphs for other types (I have a Current Cost inputting Wattage rates) with out a problem.

I have tried recreating new groups to display the temperatures, but still get the same problem.

I have also tried installing the Chartdirector component with no success.

I am running the latest version of MCSTemp from the repository.

Would anyone have an ideas as to why this is happening?

Regards

Mike

[Michael McSharry]

Are you showing LINTAB to look at the statistics for the 24 hour data? The nature of the data may provide some clues.
Are you also showing discretes on the same 24 hour chart? Sometimes a lack of discrete transitions during a chart period causes issues.
Are there any messages in the HS log? If you have debug enabled then messages may be routed to the debug file rather than HS log. If you have debug then the SQL statement may be in there to view clues.

[manaesh]

Hi Michael

I am using the LINTAB (i have tried all of the views) and still getting the problem.

I am not sure what you mean about showing discretes??

Here is the last couple of entries in my log :-

05/01/2011 16:15:09 58509.92 | mcsTemperature Debug | DrawGraph Query=SELECT Format([SampleDate],"yyyy/mm/dd hh:" & Right("00" & CStr(Int(Minute([SampleDate])/2)*2),2) & ":00") AS SampleDate, Avg(ExternalTmp3rd) AS Temp FROM Temperature WHERE ExternalTmp3rd<>0 AND SampleDate >= #2011-01-04 17:00# AND SampleDate < #2011-01-05 17:00# GROUP BY Format([SampleDate],"yyyy/mm/dd hh:" & Right("00" & CStr(Int(Minute([SampleDate])/2)*2),2) & ":00") ORDER BY Format([SampleDate],"yyyy/mm/dd hh:" & Right("00" & CStr(Int(Minute([SampleDate])/2)*2),2) & ":00")
05/01/2011 16:15:10 58510.34 | mcsTemperature Debug | SensorCount=11
05/01/2011 16:15:10 58510.35 | mcsTemperature Debug | Chart SQL=SELECT SampleDate AS StartDate, (Temperature) AS Q1, (ExtTemp) AS Q2, (BathTemp) AS Q3, (Kitchtemp) AS Q4, (LivingTemp) AS Q5, (HallTemp) AS Q6, (BedTemp) AS Q7, (DeltaDifTemp) AS Q8, (FishtankTemp) AS Q9, (FishtankTemp2) AS Q10, (ExternalTmp3rd) AS Q11 FROM Temperature WHERE SampleDate >= #2011-01-04 17:00# AND SampleDate < #2011-01-05 17:00#
05/01/2011 16:15:10 58510.35 | mcsTemperature Debug | Chart SQL2=
05/01/2011 16:15:10 58510.35 | mcsTemperature Debug | Chart SQL3=
05/01/2011 16:15:11 58511.06 | mcsTemperature Debug | Data Elements=720, Data Names=11
05/01/2011 16:15:11 58511.06 | mcsTemperature Debug | X Axis Data Completed
05/01/2011 16:15:11 58511.12 | mcsTemperature Debug | Y Axis Data Completed, SomeData=True

So it looks like its working properly??

Any other ideas??

Regards

Mike

[Michael McSharry]

There are settings to show data points and one to connect dots. There may also be one to exclude 0 values. On the Display setup page change these as experiments to see if the chart appears.

What do you actually see for the case of "I cannot display 24hr graphs"?

[manaesh]

Thanks Michael - I will experiment with that.

I actually see the yellow graph box, with the values on the x / y axis, and also see the labels of the sensors. I just do not see any lines.

If i then change the period to any other time period, the graph redraws perfectly.

I can produce 24 hr graphs for other sensors (wind, rain etc) just not the temperature sensors.

Regards

Mike

[Michael McSharry]

I suspect it has to do with the sampling rate of the data into the database. The data is sufficiently sparse that the X axis has more pixels on display than data points to fill it so the dots are not connected so when the dots are suppressed there is nothing to show.

[johan]

I had the issue of not seeing the 24 and 72 hour charts and based on the advice above I selected the 'Always connect the dots' in the Display page and it solved the a.m. issue.

Now all the charts have all been resized however, but that's a different story that I hope I can figure out myself... =)