API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Nov 29th, 2021
107
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 35.58 KB | None | 0 0
raw download clone embed print report
  1. java.sql.SQLSyntaxErrorException: Unknown column 'diagnosis0_.rank' in 'field list'
  2. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  3. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  4. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  5. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  6. at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
  7. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
  8. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  9. at org.hibernate.loader.Loader.getResultSet(Loader.java:2341)
  10. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2094)
  11. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2056)
  12. at org.hibernate.loader.Loader.doQuery(Loader.java:953)
  13. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:350)
  14. at org.hibernate.loader.Loader.doList(Loader.java:2887)
  15. at org.hibernate.loader.Loader.doList(Loader.java:2869)
  16. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2701)
  17. at org.hibernate.loader.Loader.list(Loader.java:2696)
  18. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
  19. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
  20. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
  21. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1415)
  22. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
  23. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
  24. at org.openmrs.api.db.hibernate.HibernateDiagnosisDAO.getActiveDiagnoses(HibernateDiagnosisDAO.java:85)
  25. at org.openmrs.api.impl.DiagnosisServiceImpl.getDiagnoses(DiagnosisServiceImpl.java:78)
  26. at org.openmrs.api.impl.DiagnosisServiceImpl.getUniqueDiagnoses(DiagnosisServiceImpl.java:106)
  27. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  28. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  29. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  30. at java.lang.reflect.Method.invoke(Method.java:498)
  31. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  32. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  33. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  34. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  35. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  36. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  37. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  38. at com.sun.proxy.$Proxy298.getUniqueDiagnoses(Unknown Source)
  39. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  40. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  41. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  42. at java.lang.reflect.Method.invoke(Method.java:498)
  43. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  44. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  45. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  46. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  47. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  48. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  49. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  50. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  51. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  52. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  53. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  54. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  55. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  56. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  57. at com.sun.proxy.$Proxy299.getUniqueDiagnoses(Unknown Source)
  58. at org.openmrs.module.emrapi.diagnosis.DiagnosisServiceImpl2_2.getUniqueDiagnoses(DiagnosisServiceImpl2_2.java:38)
  59. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  60. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  61. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  62. at java.lang.reflect.Method.invoke(Method.java:498)
  63. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  64. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  65. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  66. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  67. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  68. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  69. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  70. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  71. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  72. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  73. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  74. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  75. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  76. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  77. at com.sun.proxy.$Proxy292.getUniqueDiagnoses(Unknown Source)
  78. at org.openmrs.module.emrapi.patient.PatientDomainWrapper.getUniqueDiagnosesSince(PatientDomainWrapper.java:383)
  79. at org.openmrs.module.coreapps.fragment.controller.clinicianfacing.DiagnosisWidgetFragmentController.controller(DiagnosisWidgetFragmentController.java:47)
  80. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  81. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  82. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  83. at java.lang.reflect.Method.invoke(Method.java:498)
  84. at org.openmrs.ui.framework.UiFrameworkUtil.invokeMethodWithArguments(UiFrameworkUtil.java:116)
  85. at org.openmrs.ui.framework.UiFrameworkUtil.executeControllerMethod(UiFrameworkUtil.java:73)
  86. at org.openmrs.ui.framework.fragment.FragmentFactory.handleRequestWithController(FragmentFactory.java:242)
  87. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:160)
  88. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  89. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:77)
  90. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:170)
  91. at org.openmrs.ui.framework.UiUtils$includeFragment$15.call(Unknown Source)
  92. at SimpleTemplateScript11$_run_closure3.doCall(SimpleTemplateScript11.groovy:95)
  93. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  94. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  95. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  96. at java.lang.reflect.Method.invoke(Method.java:498)
  97. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:98)
  98. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  99. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:264)
  100. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1034)
  101. at groovy.lang.Closure.call(Closure.java:420)
  102. at groovy.lang.Closure.call(Closure.java:436)
  103. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2125)
  104. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2110)
  105. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2151)
  106. at org.codehaus.groovy.runtime.dgm$163.invoke(Unknown Source)
  107. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  108. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  109. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)
  110. at SimpleTemplateScript11.run(SimpleTemplateScript11.groovy:86)
  111. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:181)
  112. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:193)
  113. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  114. at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:188)
  115. at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:117)
  116. at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
  117. at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:120)
  118. at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
  119. at sun.reflect.GeneratedMethodAccessor988.invoke(Unknown Source)
  120. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  121. at java.lang.reflect.Method.invoke(Method.java:498)
  122. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  123. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  124. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  125. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  126. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  127. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  128. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  129. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  130. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  131. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  132. at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  133. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  134. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  135. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  136. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  140. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  141. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  142. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  143. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  144. at org.openmrs.module.web.filter.RedirectAfterLoginFilter.doFilter(RedirectAfterLoginFilter.java:64)
  145. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  146. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  147. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  148. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  149. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  150. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  151. at org.openmrs.module.spa.filter.SpaFilter.doFilter(SpaFilter.java:53)
  152. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  153. at org.openmrs.module.referenceapplication.filter.RequireLoginLocationFilter.doFilter(RequireLoginLocationFilter.java:93)
  154. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  155. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  156. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  157. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  158. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:105)
  159. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  160. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  161. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  162. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  163. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  164. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  165. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  166. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  167. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  168. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  169. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  170. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  171. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  172. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  173. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  174. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  175. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  176. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  177. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  178. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  179. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  180. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  181. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
  182. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
  183. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  184. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  185. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
  186. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1201)
  187. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
  188. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
  189. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  190. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  191. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  192. at java.lang.Thread.run(Thread.java:748)
  193. Full Error
  194. org.openmrs.ui.framework.ViewException: Error rendering page view for clinicianfacing/patient. Model properties:
  195. sessionContext
  196. featureToggles
  197. patient
  198. app
  199. activeVisit
  200. appContextModel
  201. overallActions
  202. visitActions
  203. includeFragments
  204. firstColumnFragments
  205. secondColumnFragments
  206. otherActions
  207. baseDashboardUrl
  208. dashboard
  209. breadCrumbsDetails
  210. breadCrumbsFormatters
  211. ui
  212. context
  213. contextPath
  214. session
  215. param
  216. out
  217. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:57)
  218. at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:188)
  219. at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:117)
  220. at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
  221. at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:120)
  222. at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
  223. at sun.reflect.GeneratedMethodAccessor988.invoke(Unknown Source)
  224. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  225. at java.lang.reflect.Method.invoke(Method.java:498)
  226. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  227. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  228. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  229. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  230. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  231. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  232. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  233. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  234. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  235. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  236. at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  237. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  238. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  239. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  240. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  241. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  242. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  243. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  244. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  245. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  246. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  247. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  248. at org.openmrs.module.web.filter.RedirectAfterLoginFilter.doFilter(RedirectAfterLoginFilter.java:64)
  249. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  250. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  251. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  252. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  253. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  254. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  255. at org.openmrs.module.spa.filter.SpaFilter.doFilter(SpaFilter.java:53)
  256. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  257. at org.openmrs.module.referenceapplication.filter.RequireLoginLocationFilter.doFilter(RequireLoginLocationFilter.java:93)
  258. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  259. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  260. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  261. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  262. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:105)
  263. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  264. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  265. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  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.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  269. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  270. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  271. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  272. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  273. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  274. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  275. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  276. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  277. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  278. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  279. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  280. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  281. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  282. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  283. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  284. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  285. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
  286. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
  287. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  288. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  289. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:452)
  290. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1201)
  291. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
  292. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
  293. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  294. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  295. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  296. at java.lang.Thread.run(Thread.java:748)
  297. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  298. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
  299. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1542)
  300. at org.openmrs.api.db.hibernate.HibernateDiagnosisDAO.getActiveDiagnoses(HibernateDiagnosisDAO.java:85)
  301. at org.openmrs.api.impl.DiagnosisServiceImpl.getDiagnoses(DiagnosisServiceImpl.java:78)
  302. at org.openmrs.api.impl.DiagnosisServiceImpl.getUniqueDiagnoses(DiagnosisServiceImpl.java:106)
  303. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  304. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  305. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  306. at java.lang.reflect.Method.invoke(Method.java:498)
  307. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  308. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  309. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  310. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  311. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  312. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  313. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  314. at com.sun.proxy.$Proxy298.getUniqueDiagnoses(Unknown Source)
  315. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  316. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  317. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  318. at java.lang.reflect.Method.invoke(Method.java:498)
  319. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  320. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  321. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  322. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  323. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  324. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  325. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  326. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  327. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  328. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  329. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  330. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  331. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  332. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  333. at com.sun.proxy.$Proxy299.getUniqueDiagnoses(Unknown Source)
  334. at org.openmrs.module.emrapi.diagnosis.DiagnosisServiceImpl2_2.getUniqueDiagnoses(DiagnosisServiceImpl2_2.java:38)
  335. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  336. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  337. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  338. at java.lang.reflect.Method.invoke(Method.java:498)
  339. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  340. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  341. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  342. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  343. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  344. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  345. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  346. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  347. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  348. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  349. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  350. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  351. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  352. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  353. at com.sun.proxy.$Proxy292.getUniqueDiagnoses(Unknown Source)
  354. at org.openmrs.module.emrapi.patient.PatientDomainWrapper.getUniqueDiagnosesSince(PatientDomainWrapper.java:383)
  355. at org.openmrs.module.coreapps.fragment.controller.clinicianfacing.DiagnosisWidgetFragmentController.controller(DiagnosisWidgetFragmentController.java:47)
  356. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  357. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  358. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  359. at java.lang.reflect.Method.invoke(Method.java:498)
  360. at org.openmrs.ui.framework.UiFrameworkUtil.invokeMethodWithArguments(UiFrameworkUtil.java:116)
  361. at org.openmrs.ui.framework.UiFrameworkUtil.executeControllerMethod(UiFrameworkUtil.java:73)
  362. at org.openmrs.ui.framework.fragment.FragmentFactory.handleRequestWithController(FragmentFactory.java:242)
  363. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:160)
  364. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  365. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:77)
  366. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:170)
  367. at org.openmrs.ui.framework.UiUtils$includeFragment$15.call(Unknown Source)
  368. at SimpleTemplateScript11$_run_closure3.doCall(SimpleTemplateScript11.groovy:95)
  369. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  370. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  371. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  372. at java.lang.reflect.Method.invoke(Method.java:498)
  373. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:98)
  374. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  375. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:264)
  376. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1034)
  377. at groovy.lang.Closure.call(Closure.java:420)
  378. at groovy.lang.Closure.call(Closure.java:436)
  379. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2125)
  380. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2110)
  381. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2151)
  382. at org.codehaus.groovy.runtime.dgm$163.invoke(Unknown Source)
  383. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  384. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  385. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:128)
  386. at SimpleTemplateScript11.run(SimpleTemplateScript11.groovy:86)
  387. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:181)
  388. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:193)
  389. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  390. ... 79 more
  391. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  392. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
  393. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  394. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  395. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  396. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
  397. at org.hibernate.loader.Loader.getResultSet(Loader.java:2341)
  398. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2094)
  399. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2056)
  400. at org.hibernate.loader.Loader.doQuery(Loader.java:953)
  401. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:350)
  402. at org.hibernate.loader.Loader.doList(Loader.java:2887)
  403. at org.hibernate.loader.Loader.doList(Loader.java:2869)
  404. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2701)
  405. at org.hibernate.loader.Loader.list(Loader.java:2696)
  406. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
  407. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
  408. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
  409. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1415)
  410. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
  411. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
  412. ... 169 more
  413. Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'diagnosis0_.rank' in 'field list'
  414. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
  415. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  416. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
  417. at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
  418. at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
  419. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)
  420. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  421. ... 184 more
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!