- 
    Type:Bug 
- 
    Resolution: Fixed
- 
    Priority:Major 
- 
    Component/s: DB
- 
    None
Discovered a specific scenario where the raw-to-hour datum aggregation process can result in a "hole" (no hourly aggregate) when one should have been generated. The requirements for this situation are, starting with a "stale hour" aggregation record on a single datum stream:
- the previous datum's hour is more than 1 hour earlier than the stale hour
- a datum exists exactly on the stale hour's start
Example raw data:
| Time | Reading | 
|---|---|
| 12:00 | 0 | 
| 12:30 | 1 | 
| 16:00 | 3 | 
| 16:30 | 4 | 
| 17:00 | 5 | 
Expected hour aggregate data:
| Hour | Reading | 
|---|---|
| 12:00 | 1 | 
| 15:00 | 2 | 
| 16:00 | 2 | 
Actual hour aggregate data:
| Hour | Reading | 
|---|---|
| 12:00 | 1 | 
| 16:00 | 2 | 
Notice how the 15:00 = 2 hour is missing.