API tools faq
paste
Guest User

Untitled

a guest
Jun 19th, 2020
38
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.08 KB | None | 0 0
raw download clone embed print report
  1. ERROR - SqlExceptionHelper.logExceptions(142) |2020-06-19T14:16:26,706| ERROR: column "this_.date_started" must appear in the GROUP BY clause or be used in an aggregate function
  2. Position: 167
  3. [WARNING] /openmrs/admin/visits/datatable.list
  4. javax.servlet.ServletException: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  5. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:162)
  6. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  7. at org.eclipse.jetty.server.Server.handle(Server.java:500)
  8. at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
  9. at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
  10. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
  11. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
  12. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
  13. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
  14. at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
  15. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
  16. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
  17. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
  18. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
  19. at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
  20. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
  21. at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
  22. at java.lang.Thread.run(Thread.java:748)
  23. Caused by: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  24. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
  25. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  26. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  27. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  28. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  29. at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1395)
  30. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
  31. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
  32. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  33. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  34. at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)
  35. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  36. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  37. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  38. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  39. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  40. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  41. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  42. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  43. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  44. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  45. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  46. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  47. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  48. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  49. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  50. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  51. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  52. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  53. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596)
  54. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
  55. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  56. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
  57. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  58. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
  59. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
  60. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
  61. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
  62. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
  63. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
  64. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
  65. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
  66. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
  67. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  68. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
  69. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
  70. ... 17 more
  71. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  72. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
  73. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  74. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  75. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  76. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
  77. at org.hibernate.loader.Loader.getResultSet(Loader.java:2285)
  78. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2038)
  79. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2000)
  80. at org.hibernate.loader.Loader.doQuery(Loader.java:951)
  81. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
  82. at org.hibernate.loader.Loader.doList(Loader.java:2831)
  83. at org.hibernate.loader.Loader.doList(Loader.java:2813)
  84. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2645)
  85. at org.hibernate.loader.Loader.list(Loader.java:2640)
  86. at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)
  87. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1875)
  88. at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:370)
  89. at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:392)
  90. at org.openmrs.api.db.hibernate.HibernateEncounterDAO.getEncountersByVisitsAndPatientCount(HibernateEncounterDAO.java:592)
  91. at org.openmrs.api.impl.EncounterServiceImpl.getEncountersByVisitsAndPatientCount(EncounterServiceImpl.java:838)
  92. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  93. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  94. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  95. at java.lang.reflect.Method.invoke(Method.java:498)
  96. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  97. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  98. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  99. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366)
  100. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  101. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  102. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  103. at com.sun.proxy.$Proxy208.getEncountersByVisitsAndPatientCount(Unknown Source)
  104. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  105. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  106. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  107. at java.lang.reflect.Method.invoke(Method.java:498)
  108. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  109. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  110. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  111. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  112. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:351)
  113. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  114. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  115. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  116. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  117. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  118. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  119. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  120. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  121. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  122. at com.sun.proxy.$Proxy209.getEncountersByVisitsAndPatientCount(Unknown Source)
  123. at org.openmrs.web.controller.visit.VisitListController.getVisits(VisitListController.java:64)
  124. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  125. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  126. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  127. at java.lang.reflect.Method.invoke(Method.java:498)
  128. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  129. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  130. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  131. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
  132. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
  133. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  134. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  135. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  136. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  137. ... 62 more
  138. Caused by: org.postgresql.util.PSQLException: ERROR: column "this_.date_started" must appear in the GROUP BY clause or be used in an aggregate function
  139. Position: 167
  140. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
  141. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
  142. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
  143. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
  144. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
  145. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
  146. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:103)
  147. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
  148. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  149. ... 122 more
Add Comment
Please, Sign In to add comment
Public Pastes
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!