API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 27th, 2016
83
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.89 KB | None | 0 0
raw download clone embed print report
  1. 2016-04-27 11:01:10,932 [INFO ][main ][com.seriousenergy.databasequeue.DatabaseQueue] - Updating module state to InQueue for module EMAILER for customer with ID: 1880
  2. 2016-04-27 11:01:11,022 [INFO ][Pool5 ][snaq.db.ConnectionPool.sch001833] - sch001833: Created a new connection
  3. 2016-04-27 11:01:11,053 [INFO ][main ][com.seriousenergy.databasequeue.DatabaseQueue] - Updating module state to InQueue for module EMAILER for customer with ID: 1881
  4. 2016-04-27 11:01:11,025 [INFO ][Thread-34 ][snaq.db.ConnectionPool.sch001833] - sch001833: Getting connection (user/password): jdbc:mysql://rds-dev.chso9bu1i008.us-east-1.rds.amazonaws.com:3306/brandywine?autoReconnect=true
  5. 2016-04-27 11:01:11,309 [ERROR][Pool2 ][ iLonEmailer1813] - SELECT distinct ep.ecm_id ,recipients ,ep.annual_kwh_savings,kwh_threshold,ep.annual_cost_savings,cost_threshold,ecm_name ,campus_id,building_id,ep.asset_id,ecm_state_id,episode_count,episode_hours,DATE_FORMAT(first_datetime,'%Y-%m-%d'),DATE_FORMAT(last_datetime,'%Y-%m-%d') FROM ecm_episodes ep,ecm_master em,ecm_summary es where alert_flag='N' and DATE_FORMAT(end_datetime,'%Y-%m-%d')='2016-04-27 11:01:11' and ep.ecm_id=em.ecm_id and ep.ecm_id=es.ecm_id
  6. Pool sch001813 not found
  7. java.lang.IllegalArgumentException: Pool sch001813 not found
  8. at snaq.db.ConnectionPoolManager.getConnection(ConnectionPoolManager.java:1204)
  9. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:318)
  10. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:310)
  11. at com.mgems.DataGateway.DataGateWay.executeQuery(DataGateWay.java:363)
  12. at emailer.Emailer.sendECMAlert(Emailer.java:1657)
  13. at emailer.Emailer.collectData(Emailer.java:239)
  14. at emailer.Emailer.run(Emailer.java:202)
  15. at threading.ThreadTask.run(ThreadPool.java:27)
  16. 2016-04-27 11:01:11,321 [INFO ][main ][com.seriousenergy.databasequeue.DatabaseQueue] - Updating module state to InQueue for module EMAILER for customer with ID: 1882
  17. 2016-04-27 11:01:11,321 [ERROR][Pool3 ][ iLonEmailer1827] - SELECT distinct ep.ecm_id ,recipients ,ep.annual_kwh_savings,kwh_threshold,ep.annual_cost_savings,cost_threshold,ecm_name ,campus_id,building_id,ep.asset_id,ecm_state_id,episode_count,episode_hours,DATE_FORMAT(first_datetime,'%Y-%m-%d'),DATE_FORMAT(last_datetime,'%Y-%m-%d') FROM ecm_episodes ep,ecm_master em,ecm_summary es where alert_flag='N' and DATE_FORMAT(end_datetime,'%Y-%m-%d')='2016-04-27 11:01:11' and ep.ecm_id=em.ecm_id and ep.ecm_id=es.ecm_id
  18. Pool sch001827 not found
  19. java.lang.IllegalArgumentException: Pool sch001827 not found
  20. at snaq.db.ConnectionPoolManager.getConnection(ConnectionPoolManager.java:1204)
  21. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:318)
  22. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:310)
  23. at com.mgems.DataGateway.DataGateWay.executeQuery(DataGateWay.java:363)
  24. at emailer.Emailer.sendECMAlert(Emailer.java:1657)
  25. at emailer.Emailer.collectData(Emailer.java:239)
  26. at emailer.Emailer.run(Emailer.java:202)
  27. at threading.ThreadTask.run(ThreadPool.java:27)
  28. 2016-04-27 11:01:11,324 [ERROR][Pool3 ][ iLonEmailer1827] - SELECT al.alert_text, al.alert_type, nl.date_time, als.email_id, als.phone_number, ssp.sms_sp_email, nl.send_mail, nl.send_sms, nl.alert_smry_id, nl.subscriber_id, al.campus_id,als.user_id, alts.asset_id, al.gateway_id,attm.userdefined_alertType,alts.alert_severity, alts.alert_duration, gl.gateway_name, alts.virtual_point_id, al.prepared_email FROM notification_log nl LEFT JOIN alert_table al ON al.alert_smry_id = nl.alert_smry_id LEFT JOIN alert_summary alts on alts.alert_smry_id=al.alert_smry_id LEFT JOIN alert_type_master attm on attm.alert_type_id = nl.alert_type LEFT JOIN alert_subscription als on nl.subscriber_id = als.subscriber_id LEFT JOIN sms_service_providers ssp ON als.sms_service_provider_id = ssp.id LEFT JOIN gateway_list gl on al.gateway_id = gl.gateway_id LEFT JOIN virtual_points vp on alts.virtual_point_id = vp.vp_id LEFT JOIN vp_alert_config vpa on vp.vp_alert_id = vpa.vp_alert_id where (nl.send_mail = 1 OR nl.send_sms=1 OR nl.summary_flag=1) AND (alts.virtual_point_id IS NULL OR vpa.vp_alert_id IS NOT NULL) GROUP BY nl.alert_smry_id, nl.subscriber_id
  29. Pool sch001827 not found
  30. java.lang.IllegalArgumentException: Pool sch001827 not found
  31. at snaq.db.ConnectionPoolManager.getConnection(ConnectionPoolManager.java:1204)
  32. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:318)
  33. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:310)
  34. at com.mgems.DataGateway.DataGateWay.executeQuery(DataGateWay.java:363)
  35. at emailer.Emailer.getMailDetails(Emailer.java:1475)
  36. at emailer.Emailer.collectData(Emailer.java:244)
  37. at emailer.Emailer.run(Emailer.java:202)
  38. at threading.ThreadTask.run(ThreadPool.java:27)
  39. 2016-04-27 11:01:11,324 [INFO ][Pool3 ][com.seriousenergy.databasequeue.DatabaseQueue] - Updating module state to Completed for module EMAILER for customer with ID: 1827
  40. 2016-04-27 11:01:11,324 [INFO ][Pool1 ][snaq.db.ConnectionPool.sch001808] - sch001808: Created a new connection
  41. 2016-04-27 11:01:11,325 [INFO ][Thread-39 ][snaq.db.ConnectionPool.sch001813] - sch001813: Created a new connection
  42. 2016-04-27 11:01:11,335 [INFO ][Thread-47 ][snaq.db.ConnectionPool.sch001808] - sch001808: Getting connection (user/password): jdbc:mysql://rds-dev.chso9bu1i008.us-east-1.rds.amazonaws.com:3306/PacificPalms?autoReconnect=true
  43. 2016-04-27 11:01:11,484 [ERROR][Pool2 ][ iLonEmailer1827] - SELECT al.alert_text, al.alert_type, nl.date_time, als.email_id, als.phone_number, ssp.sms_sp_email, nl.send_mail, nl.send_sms, nl.alert_smry_id, nl.subscriber_id, al.campus_id,als.user_id, alts.asset_id, al.gateway_id,attm.userdefined_alertType,alts.alert_severity, alts.alert_duration, gl.gateway_name, alts.virtual_point_id, al.prepared_email FROM notification_log nl LEFT JOIN alert_table al ON al.alert_smry_id = nl.alert_smry_id LEFT JOIN alert_summary alts on alts.alert_smry_id=al.alert_smry_id LEFT JOIN alert_type_master attm on attm.alert_type_id = nl.alert_type LEFT JOIN alert_subscription als on nl.subscriber_id = als.subscriber_id LEFT JOIN sms_service_providers ssp ON als.sms_service_provider_id = ssp.id LEFT JOIN gateway_list gl on al.gateway_id = gl.gateway_id LEFT JOIN virtual_points vp on alts.virtual_point_id = vp.vp_id LEFT JOIN vp_alert_config vpa on vp.vp_alert_id = vpa.vp_alert_id where (nl.send_mail = 1 OR nl.send_sms=1 OR nl.summary_flag=1) AND (alts.virtual_point_id IS NULL OR vpa.vp_alert_id IS NOT NULL) GROUP BY nl.alert_smry_id, nl.subscriber_id
  44. Pool sch001813 not found
  45. java.lang.IllegalArgumentException: Pool sch001813 not found
  46. at snaq.db.ConnectionPoolManager.getConnection(ConnectionPoolManager.java:1204)
  47. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:318)
  48. at com.mgems.DataGateway.DataGateWay.getConnection(DataGateWay.java:310)
  49. at com.mgems.DataGateway.DataGateWay.executeQuery(DataGateWay.java:363)
  50. at emailer.Emailer.getMailDetails(Emailer.java:1475)
  51. at emailer.Emailer.collectData(Emailer.java:244)
  52. at emailer.Emailer.run(Emailer.java:202)
  53. at threading.ThreadTask.run(ThreadPool.java:27)
  54. 2016-04-27 11:01:11,487 [INFO ][Pool2 ][com.seriousenergy.databasequeue.DatabaseQueue] - Updating module state to Completed for module EMAILER for customer with ID: 1813
  55. 2016-04-27 11:01:11,501 [INFO ][main ][com.seriousenergy.databasequeue.DatabaseQueue] - Updating module state to InQueue for module EMAILER for customer with ID: 1883
  56. 2016-04-27 11:01:11,503 [INFO ][Thread-43 ][snaq.db.ConnectionPool.sch001827] - sch001827: Created a new connection
  57. 2016-04-27 11:01:11,504 [INFO ][Thread-30 ][snaq.db.ConnectionPool.sch001831] - sch001831: Created a new connection
  58. 2016-04-27 11:01:11,506 [INFO ][Thread-34 ][snaq.db.ConnectionPool.sch001833] - sch001833: Created a new connection
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!