API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 26th, 2016
54
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 37.61 KB | None | 0 0
raw download clone embed print report
  1. 26/05/16 14:29:29.166 : INFO : Worker.3 : 2016-05-26 14:29:29.166 INFO 2224 --- [nio-9891-exec-2] esOfEnhancedRecordByBatchInParamProvider : TIME_SERIES params provided, with real data: [RunStatistics.StopwatchInfos(timestamp=2016-05-26T12:29:28.707Z, task=loading rule params, duration=PT0S, childs=null)] with ByBatchTimeseriesParams(group=Params.Group(groupBy=BATCH, groupOns=[]), related_micro_events=[Params.RelatedMicroEvent(code=none, value=null)], size=5)
  2. 26/05/16 14:29:29.200 : INFO : Worker.3 : 2016-05-26 14:29:29.200 INFO 2224 --- [nio-9891-exec-2] c.n.p.e.e.ext.config.ConfigProvider : Found 1 params ([saveinputoutputdata]) from IVPower config service, matching request ConfigProvider.ConfigParam(keys=[], prefixes=[extrule.prefaultdetection-sliding-values-calculation-0.18-SNAPSHOT.jar, extrule.prefaultdetection-sliding-values-calculation-0.18-SNAPSHOT, extrule.prefaultdetection-sliding-values-calculation, extrule.general], unprefix=true), out of 46 properties loaded
  3. 26/05/16 14:29:29.234 : INFO : Worker.3 : 2016-05-26 14:29:29.200 INFO 2224 --- [nio-9891-exec-2] c.n.p.e.e.e.c.RuleConfigInParamProvider : Found 1 rule properties for prefaultdetection-sliding-values-calculation-0.18-SNAPSHOT.jar: {saveinputoutputdata=1.0}
  4. 26/05/16 14:29:30.321 : INFO : Worker.1 : 2016-05-26 14:29:30.321 INFO 2084 --- [nio-9892-exec-6] c.n.i.d.spring.web.TimeseriesController : Has loaded all 5 TS data in 1.07s
  5. 26/05/16 14:29:36.827 : INFO : Worker.1 : 2016-05-26 14:29:36.827 WARN 2084 --- [nio-9892-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState:
  6. 26/05/16 14:29:36.827 : INFO : Worker.1 : 2016-05-26 14:29:36.827 ERROR 2084 --- [nio-9892-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : Batch entry 0 insert into sliding_values_descriptor (channel_name, clock_name, data_json, descriptor_json, estimated_real_trigger_time, monitored_object_name, monitored_object_type, natural_id, origin, phase, processing_session_id, quantity, uri, split_no, relative_begin_time_micros, relative_end_time_micros, tolerance_ret, trigger_time, value_type, id) values ( E'', E'MATLA_PS_DFR01_P531', 24241, 24242, 1438002482851000000, E'MATLA_POWER_STATION_275_NEVIS_2', E'FEEDER', E'SlidingValues-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e-0-275 Nevis 2 White Ph Current-FEEDER-MATLA_POWER_STATION_275_NEVIS_2-SYNCHRO_VALUE-CURRENT-L2-0-transientsRecord-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', E'SlidingValuesCalculation', E'L2', E'8d9ac2f9-0759-416c-bb2d-a58239fe7559', E'CURRENT', E'20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', 0, -660000, 2710000, NULL, 1438002482851000000, E'SYNCHRO_VALUE', 11272) was aborted. Call getNextException to see the cause.
  7. 26/05/16 14:29:36.827 : INFO : Worker.1 : 2016-05-26 14:29:36.827 WARN 2084 --- [nio-9892-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState:
  8. 26/05/16 14:29:36.827 : INFO : Worker.1 : 2016-05-26 14:29:36.827 ERROR 2084 --- [nio-9892-exec-7] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: duplicate key value violates unique constraint "uk_5niu4u61v3db4vkyql8kxafc5"
  9. 26/05/16 14:29:36.844 : INFO : Worker.1 : 2016-05-26 14:29:36.844 ERROR 2084 --- [nio-9892-exec-7] o.h.e.jdbc.batch.internal.BatchingBatch : HHH000315: Exception executing batch [could not execute batch]
  10. 26/05/16 14:29:36.861 : INFO : Worker.1 : 2016-05-26 14:29:36.861 ERROR 2084 --- [nio-9892-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into sliding_values_descriptor (channel_name, clock_name, data_json, descriptor_json, estimated_real_trigger_time, monitored_object_name, monitored_object_type, natural_id, origin, phase, processing_session_id, quantity, uri, split_no, relative_begin_time_micros, relative_end_time_micros, tolerance_ret, trigger_time, value_type, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state []; error code [0]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch] with root cause
  11. 26/05/16 14:29:36.861 : INFO : Worker.1 :
  12. 26/05/16 14:29:36.861 : INFO : Worker.1 : java.sql.BatchUpdateException: Batch entry 0 insert into sliding_values_descriptor (channel_name, clock_name, data_json, descriptor_json, estimated_real_trigger_time, monitored_object_name, monitored_object_type, natural_id, origin, phase, processing_session_id, quantity, uri, split_no, relative_begin_time_micros, relative_end_time_micros, tolerance_ret, trigger_time, value_type, id) values ( E'', E'MATLA_PS_DFR01_P531', 24241, 24242, 1438002482851000000, E'MATLA_POWER_STATION_275_NEVIS_2', E'FEEDER', E'SlidingValues-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e-0-275 Nevis 2 White Ph Current-FEEDER-MATLA_POWER_STATION_275_NEVIS_2-SYNCHRO_VALUE-CURRENT-L2-0-transientsRecord-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', E'SlidingValuesCalculation', E'L2', E'8d9ac2f9-0759-416c-bb2d-a58239fe7559', E'CURRENT', E'20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', 0, -660000, 2710000, NULL, 1438002482851000000, E'SYNCHRO_VALUE', 11272) was aborted. Call getNextException to see the cause.
  13. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
  14. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl$2.handleError(QueryExecutorImpl.java:283)
  15. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:484)
  16. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
  17. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
  18. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
  19. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
  20. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:113)
  21. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101)
  22. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161)
  23. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:207)
  24. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:390)
  25. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
  26. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
  27. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
  28. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
  29. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)
  30. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
  31. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
  32. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
  33. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
  34. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
  35. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:150)
  36. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.netceler.libs.sandbox.hibernateutils.TransactionTemplateUtils.executeInTransaction(TransactionTemplateUtils.java:30)
  37. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.netceler.libs.sandbox.hibernateutils.TransactionTemplateUtils.executeInTransaction(TransactionTemplateUtils.java:21)
  38. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.netceler.ivpower.soe.dao.hibernate.HibernateSlidingValuesDescriptorDao.persist(HibernateSlidingValuesDescriptorDao.java:29)
  39. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.netceler.ivpower.soe.dao.hibernate.HibernateSlidingValuesDescriptorDao.persist(HibernateSlidingValuesDescriptorDao.java:18)
  40. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.netceler.ivpower.dataservice.dao.SlidingValuesDescriptorDataAccess.store(SlidingValuesDescriptorDataAccess.java:84)
  41. 26/05/16 14:29:36.861 : INFO : Worker.1 : at com.netceler.ivpower.dataservice.spring.web.SlidingValuesDescriptorController.store(SlidingValuesDescriptorController.java:121)
  42. 26/05/16 14:29:36.861 : INFO : Worker.1 : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  43. 26/05/16 14:29:36.861 : INFO : Worker.1 : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  44. 26/05/16 14:29:36.861 : INFO : Worker.1 : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  45. 26/05/16 14:29:36.861 : INFO : Worker.1 : at java.lang.reflect.Method.invoke(Method.java:497)
  46. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  47. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  48. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  49. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:775)
  50. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
  51. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  52. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
  53. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
  54. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
  55. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
  56. 26/05/16 14:29:36.861 : INFO : Worker.1 : at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  57. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
  58. 26/05/16 14:29:36.861 : INFO : Worker.1 : at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  59. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
  60. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  61. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  62. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  63. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  64. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
  65. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  66. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  67. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  68. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  69. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  70. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  71. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  72. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
  73. 26/05/16 14:29:36.861 : INFO : Worker.1 : at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  74. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  75. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  76. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
  77. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  78. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  79. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
  80. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  81. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  82. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
  83. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
  84. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
  85. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
  86. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
  87. 26/05/16 14:29:36.878 : INFO : Worker.1 : at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  88. 26/05/16 14:29:36.878 : INFO : Worker.1 : at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  89. 26/05/16 14:29:36.878 : INFO : Worker.1 : at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  90. 26/05/16 14:29:36.878 : INFO : Worker.1 : at java.lang.Thread.run(Thread.java:745)
  91. 26/05/16 14:29:36.878 : INFO : Worker.1 :
  92. 26/05/16 14:29:37.111 : INFO : Worker.1 : 2016-05-26 14:29:37.095 INFO 2084 --- [nio-9892-exec-8] c.n.i.d.spring.web.TimeseriesController : Has loaded all 1 TS data in 0.2s
  93. 26/05/16 14:29:37.688 : INFO : Worker.1 : 2016-05-26 14:29:37.688 WARN 2084 --- [nio-9892-exec-9] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState:
  94. 26/05/16 14:29:37.688 : INFO : Worker.1 : 2016-05-26 14:29:37.688 ERROR 2084 --- [nio-9892-exec-9] o.h.engine.jdbc.spi.SqlExceptionHelper : Batch entry 0 insert into sliding_values_descriptor (channel_name, clock_name, data_json, descriptor_json, estimated_real_trigger_time, monitored_object_name, monitored_object_type, natural_id, origin, phase, processing_session_id, quantity, uri, split_no, relative_begin_time_micros, relative_end_time_micros, tolerance_ret, trigger_time, value_type, id) values ( E'', E'MATLA_PS_DFR01_P531', 24243, 24244, 1438002482851000000, E'MATLA_POWER_STATION_275_NEVIS_2', E'FEEDER', E'SlidingValues-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e-0-275 Nevis 2 Red Ph Current-FEEDER-MATLA_POWER_STATION_275_NEVIS_2-SYNCHRO_VALUE-CURRENT-L1-0-transientsRecord-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', E'SlidingValuesCalculation', E'L1', E'8d9ac2f9-0759-416c-bb2d-a58239fe7559', E'CURRENT', E'20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', 0, -660000, 2710000, NULL, 1438002482851000000, E'SYNCHRO_VALUE', 11273) was aborted. Call getNextException to see the cause.
  95. 26/05/16 14:29:37.688 : INFO : Worker.1 : 2016-05-26 14:29:37.688 WARN 2084 --- [nio-9892-exec-9] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState:
  96. 26/05/16 14:29:37.688 : INFO : Worker.1 : 2016-05-26 14:29:37.688 ERROR 2084 --- [nio-9892-exec-9] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: duplicate key value violates unique constraint "uk_5niu4u61v3db4vkyql8kxafc5"
  97. 26/05/16 14:29:37.688 : INFO : Worker.1 : 2016-05-26 14:29:37.688 ERROR 2084 --- [nio-9892-exec-9] o.h.e.jdbc.batch.internal.BatchingBatch : HHH000315: Exception executing batch [could not execute batch]
  98. 26/05/16 14:29:37.688 : INFO : Worker.1 : 2016-05-26 14:29:37.688 ERROR 2084 --- [nio-9892-exec-9] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [insert into sliding_values_descriptor (channel_name, clock_name, data_json, descriptor_json, estimated_real_trigger_time, monitored_object_name, monitored_object_type, natural_id, origin, phase, processing_session_id, quantity, uri, split_no, relative_begin_time_micros, relative_end_time_micros, tolerance_ret, trigger_time, value_type, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state []; error code [0]; could not execute batch; nested exception is org.hibernate.exception.GenericJDBCException: could not execute batch] with root cause
  99. 26/05/16 14:29:37.688 : INFO : Worker.1 :
  100. 26/05/16 14:29:37.688 : INFO : Worker.1 : java.sql.BatchUpdateException: Batch entry 0 insert into sliding_values_descriptor (channel_name, clock_name, data_json, descriptor_json, estimated_real_trigger_time, monitored_object_name, monitored_object_type, natural_id, origin, phase, processing_session_id, quantity, uri, split_no, relative_begin_time_micros, relative_end_time_micros, tolerance_ret, trigger_time, value_type, id) values ( E'', E'MATLA_PS_DFR01_P531', 24243, 24244, 1438002482851000000, E'MATLA_POWER_STATION_275_NEVIS_2', E'FEEDER', E'SlidingValues-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e-0-275 Nevis 2 Red Ph Current-FEEDER-MATLA_POWER_STATION_275_NEVIS_2-SYNCHRO_VALUE-CURRENT-L1-0-transientsRecord-20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', E'SlidingValuesCalculation', E'L1', E'8d9ac2f9-0759-416c-bb2d-a58239fe7559', E'CURRENT', E'20150727H130802851000_dd2f426a047e5e27fc58ea0ae5a6d24e', 0, -660000, 2710000, NULL, 1438002482851000000, E'SYNCHRO_VALUE', 11273) was aborted. Call getNextException to see the cause.
  101. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2762)
  102. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl$2.handleError(QueryExecutorImpl.java:283)
  103. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:484)
  104. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
  105. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:291)
  106. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2929)
  107. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
  108. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:113)
  109. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:101)
  110. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:161)
  111. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:207)
  112. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:390)
  113. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)
  114. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)
  115. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
  116. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)
  117. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)
  118. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)
  119. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)
  120. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.orm.hibernate4.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:584)
  121. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:757)
  122. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:726)
  123. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:150)
  124. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.netceler.libs.sandbox.hibernateutils.TransactionTemplateUtils.executeInTransaction(TransactionTemplateUtils.java:30)
  125. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.netceler.libs.sandbox.hibernateutils.TransactionTemplateUtils.executeInTransaction(TransactionTemplateUtils.java:21)
  126. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.netceler.ivpower.soe.dao.hibernate.HibernateSlidingValuesDescriptorDao.persist(HibernateSlidingValuesDescriptorDao.java:29)
  127. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.netceler.ivpower.soe.dao.hibernate.HibernateSlidingValuesDescriptorDao.persist(HibernateSlidingValuesDescriptorDao.java:18)
  128. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.netceler.ivpower.dataservice.dao.SlidingValuesDescriptorDataAccess.store(SlidingValuesDescriptorDataAccess.java:84)
  129. 26/05/16 14:29:37.688 : INFO : Worker.1 : at com.netceler.ivpower.dataservice.spring.web.SlidingValuesDescriptorController.store(SlidingValuesDescriptorController.java:121)
  130. 26/05/16 14:29:37.688 : INFO : Worker.1 : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  131. 26/05/16 14:29:37.688 : INFO : Worker.1 : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  132. 26/05/16 14:29:37.688 : INFO : Worker.1 : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  133. 26/05/16 14:29:37.688 : INFO : Worker.1 : at java.lang.reflect.Method.invoke(Method.java:497)
  134. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)
  135. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:137)
  136. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)
  137. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:775)
  138. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:705)
  139. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
  140. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
  141. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
  142. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
  143. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
  144. 26/05/16 14:29:37.688 : INFO : Worker.1 : at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
  145. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
  146. 26/05/16 14:29:37.688 : INFO : Worker.1 : at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  147. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
  148. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  149. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  150. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  151. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  152. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
  153. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  154. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  155. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  156. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
  157. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  158. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  159. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  160. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:85)
  161. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  162. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
  163. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  164. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
  165. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
  166. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
  167. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
  168. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  169. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
  170. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
  171. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
  172. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
  173. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
  174. 26/05/16 14:29:37.688 : INFO : Worker.1 : at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
  175. 26/05/16 14:29:37.704 : INFO : Worker.1 : at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  176. 26/05/16 14:29:37.704 : INFO : Worker.1 : at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  177. 26/05/16 14:29:37.704 : INFO : Worker.1 : at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  178. 26/05/16 14:29:37.704 : INFO : Worker.1 : at java.lang.Thread.run(Thread.java:745)
  179. 26/05/16 14:29:37.704 : INFO : Worker.1 :
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!