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.
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.
Comment