Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2015-05-21 15:02:53,532 [ERROR][pool-1-thread-2 ][com.seriousenergy.da.AbstractDataAggregatorBuilder] - UPDATING_PRICE_SLAB throws exception unhandled exception:
- org.springframework.jdbc.BadSqlGrammarException:
- ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'or
- meter_id in
- (
- 1
- ' at line 5
- ### The error may involve defaultParameterMap
- ### The error occurred while setting parameters
- ### SQL: update energy_usage set energy_cost = powergrid_usage_wh * ?, TOU = ? WHERE ( or meter_id in ( ? , ? , ? ) ) and reading_datetime between ? and ?
- ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers ion for the right syntax to use near 'or
- --
- 2015-05-21 15:04:19,695 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.newtariff.BudgetProjection2Processor] - Processing asset [id=217] finished
- 2015-05-21 15:04:19,695 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.newtariff.BudgetProjection2Processor] - Processing campus [id=33, startDate=2015-05-01 ] finished
- 2015-05-21 15:04:19,715 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.DataAggregatorProcessor] - NEW DA: Finished CALCULATING_BUDGET_PROJECTION process for customer 1869
- 2015-05-21 15:04:19,715 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.DataAggregatorProcessor] - NEW DA: Started CALCULATING_REGION_AGGREGATE process for cu stomer 1869
- 2015-05-21 15:04:19,742 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.RegionAggregationProcessor] - No regions configured for customer id=1869
- 2015-05-21 15:04:19,758 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.DataAggregatorProcessor] - NEW DA: Finished CALCULATING_REGION_AGGREGATE process for c ustomer 1869
- 2015-05-21 15:04:19,758 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.AbstractDataAggregatorBuilder] - Started alerts processing for customer: 1869
- 2015-05-21 15:04:20,001 [INFO ][pool-1-thread-3 ][com.seriousenergy.service.customer.AlertService] - start time was null. Will use current time and continue. ErrorMess age{message=Virtual point [alert2] have alerts on values [[ Reading Time: 2013-03-10T01:45:00.000Z, Raw Reading Time: 2013-03-10T01:45:00.000Z, Value: 5.172 Cum: nul l, Reading Time: 2013-03-10T03:00:00.000Z, Raw Reading Time: 2013-03-10T03:00:00.000Z, Value: 5.3452 Cum: null, Reading Time: 2013-03-10T03:15:00.000Z, Raw Readi ng Time: 2013-03-10T03:15:00.000Z, Value: 5.5184 Cum: null, Reading Time: 2013-03-10T03:30:00.000Z, Raw Reading Time: 2013-03-10T03:30:00.000Z, Value: 5.6916 Cum: n ull, Reading Time: 2013-03-10T03:45:00.000Z, Raw Reading Time: 2013-03-10T03:45:00.000Z, Value: 5.8648 Cum: null, Reading Time: 2013-03-10T04:00:00.000Z, Raw Rea
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement