Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.72 KB | None | 0 0
  1. net.n2oapp.framework.engine.exception.N2oSqlException: A result was returned when none was expected.
  2. at net.n2oapp.framework.engine.util.SqlJpqlUtil.executeQueries(SqlJpqlUtil.java:215)
  3. at net.n2oapp.framework.engine.data.action.SqlInvocationEngine.lambda$0(SqlInvocationEngine.java:49)
  4. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  5. at net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate.lambda$execute$0(JndiRoutingDataSourceTemplate.java:26)
  6. at net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate.execute(JndiRoutingDataSourceTemplate.java:17)
  7. at net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate.execute(JndiRoutingDataSourceTemplate.java:25)
  8. at net.n2oapp.framework.engine.data.action.SqlInvocationEngine.execute(SqlInvocationEngine.java:46)
  9. at net.n2oapp.framework.engine.data.action.SqlInvocationEngine.invoke(SqlInvocationEngine.java:41)
  10. at net.n2oapp.framework.engine.processor.InvocationProcessorImpl.invoke(InvocationProcessorImpl.java:64)
  11. at net.n2oapp.framework.engine.processor.InvocationProcessorImpl.invoke(InvocationProcessorImpl.java:52)
  12. at net.n2oapp.framework.api.data.validation.ConstraintValidation.validate(ConstraintValidation.java:108)
  13. at net.n2oapp.framework.engine.validation.engine.Validator.handleValidation(Validator.java:65)
  14. at net.n2oapp.framework.engine.validation.engine.Validator.lambda$1(Validator.java:58)
  15. at java.util.ArrayList.forEach(ArrayList.java:1257)
  16. at net.n2oapp.framework.engine.validation.engine.Validator.handleValidationAware(Validator.java:58)
  17. at net.n2oapp.framework.engine.validation.engine.Validator.lambda$0(Validator.java:54)
  18. at java.util.ArrayList.forEach(ArrayList.java:1257)
  19. at net.n2oapp.framework.engine.validation.engine.Validator.validate(Validator.java:54)
  20. at net.n2oapp.framework.engine.validation.engine.ValidationEngine.checkFields(ValidationEngine.java:110)
  21. at net.n2oapp.framework.engine.validation.engine.ValidationEngine.checkOnErrorsBeforeAction(ValidationEngine.java:43)
  22. at net.n2oapp.framework.engine.validation.N2oValidationModule.validateRequestOnErrorsAndWarnings(N2oValidationModule.java:137)
  23. at net.n2oapp.framework.engine.validation.N2oValidationModule.validateProcessAction(N2oValidationModule.java:57)
  24. at net.n2oapp.framework.engine.validation.N2oValidationModule.processAction(N2oValidationModule.java:36)
  25. at net.n2oapp.framework.engine.modules.stack.DataProcessingStack.lambda$0(DataProcessingStack.java:36)
  26. at net.n2oapp.framework.engine.modules.stack.DataProcessingStack.process(DataProcessingStack.java:84)
  27. at net.n2oapp.framework.engine.modules.stack.DataProcessingStack.processAction(DataProcessingStack.java:34)
  28. at net.n2oapp.framework.ui.controller.action.SetController.handleActionRequest(SetController.java:33)
  29. at net.n2oapp.framework.ui.controller.action.ActionController.executeRequest(ActionController.java:40)
  30. at net.n2oapp.framework.ui.controller.action.ActionController.execute(ActionController.java:34)
  31. at net.n2oapp.framework.ui.controller.DataController.setData(DataController.java:68)
  32. at net.n2oapp.framework.ui.servlet.data.DataServlet$2.resolveSuccessModel(DataServlet.java:44)
  33. at net.n2oapp.framework.mvc.callback.json.JsonServletCallback.onService(JsonServletCallback.java:25)
  34. at net.n2oapp.framework.mvc.api.SimpleServletTemplate.doService(SimpleServletTemplate.java:28)
  35. at net.n2oapp.framework.ui.servlet.data.DataServlet.safeDoPost(DataServlet.java:39)
  36. at net.n2oapp.framework.mvc.n2o.N2oServlet.doPost(N2oServlet.java:95)
  37. at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
  38. at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  39. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  40. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  41. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  42. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  43. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  44. at net.n2oapp.security.auth.filter.WorkplaceFilter.doFilter(WorkplaceFilter.java:53)
  45. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  46. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  47. at net.n2oapp.framework.ui.servlet.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:28)
  48. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  49. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  50. at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
  51. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  52. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  53. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  54. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  55. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  56. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  57. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
  58. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  59. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  60. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  61. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
  62. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  63. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  64. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  65. at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
  66. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  67. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  68. at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:177)
  69. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  70. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  71. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  72. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  73. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  74. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121)
  75. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  76. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
  77. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  78. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  79. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  80. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  81. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  82. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:106)
  83. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  84. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  85. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  86. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  87. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  88. at net.n2oapp.security.auth.filter.SecurityFilter.doFilter(SecurityFilter.java:43)
  89. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  90. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  91. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  92. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  93. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  94. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  95. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  96. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
  97. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  98. at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:683)
  99. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  100. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  101. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
  102. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1760)
  103. at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1719)
  104. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  105. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  106. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  107. at java.lang.Thread.run(Thread.java:748)
  108. Caused by: org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [--select CASE WHEN :code = '32' or :code='33' THEN (SELECT :mse_examination_dt IS NOT NULL and
  109. select CASE WHEN null::CHARACTER VARYING = '32' or null::CHARACTER VARYING = '33' THEN (SELECT null::DATE IS NOT NULL and
  110. null::DATE IS NOT NULL and null::DATE IS NOT NULL and null::INTEGER IS NOT NULL
  111. ) ELSE true END]; A result was returned when none was expected.; nested exception is org.postgresql.util.PSQLException: A result was returned when none was expected.
  112. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:102)
  113. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  114. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  115. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  116. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
  117. at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:900)
  118. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:318)
  119. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.update(NamedParameterJdbcTemplate.java:299)
  120. at net.n2oapp.framework.engine.util.SqlJpqlUtil.executeQuery(SqlJpqlUtil.java:233)
  121. at net.n2oapp.framework.engine.util.SqlJpqlUtil.executeQueries(SqlJpqlUtil.java:209)
  122. ... 105 more
  123. Caused by: org.postgresql.util.PSQLException: A result was returned when none was expected.
  124. at org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:141)
  125. at org.springframework.jdbc.core.JdbcTemplate$3.doInPreparedStatement(JdbcTemplate.java:903)
  126. at org.springframework.jdbc.core.JdbcTemplate$3.doInPreparedStatement(JdbcTemplate.java:900)
  127. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
  128. ... 110 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement