Advertisement
Guest User

Untitled

a guest
Apr 20th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.64 KB | None | 0 0
  1. net.n2oapp.framework.engine.rest.N2oRestException
  2. at net.n2oapp.framework.engine.rest.RestUtil.toN2oRestException(RestUtil.java:34)
  3. at net.n2oapp.framework.engine.rest.RestInvocationEngine.lambda$0(RestInvocationEngine.java:51)
  4. at net.n2oapp.framework.engine.util.json.DateFormatSerializingTemplate.execute(DateFormatSerializingTemplate.java:13)
  5. at net.n2oapp.framework.engine.rest.RestInvocationEngine.invoke(RestInvocationEngine.java:47)
  6. at net.n2oapp.framework.engine.processor.InvocationProcessorImpl.invoke(InvocationProcessorImpl.java:64)
  7. at net.n2oapp.framework.engine.processor.InvocationProcessorImpl.invoke(InvocationProcessorImpl.java:52)
  8. at net.n2oapp.framework.engine.processor.ActionProcessor.invoke(ActionProcessor.java:46)
  9. at net.n2oapp.framework.ui.controller.action.SetController.handleActionRequest(SetController.java:35)
  10. at net.n2oapp.framework.ui.controller.action.ActionController.executeRequest(ActionController.java:40)
  11. at net.n2oapp.framework.ui.controller.action.ActionController.execute(ActionController.java:34)
  12. at net.n2oapp.framework.ui.controller.DataController.setData(DataController.java:68)
  13. at net.n2oapp.framework.ui.servlet.data.DataServlet$2.resolveSuccessModel(DataServlet.java:44)
  14. at net.n2oapp.framework.mvc.callback.json.JsonServletCallback.onService(JsonServletCallback.java:25)
  15. at net.n2oapp.framework.mvc.api.SimpleServletTemplate.doService(SimpleServletTemplate.java:28)
  16. at net.n2oapp.framework.ui.servlet.data.DataServlet.safeDoPost(DataServlet.java:39)
  17. at net.n2oapp.framework.mvc.n2o.N2oServlet.doPost(N2oServlet.java:95)
  18. at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
  19. at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  20. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  21. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  22. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  23. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  24. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  25. at net.n2oapp.security.auth.filter.WorkplaceFilter.doFilter(WorkplaceFilter.java:53)
  26. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  27. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  28. at net.n2oapp.framework.ui.servlet.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:28)
  29. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  30. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  31. at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
  32. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  33. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  34. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  35. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  36. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  37. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  38. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
  39. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  40. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  41. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  42. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
  43. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  44. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  45. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  46. at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
  47. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  48. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  49. at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:177)
  50. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  51. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  52. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  53. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  54. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  55. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121)
  56. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  57. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
  58. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  59. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  60. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  61. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  62. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  63. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:106)
  64. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  65. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  66. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  67. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  68. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  69. at net.n2oapp.security.auth.filter.SecurityFilter.doFilter(SecurityFilter.java:43)
  70. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  71. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  72. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  73. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  74. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  75. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  76. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  77. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
  78. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  79. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  80. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  81. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
  82. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  83. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  84. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  85. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  86. at java.lang.Thread.run(Thread.java:748)
  87.  
  88. Foreign stacktrace:
  89. org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select disp.md_event_batch_add_patient_function(?, array[1897917,1691059,589059,1870358,592126,1494720,1865186,1478687,1711901,1728128,1685724,733952,1983869,593632,246226,1095135,593363,1477390,588127,733104,591658,594725,589728,591860,1694157,590397,1832662,1890919,732303,1990226,1458890,1462748,732177,955367,1881831,1824466,1933412,1711878,502249,588150,1697039,588152,587531,591454,586840,588710,1543737,590637,1897911,1834165,1890016,244903,1679699,733178,1550917,1842705,1890915,1890910,1899552,595362], array['2.1','3','17','2.11','10','5','3','7','2.10','2.8','3','11','0.3','9','16','6','9','14','14','13','17','8','13','11','2.11','12','2.11','2.2','15','0.1','6','6','17','7','2.6','7','1.3','2.11','7','16','2.11','16','14','17','16','13','6','12','2.2','2.9','2.6','11','7','14','4','2.9','2.3','2.4','2.1','7'])]; SQL state [P0001]; error code [0]; ERROR: Patient [public.pci_patient.id = 1832662] already exists in event [disp.md_event.id = 5377]
  90. Where: PL/pgSQL function disp.check_md_event_patient_unique_patient() line 22 at RAISE
  91. SQL statement "INSERT INTO disp.md_event_patient (id, event_id, indiv_id, not_actual_patient, event_age) SELECT
  92. ids [index],
  93. xeid,
  94. patient_ids [index],
  95. FALSE,
  96. patient_ages [index]
  97. FROM generate_series(1,
  98. size) AS index"
  99. PL/pgSQL function disp.md_event_batch_add_patient_function(integer,integer[],character varying[]) line 88 at SQL statement; nested exception is org.postgresql.util.PSQLException: ERROR: Patient [public.pci_patient.id = 1832662] already exists in event [disp.md_event.id = 5377]
  100. Where: PL/pgSQL function disp.check_md_event_patient_unique_patient() line 22 at RAISE
  101. SQL statement "INSERT INTO disp.md_event_patient (id, event_id, indiv_id, not_actual_patient, event_age) SELECT
  102. ids [index],
  103. xeid,
  104. patient_ids [index],
  105. FALSE,
  106. patient_ages [index]
  107. FROM generate_series(1,
  108. size) AS index"
  109. PL/pgSQL function disp.md_event_batch_add_patient_function(integer,integer[],character varying[]) line 88 at SQL statement
  110. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)
  111. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  112. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  113. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
  114. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
  115. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
  116. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
  117. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772)
  118. at org.springframework.jdbc.core.JdbcTemplate.queryForList(JdbcTemplate.java:849)
  119. at ru.kirkazan.rmis.app.dispensary.impl.dao.impl.JdbcEventDao.insertEventPatients(JdbcEventDao.java:281)
  120. at ru.kirkazan.rmis.app.dispensary.impl.service.EventServiceImpl.takePatientsMinorsForEvent(EventServiceImpl.java:99)
  121. at ru.kirkazan.rmis.app.dispensary.backend.service.EventController.takePatientsMinorsForEvent(EventController.java:23)
  122. at ru.kirkazan.rmis.app.dispensary.backend.rest.DispensaryRest.takePatients(DispensaryRest.java:41)
  123. at sun.reflect.GeneratedMethodAccessor3344.invoke(Unknown Source)
  124. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  125. at java.lang.reflect.Method.invoke(Method.java:498)
  126. at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:180)
  127. at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:96)
  128. at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:189)
  129. at org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:99)
  130. at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59)
  131. at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96)
  132. at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
  133. at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
  134. at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:252)
  135. at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234)
  136. at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208)
  137. at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:160)
  138. at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:180)
  139. at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:299)
  140. at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:223)
  141. at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
  142. at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:274)
  143. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  144. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  145. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  146. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  147. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  148. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  149. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  150. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  151. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  152. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  153. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
  154. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  155. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  156. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  157. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
  158. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  159. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  160. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  161. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  162. at java.lang.Thread.run(Thread.java:748)
  163. Caused by: org.postgresql.util.PSQLException: ERROR: Patient [public.pci_patient.id = 1832662] already exists in event [disp.md_event.id = 5377]
  164. Where: PL/pgSQL function disp.check_md_event_patient_unique_patient() line 22 at RAISE
  165. SQL statement "INSERT INTO disp.md_event_patient (id, event_id, indiv_id, not_actual_patient, event_age) SELECT
  166. ids [index],
  167. xeid,
  168. patient_ids [index],
  169. FALSE,
  170. patient_ages [index]
  171. FROM generate_series(1,
  172. size) AS index"
  173. PL/pgSQL function disp.md_event_batch_add_patient_function(integer,integer[],character varying[]) line 88 at SQL statement
  174. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2412)
  175. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2125)
  176. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:297)
  177. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
  178. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
  179. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
  180. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
  181. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688)
  182. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
  183. ... 49 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement