API tools faq
paste
Guest User

Untitled

a guest
Aug 1st, 2020
50
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.77 KB | None | 0 0
raw download clone embed print report
  1. UI Framework Error
  2. Root Error
  3.  
  4. org.postgresql.util.PSQLException: ERROR: column "obs1_.obs_id" must appear in the GROUP BY clause or be used in an aggregate function
  5. Position: 8
  6. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
  7. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
  8. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
  9. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
  10. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
  11. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
  12. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:103)
  13. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
  14. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  15. at org.hibernate.loader.Loader.getResultSet(Loader.java:2311)
  16. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064)
  17. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026)
  18. at org.hibernate.loader.Loader.doQuery(Loader.java:951)
  19. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
  20. at org.hibernate.loader.Loader.doList(Loader.java:2857)
  21. at org.hibernate.loader.Loader.doList(Loader.java:2839)
  22. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2671)
  23. at org.hibernate.loader.Loader.list(Loader.java:2666)
  24. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
  25. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
  26. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
  27. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412)
  28. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
  29. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
  30. at org.openmrs.module.emrapi.db.EmrVisitDAOImpl.getPrimaryDiagnoses(EmrVisitDAOImpl.java:67)
  31. at org.openmrs.module.emrapi.visit.EmrVisitServiceImpl.getDiagnoses(EmrVisitServiceImpl.java:59)
  32. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  33. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  34. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  35. at java.lang.reflect.Method.invoke(Method.java:498)
  36. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  37. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  38. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  39. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  40. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  41. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  42. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  43. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  44. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  45. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  46. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  47. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  48. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  49. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  50. at com.sun.proxy.$Proxy314.getDiagnoses(Unknown Source)
  51. at org.openmrs.module.emrapi.visit.VisitDomainWrapper.getUniqueDiagnoses(VisitDomainWrapper.java:357)
  52. at org.openmrs.module.emrapi.visit.VisitDomainWrapper$getUniqueDiagnoses.call(Unknown Source)
  53. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  54. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  55. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
  56. at SimpleTemplateScript31$_run_closure4.doCall(SimpleTemplateScript31.groovy:90)
  57. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  58. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  59. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  60. at java.lang.reflect.Method.invoke(Method.java:498)
  61. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
  62. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  63. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
  64. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1021)
  65. at groovy.lang.Closure.call(Closure.java:426)
  66. at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1946)
  67. at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1926)
  68. at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1976)
  69. at org.codehaus.groovy.runtime.dgm$174.invoke(Unknown Source)
  70. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  71. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  72. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  73. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  74. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
  75. at SimpleTemplateScript31.run(SimpleTemplateScript31.groovy:89)
  76. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  77. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  78. at org.openmrs.ui.framework.fragment.GroovyFragmentView.render(GroovyFragmentView.java:46)
  79. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:195)
  80. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  81. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:76)
  82. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:162)
  83. at org.openmrs.ui.framework.UiUtils$includeFragment$13.call(Unknown Source)
  84. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  85. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  86. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:141)
  87. at SimpleTemplateScript30$_run_closure5.doCall(SimpleTemplateScript30.groovy:94)
  88. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  89. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  90. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  91. at java.lang.reflect.Method.invoke(Method.java:498)
  92. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
  93. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  94. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
  95. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1021)
  96. at groovy.lang.Closure.call(Closure.java:426)
  97. at groovy.lang.Closure.call(Closure.java:442)
  98. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2030)
  99. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2015)
  100. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2056)
  101. at org.codehaus.groovy.runtime.dgm$162.invoke(Unknown Source)
  102. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  103. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  104. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  105. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  106. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
  107. at SimpleTemplateScript30.run(SimpleTemplateScript30.groovy:91)
  108. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  109. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  110. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  111. at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:187)
  112. at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:116)
  113. at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
  114. at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:117)
  115. at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
  116. at sun.reflect.GeneratedMethodAccessor1214.invoke(Unknown Source)
  117. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  118. at java.lang.reflect.Method.invoke(Method.java:498)
  119. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  120. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  121. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  122. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
  123. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
  124. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  125. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  126. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  127. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  128. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  129. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  130. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  131. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  132. at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1395)
  133. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
  134. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
  135. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  136. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  137. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  138. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  139. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  140. at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)
  141. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  142. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  143. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  144. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  145. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  146. at org.openmrs.module.referenceapplication.filter.RequireLoginLocationFilter.doFilter(RequireLoginLocationFilter.java:93)
  147. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  148. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  149. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  150. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  151. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  152. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  153. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  154. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  155. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  156. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  157. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  158. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  159. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  160. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  161. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  162. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  163. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  164. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596)
  165. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
  166. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  167. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
  168. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  169. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
  170. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
  171. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
  172. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
  173. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
  174. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
  175. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
  176. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
  177. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
  178. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  179. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
  180. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
  181. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  182. at org.eclipse.jetty.server.Server.handle(Server.java:500)
  183. at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
  184. at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
  185. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
  186. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
  187. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
  188. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
  189. at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
  190. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
  191. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
  192. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
  193. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
  194. at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
  195. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
  196. at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
  197. at java.lang.Thread.run(Thread.java:748)
  198.  
  199. Full Error
  200.  
  201. org.openmrs.ui.framework.ViewException: Error rendering page view for patientdashboard/patientDashboard. Model properties:
  202. sessionContext
  203. featureToggles
  204. patient
  205. selectedTab
  206. selectedVisit
  207. activeVisit
  208. encounterTemplateExtensions
  209. appContextModel
  210. overallActions
  211. includeFragments
  212. visitActions
  213. patientTabs
  214. dashboardUrl
  215. encounterCount
  216. userId
  217. ui
  218. context
  219. contextPath
  220. session
  221. param
  222. out
  223. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:55)
  224. at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:187)
  225. at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:116)
  226. at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
  227. at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:117)
  228. at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
  229. at sun.reflect.GeneratedMethodAccessor1214.invoke(Unknown Source)
  230. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  231. at java.lang.reflect.Method.invoke(Method.java:498)
  232. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  233. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  234. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  235. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
  236. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
  237. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  238. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  239. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  240. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  241. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  242. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  243. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  244. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  245. at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1395)
  246. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
  247. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
  248. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  249. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  250. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  251. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  252. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  253. at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)
  254. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  255. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  256. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  257. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  258. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  259. at org.openmrs.module.referenceapplication.filter.RequireLoginLocationFilter.doFilter(RequireLoginLocationFilter.java:93)
  260. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  261. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  262. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  263. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  264. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  265. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  266. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  267. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  268. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  269. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  270. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  271. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  272. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  273. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  274. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  275. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  276. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  277. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596)
  278. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
  279. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  280. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
  281. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  282. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
  283. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
  284. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
  285. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
  286. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
  287. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
  288. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
  289. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
  290. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
  291. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  292. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
  293. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
  294. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  295. at org.eclipse.jetty.server.Server.handle(Server.java:500)
  296. at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
  297. at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
  298. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
  299. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
  300. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
  301. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
  302. at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
  303. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
  304. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
  305. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
  306. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
  307. at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
  308. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
  309. at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
  310. at java.lang.Thread.run(Thread.java:748)
  311. Caused by: org.openmrs.ui.framework.FragmentException: Error evaluating view: patientdashboard/visits
  312. at org.openmrs.ui.framework.fragment.GroovyFragmentView.render(GroovyFragmentView.java:78)
  313. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:195)
  314. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  315. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:76)
  316. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:162)
  317. at org.openmrs.ui.framework.UiUtils$includeFragment$13.call(Unknown Source)
  318. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  319. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  320. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:141)
  321. at SimpleTemplateScript30$_run_closure5.doCall(SimpleTemplateScript30.groovy:94)
  322. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  323. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  324. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  325. at java.lang.reflect.Method.invoke(Method.java:498)
  326. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
  327. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  328. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
  329. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1021)
  330. at groovy.lang.Closure.call(Closure.java:426)
  331. at groovy.lang.Closure.call(Closure.java:442)
  332. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2030)
  333. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2015)
  334. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2056)
  335. at org.codehaus.groovy.runtime.dgm$162.invoke(Unknown Source)
  336. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  337. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  338. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  339. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  340. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
  341. at SimpleTemplateScript30.run(SimpleTemplateScript30.groovy:91)
  342. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  343. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  344. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  345. ... 87 more
  346. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  347. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
  348. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1542)
  349. at org.openmrs.module.emrapi.db.EmrVisitDAOImpl.getPrimaryDiagnoses(EmrVisitDAOImpl.java:67)
  350. at org.openmrs.module.emrapi.visit.EmrVisitServiceImpl.getDiagnoses(EmrVisitServiceImpl.java:59)
  351. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  352. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  353. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  354. at java.lang.reflect.Method.invoke(Method.java:498)
  355. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  356. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  357. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  358. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  359. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  360. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  361. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  362. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  363. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  364. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  365. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  366. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  367. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  368. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  369. at com.sun.proxy.$Proxy314.getDiagnoses(Unknown Source)
  370. at org.openmrs.module.emrapi.visit.VisitDomainWrapper.getUniqueDiagnoses(VisitDomainWrapper.java:357)
  371. at org.openmrs.module.emrapi.visit.VisitDomainWrapper$getUniqueDiagnoses.call(Unknown Source)
  372. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  373. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  374. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:133)
  375. at SimpleTemplateScript31$_run_closure4.doCall(SimpleTemplateScript31.groovy:90)
  376. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  377. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  378. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  379. at java.lang.reflect.Method.invoke(Method.java:498)
  380. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
  381. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  382. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
  383. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1021)
  384. at groovy.lang.Closure.call(Closure.java:426)
  385. at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1946)
  386. at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1926)
  387. at org.codehaus.groovy.runtime.DefaultGroovyMethods.eachWithIndex(DefaultGroovyMethods.java:1976)
  388. at org.codehaus.groovy.runtime.dgm$174.invoke(Unknown Source)
  389. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  390. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  391. at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
  392. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
  393. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
  394. at SimpleTemplateScript31.run(SimpleTemplateScript31.groovy:89)
  395. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  396. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  397. at org.openmrs.ui.framework.fragment.GroovyFragmentView.render(GroovyFragmentView.java:46)
  398. ... 119 more
  399. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  400. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
  401. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  402. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  403. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  404. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
  405. at org.hibernate.loader.Loader.getResultSet(Loader.java:2311)
  406. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064)
  407. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026)
  408. at org.hibernate.loader.Loader.doQuery(Loader.java:951)
  409. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
  410. at org.hibernate.loader.Loader.doList(Loader.java:2857)
  411. at org.hibernate.loader.Loader.doList(Loader.java:2839)
  412. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2671)
  413. at org.hibernate.loader.Loader.list(Loader.java:2666)
  414. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
  415. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
  416. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
  417. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412)
  418. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
  419. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
  420. ... 168 more
  421. Caused by: org.postgresql.util.PSQLException: ERROR: column "obs1_.obs_id" must appear in the GROUP BY clause or be used in an aggregate function
  422. Position: 8
  423. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
  424. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
  425. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
  426. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
  427. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
  428. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
  429. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:103)
  430. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
  431. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  432. ... 183 more
  433.  
  434.  
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!