Advertisement
Guest User

Untitled

a guest
May 25th, 2015
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 3.42 KB | None | 0 0
  1. 2015-05-21 15:02:53,532 [ERROR][pool-1-thread-2 ][com.seriousenergy.da.AbstractDataAggregatorBuilder] - UPDATING_PRICE_SLAB throws exception unhandled exception:
  2. org.springframework.jdbc.BadSqlGrammarException:
  3. ### 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
  4.                 meter_id in
  5.                 (
  6.                     1
  7.         ' at line 5
  8. ### The error may involve defaultParameterMap
  9. ### The error occurred while setting parameters
  10. ### SQL: update energy_usage set energy_cost = powergrid_usage_wh * ?, TOU = ?           WHERE (                                           or                 meter_id                    in                  (                     ?                 ,                     ?                 ,                     ?                 )                                             )             and reading_datetime between ? and ?
  11. ### 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
  12. --
  13. 2015-05-21 15:04:19,695 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.newtariff.BudgetProjection2Processor] - Processing asset [id=217] finished
  14. 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
  15. 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
  16. 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
  17. 2015-05-21 15:04:19,742 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.processor.RegionAggregationProcessor] - No regions configured for customer id=1869
  18. 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
  19. 2015-05-21 15:04:19,758 [INFO ][pool-1-thread-3 ][com.seriousenergy.da.AbstractDataAggregatorBuilder] - Started alerts processing for customer: 1869
  20. 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