Announcement

Collapse
No announcement yet.

Lots Energy DB errors in the log every few seconds

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Lots Energy DB errors in the log every few seconds

    I have these errors in the log every few seconds, a restart did not solve this problem

    Oct-05 16:38:04 Energy DB Compaction of remaining data completed, rechecking database size...
    Oct-05 16:38:04 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =508 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =523 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =928 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =138 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =1068 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =496 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =102 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =105 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =96 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:03 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =99 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =108 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =1125 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =1118 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =1109 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =1077 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =498 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =490 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =200 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Error (1) Failed to retrieve Energy data records (util) : Arithmetic operation resulted in an overflow.: SELECT * FROM [EnergyData] WHERE dvRef =488 AND [Amount_Start] >= '2017-06-05 16:38:02' AND [Direction] = 1 AND [Duration] < 120 AND [Duration] >= 0
    Oct-05 16:38:02 Energy Database Generating compaction records.
    Oct-05 16:38:02 Energy DB Records will be compacted to 2 minute blocks of data.
    Oct-05 16:38:01 Energy DB Calculating compact ratio.
    Oct-05 16:38:01 Energy DB Database is 5.370117 MB larger than required and will have the data compacted.
    Last edited by mikee123; October 5, 2017, 10:51 AM.

    #2
    Old thread, I know.
    Just posting my solution because I saw this happen today.

    In HS3 pro, go to Tools>Setup>General tab>Energy settings: Click 'clear saved data'.

    No clue though why this happened.
    Cheers!

    Comment

    Working...
    X