API tools faq
paste
Guest User

Untitled

a guest
Mar 15th, 2023
25
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 48.74 KB | None | 0 0
raw download clone embed print report
  1. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  2. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
  3. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  4. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  5. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  6. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
  7. at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
  8. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
  9. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
  10. at org.hibernate.loader.Loader.doQuery(Loader.java:910)
  11. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
  12. at org.hibernate.loader.Loader.doList(Loader.java:2554)
  13. at org.hibernate.loader.Loader.doList(Loader.java:2540)
  14. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
  15. at org.hibernate.loader.Loader.list(Loader.java:2365)
  16. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
  17. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
  18. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
  19. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
  20. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
  21. at org.openmrs.api.db.hibernate.HibernateDiagnosisDAO.getActiveDiagnoses(HibernateDiagnosisDAO.java:85)
  22. at org.openmrs.api.impl.DiagnosisServiceImpl.getDiagnoses(DiagnosisServiceImpl.java:78)
  23. at org.openmrs.api.impl.DiagnosisServiceImpl.getUniqueDiagnoses(DiagnosisServiceImpl.java:106)
  24. at sun.reflect.GeneratedMethodAccessor1101.invoke(Unknown Source)
  25. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  26. at java.lang.reflect.Method.invoke(Method.java:498)
  27. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  28. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  29. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  30. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  31. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  32. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  33. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  34. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  35. at com.sun.proxy.$Proxy706.getUniqueDiagnoses(Unknown Source)
  36. at sun.reflect.GeneratedMethodAccessor1101.invoke(Unknown Source)
  37. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  38. at java.lang.reflect.Method.invoke(Method.java:498)
  39. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  40. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  41. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  42. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  43. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  44. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  45. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  46. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  47. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  48. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  49. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  50. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  51. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  52. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  53. at com.sun.proxy.$Proxy707.getUniqueDiagnoses(Unknown Source)
  54. at org.openmrs.module.emrapi.diagnosis.DiagnosisServiceImpl2_2.getUniqueDiagnoses(DiagnosisServiceImpl2_2.java:58)
  55. at sun.reflect.GeneratedMethodAccessor1267.invoke(Unknown Source)
  56. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  57. at java.lang.reflect.Method.invoke(Method.java:498)
  58. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  59. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  60. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  61. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  62. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  63. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  64. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  65. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  66. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  67. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  68. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  69. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  70. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  71. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  72. at com.sun.proxy.$Proxy738.getUniqueDiagnoses(Unknown Source)
  73. at org.openmrs.module.emrapi.patient.PatientDomainWrapper.getUniqueDiagnosesSince(PatientDomainWrapper.java:383)
  74. at org.openmrs.module.coreapps.fragment.controller.clinicianfacing.DiagnosisWidgetFragmentController.controller(DiagnosisWidgetFragmentController.java:47)
  75. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  76. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  77. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  78. at java.lang.reflect.Method.invoke(Method.java:498)
  79. at org.openmrs.ui.framework.UiFrameworkUtil.invokeMethodWithArguments(UiFrameworkUtil.java:112)
  80. at org.openmrs.ui.framework.UiFrameworkUtil.executeControllerMethod(UiFrameworkUtil.java:71)
  81. at org.openmrs.ui.framework.fragment.FragmentFactory.handleRequestWithController(FragmentFactory.java:241)
  82. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:160)
  83. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  84. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:76)
  85. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:158)
  86. at org.openmrs.ui.framework.UiUtils$includeFragment$13.call(Unknown Source)
  87. at SimpleTemplateScript52$_run_closure3.doCall(SimpleTemplateScript52.groovy:96)
  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.AbstractCallSite.call(AbstractCallSite.java:125)
  105. at SimpleTemplateScript52.run(SimpleTemplateScript52.groovy:87)
  106. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  107. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  108. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  109. ... 70 more
  110. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'diagnosis0_.rank' in 'field list'
  111. at sun.reflect.GeneratedConstructorAccessor372.newInstance(Unknown Source)
  112. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  113. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  114. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  115. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  116. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  117. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  118. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  119. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  120. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  121. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  122. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  123. at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
  124. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
  125. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
  126. ... 172 more
  127. INFO - LoggingAdvice.invoke(116) |2023-03-15 09:27:10,159| In method UserService.saveUser. Arguments: User=admin,
  128. INFO - LoggingAdvice.invoke(156) |2023-03-15 09:27:10,160| Exiting method saveUser
  129. ERROR - SqlExceptionHelper.logExceptions(146) |2023-03-15 09:27:10,257| Unknown column 'diagnosis0_.rank' in 'field list'
  130. ERROR - PageController.handlePath(156) |2023-03-15 09:27:10,258| Error rendering page view for clinicianfacing/patient. Model properties:
  131. sessionContext
  132. featureToggles
  133. patient
  134. app
  135. activeVisit
  136. appContextModel
  137. overallActions
  138. visitActions
  139. includeFragments
  140. firstColumnFragments
  141. secondColumnFragments
  142. otherActions
  143. baseDashboardUrl
  144. dashboard
  145. breadCrumbsDetails
  146. breadCrumbsFormatters
  147. ui
  148. context
  149. contextPath
  150. session
  151. param
  152. out
  153. org.openmrs.ui.framework.ViewException: Error rendering page view for clinicianfacing/patient. Model properties:
  154. sessionContext
  155. featureToggles
  156. patient
  157. app
  158. activeVisit
  159. appContextModel
  160. overallActions
  161. visitActions
  162. includeFragments
  163. firstColumnFragments
  164. secondColumnFragments
  165. otherActions
  166. baseDashboardUrl
  167. dashboard
  168. breadCrumbsDetails
  169. breadCrumbsFormatters
  170. ui
  171. context
  172. contextPath
  173. session
  174. param
  175. out
  176. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:55)
  177. at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:187)
  178. at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:116)
  179. at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
  180. at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:117)
  181. at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
  182. at sun.reflect.GeneratedMethodAccessor730.invoke(Unknown Source)
  183. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  184. at java.lang.reflect.Method.invoke(Method.java:498)
  185. at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:177)
  186. at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:446)
  187. at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:434)
  188. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  189. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  190. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  191. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
  192. at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  193. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  194. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  195. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  196. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  197. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  198. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  199. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  200. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  201. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  202. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  203. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  204. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  205. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:57)
  206. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  207. at org.openmrs.module.referenceapplication.filter.RequireLoginLocationFilter.doFilter(RequireLoginLocationFilter.java:93)
  208. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  209. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  210. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  211. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  212. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  213. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  214. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  215. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  216. at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
  217. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  218. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  219. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  220. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  221. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  222. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  223. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  224. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  225. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  226. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  227. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  228. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  229. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  230. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  231. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  232. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  233. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  234. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  235. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
  236. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
  237. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  238. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  239. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:451)
  240. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1201)
  241. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
  242. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
  243. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  244. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  245. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  246. at java.lang.Thread.run(Thread.java:750)
  247. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  248. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
  249. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  250. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  251. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  252. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
  253. at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
  254. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
  255. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
  256. at org.hibernate.loader.Loader.doQuery(Loader.java:910)
  257. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
  258. at org.hibernate.loader.Loader.doList(Loader.java:2554)
  259. at org.hibernate.loader.Loader.doList(Loader.java:2540)
  260. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
  261. at org.hibernate.loader.Loader.list(Loader.java:2365)
  262. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
  263. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
  264. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
  265. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
  266. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
  267. at org.openmrs.api.db.hibernate.HibernateDiagnosisDAO.getActiveDiagnoses(HibernateDiagnosisDAO.java:85)
  268. at org.openmrs.api.impl.DiagnosisServiceImpl.getDiagnoses(DiagnosisServiceImpl.java:78)
  269. at org.openmrs.api.impl.DiagnosisServiceImpl.getUniqueDiagnoses(DiagnosisServiceImpl.java:106)
  270. at sun.reflect.GeneratedMethodAccessor1101.invoke(Unknown Source)
  271. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  272. at java.lang.reflect.Method.invoke(Method.java:498)
  273. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  274. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  275. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  276. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  277. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  278. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  279. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  280. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  281. at com.sun.proxy.$Proxy706.getUniqueDiagnoses(Unknown Source)
  282. at sun.reflect.GeneratedMethodAccessor1101.invoke(Unknown Source)
  283. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  284. at java.lang.reflect.Method.invoke(Method.java:498)
  285. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  286. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  287. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  288. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  289. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  290. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  291. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  292. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  293. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  294. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  295. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  296. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  297. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  298. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  299. at com.sun.proxy.$Proxy707.getUniqueDiagnoses(Unknown Source)
  300. at org.openmrs.module.emrapi.diagnosis.DiagnosisServiceImpl2_2.getUniqueDiagnoses(DiagnosisServiceImpl2_2.java:58)
  301. at sun.reflect.GeneratedMethodAccessor1267.invoke(Unknown Source)
  302. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  303. at java.lang.reflect.Method.invoke(Method.java:498)
  304. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  305. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  306. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  307. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  308. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  309. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  310. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  311. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  312. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  313. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  314. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  315. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  316. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  317. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  318. at com.sun.proxy.$Proxy738.getUniqueDiagnoses(Unknown Source)
  319. at org.openmrs.module.emrapi.patient.PatientDomainWrapper.getUniqueDiagnosesSince(PatientDomainWrapper.java:383)
  320. at org.openmrs.module.coreapps.fragment.controller.clinicianfacing.DiagnosisWidgetFragmentController.controller(DiagnosisWidgetFragmentController.java:47)
  321. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  322. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  323. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  324. at java.lang.reflect.Method.invoke(Method.java:498)
  325. at org.openmrs.ui.framework.UiFrameworkUtil.invokeMethodWithArguments(UiFrameworkUtil.java:112)
  326. at org.openmrs.ui.framework.UiFrameworkUtil.executeControllerMethod(UiFrameworkUtil.java:71)
  327. at org.openmrs.ui.framework.fragment.FragmentFactory.handleRequestWithController(FragmentFactory.java:241)
  328. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:160)
  329. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  330. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:76)
  331. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:158)
  332. at org.openmrs.ui.framework.UiUtils$includeFragment$13.call(Unknown Source)
  333. at SimpleTemplateScript52$_run_closure3.doCall(SimpleTemplateScript52.groovy:96)
  334. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  335. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  336. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  337. at java.lang.reflect.Method.invoke(Method.java:498)
  338. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
  339. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  340. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
  341. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1021)
  342. at groovy.lang.Closure.call(Closure.java:426)
  343. at groovy.lang.Closure.call(Closure.java:442)
  344. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2030)
  345. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2015)
  346. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2056)
  347. at org.codehaus.groovy.runtime.dgm$162.invoke(Unknown Source)
  348. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  349. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  350. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
  351. at SimpleTemplateScript52.run(SimpleTemplateScript52.groovy:87)
  352. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  353. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  354. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  355. ... 70 more
  356. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'diagnosis0_.rank' in 'field list'
  357. at sun.reflect.GeneratedConstructorAccessor372.newInstance(Unknown Source)
  358. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  359. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  360. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  361. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  362. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  363. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  364. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  365. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  366. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  367. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  368. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  369. at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
  370. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
  371. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
  372. ... 172 more
  373. INFO - LoggingAdvice.invoke(116) |2023-03-15 09:30:30,985| In method UserService.saveUser. Arguments: User=admin,
  374. INFO - LoggingAdvice.invoke(156) |2023-03-15 09:30:30,987| Exiting method saveUser
  375. ERROR - SqlExceptionHelper.logExceptions(146) |2023-03-15 09:30:31,090| Unknown column 'diagnosis0_.rank' in 'field list'
  376. ERROR - PageController.handlePath(156) |2023-03-15 09:30:31,091| Error rendering page view for clinicianfacing/patient. Model properties:
  377. sessionContext
  378. featureToggles
  379. patient
  380. app
  381. activeVisit
  382. appContextModel
  383. overallActions
  384. visitActions
  385. includeFragments
  386. firstColumnFragments
  387. secondColumnFragments
  388. otherActions
  389. baseDashboardUrl
  390. dashboard
  391. breadCrumbsDetails
  392. breadCrumbsFormatters
  393. ui
  394. context
  395. contextPath
  396. session
  397. param
  398. out
  399. org.openmrs.ui.framework.ViewException: Error rendering page view for clinicianfacing/patient. Model properties:
  400. sessionContext
  401. featureToggles
  402. patient
  403. app
  404. activeVisit
  405. appContextModel
  406. overallActions
  407. visitActions
  408. includeFragments
  409. firstColumnFragments
  410. secondColumnFragments
  411. otherActions
  412. baseDashboardUrl
  413. dashboard
  414. breadCrumbsDetails
  415. breadCrumbsFormatters
  416. ui
  417. context
  418. contextPath
  419. session
  420. param
  421. out
  422. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:55)
  423. at org.openmrs.ui.framework.page.PageFactory.processThisFragment(PageFactory.java:187)
  424. at org.openmrs.ui.framework.page.PageFactory.process(PageFactory.java:116)
  425. at org.openmrs.ui.framework.page.PageFactory.handle(PageFactory.java:86)
  426. at org.openmrs.module.uiframework.PageController.handlePath(PageController.java:117)
  427. at org.openmrs.module.uiframework.PageController.handleUrlWithDotPage(PageController.java:84)
  428. at sun.reflect.GeneratedMethodAccessor730.invoke(Unknown Source)
  429. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  430. at java.lang.reflect.Method.invoke(Method.java:498)
  431. at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:177)
  432. at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:446)
  433. at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:434)
  434. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  435. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  436. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  437. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
  438. at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
  439. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  440. at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  441. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  442. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  443. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  444. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  445. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  446. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  447. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  448. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  449. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  450. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  451. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:57)
  452. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  453. at org.openmrs.module.referenceapplication.filter.RequireLoginLocationFilter.doFilter(RequireLoginLocationFilter.java:93)
  454. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  455. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  456. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  457. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  458. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  459. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  460. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  461. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  462. at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
  463. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  464. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  465. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  466. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  467. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  468. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  469. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  470. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  471. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  472. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  473. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  474. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  475. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  476. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  477. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  478. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  479. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
  480. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  481. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492)
  482. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:165)
  483. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
  484. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  485. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:451)
  486. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1201)
  487. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:654)
  488. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
  489. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  490. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  491. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  492. at java.lang.Thread.run(Thread.java:750)
  493. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  494. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
  495. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  496. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  497. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  498. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
  499. at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
  500. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
  501. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
  502. at org.hibernate.loader.Loader.doQuery(Loader.java:910)
  503. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
  504. at org.hibernate.loader.Loader.doList(Loader.java:2554)
  505. at org.hibernate.loader.Loader.doList(Loader.java:2540)
  506. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
  507. at org.hibernate.loader.Loader.list(Loader.java:2365)
  508. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
  509. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
  510. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
  511. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
  512. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
  513. at org.openmrs.api.db.hibernate.HibernateDiagnosisDAO.getActiveDiagnoses(HibernateDiagnosisDAO.java:85)
  514. at org.openmrs.api.impl.DiagnosisServiceImpl.getDiagnoses(DiagnosisServiceImpl.java:78)
  515. at org.openmrs.api.impl.DiagnosisServiceImpl.getUniqueDiagnoses(DiagnosisServiceImpl.java:106)
  516. at sun.reflect.GeneratedMethodAccessor1101.invoke(Unknown Source)
  517. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  518. at java.lang.reflect.Method.invoke(Method.java:498)
  519. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  520. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  521. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  522. at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  523. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  524. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  525. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  526. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  527. at com.sun.proxy.$Proxy706.getUniqueDiagnoses(Unknown Source)
  528. at sun.reflect.GeneratedMethodAccessor1101.invoke(Unknown Source)
  529. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  530. at java.lang.reflect.Method.invoke(Method.java:498)
  531. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  532. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  533. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  534. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  535. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  536. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  537. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  538. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  539. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  540. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  541. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  542. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  543. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  544. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  545. at com.sun.proxy.$Proxy707.getUniqueDiagnoses(Unknown Source)
  546. at org.openmrs.module.emrapi.diagnosis.DiagnosisServiceImpl2_2.getUniqueDiagnoses(DiagnosisServiceImpl2_2.java:58)
  547. at sun.reflect.GeneratedMethodAccessor1267.invoke(Unknown Source)
  548. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  549. at java.lang.reflect.Method.invoke(Method.java:498)
  550. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  551. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  552. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  553. at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  554. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  555. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  556. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  557. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  558. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  559. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  560. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  561. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  562. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  563. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  564. at com.sun.proxy.$Proxy738.getUniqueDiagnoses(Unknown Source)
  565. at org.openmrs.module.emrapi.patient.PatientDomainWrapper.getUniqueDiagnosesSince(PatientDomainWrapper.java:383)
  566. at org.openmrs.module.coreapps.fragment.controller.clinicianfacing.DiagnosisWidgetFragmentController.controller(DiagnosisWidgetFragmentController.java:47)
  567. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  568. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  569. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  570. at java.lang.reflect.Method.invoke(Method.java:498)
  571. at org.openmrs.ui.framework.UiFrameworkUtil.invokeMethodWithArguments(UiFrameworkUtil.java:112)
  572. at org.openmrs.ui.framework.UiFrameworkUtil.executeControllerMethod(UiFrameworkUtil.java:71)
  573. at org.openmrs.ui.framework.fragment.FragmentFactory.handleRequestWithController(FragmentFactory.java:241)
  574. at org.openmrs.ui.framework.fragment.FragmentFactory.processThisFragment(FragmentFactory.java:160)
  575. at org.openmrs.ui.framework.fragment.FragmentFactory.process(FragmentFactory.java:124)
  576. at org.openmrs.ui.framework.page.PageContext.includeFragment(PageContext.java:76)
  577. at org.openmrs.ui.framework.UiUtils.includeFragment(UiUtils.java:158)
  578. at org.openmrs.ui.framework.UiUtils$includeFragment$13.call(Unknown Source)
  579. at SimpleTemplateScript52$_run_closure3.doCall(SimpleTemplateScript52.groovy:96)
  580. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  581. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  582. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  583. at java.lang.reflect.Method.invoke(Method.java:498)
  584. at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:93)
  585. at groovy.lang.MetaMethod.doMethodInvoke(MetaMethod.java:325)
  586. at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:294)
  587. at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:1021)
  588. at groovy.lang.Closure.call(Closure.java:426)
  589. at groovy.lang.Closure.call(Closure.java:442)
  590. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2030)
  591. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2015)
  592. at org.codehaus.groovy.runtime.DefaultGroovyMethods.each(DefaultGroovyMethods.java:2056)
  593. at org.codehaus.groovy.runtime.dgm$162.invoke(Unknown Source)
  594. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoMetaMethodSiteNoUnwrapNoCoerce.invoke(PojoMetaMethodSite.java:274)
  595. at org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:56)
  596. at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
  597. at SimpleTemplateScript52.run(SimpleTemplateScript52.groovy:87)
  598. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.writeTo(SimpleTemplateEngine.java:168)
  599. at groovy.text.SimpleTemplateEngine$SimpleTemplate$1.toString(SimpleTemplateEngine.java:180)
  600. at org.openmrs.ui.framework.page.GroovyPageView.render(GroovyPageView.java:43)
  601. ... 70 more
  602. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'diagnosis0_.rank' in 'field list'
  603. at sun.reflect.GeneratedConstructorAccessor372.newInstance(Unknown Source)
  604. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  605. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  606. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  607. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  608. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  609. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  610. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  611. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  612. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  613. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  614. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  615. at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
  616. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
  617. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
  618. ... 172 more
  619. INFO - LoggingAdvice.invoke(116) |2023-03-15 09:45:29,757| In method ReportService.deleteOldReportRequests. Arguments:
  620. INFO - LoggingAdvice.invoke(156) |2023-03-15 09:45:29,763| Exiting method deleteOldReportRequests
  621. INFO - LoggingAdvice.invoke(116) |2023-03-15 10:45:29,758| In method ReportService.deleteOldReportRequests. Arguments:
  622. INFO - LoggingAdvice.invoke(156) |2023-03-15 10:45:29,763| Exiting method deleteOldReportRequests
  623. INFO - LoggingAdvice.invoke(116) |2023-03-15 11:45:29,758| In method ReportService.deleteOldReportRequests. Arguments:
  624. INFO - LoggingAdvice.invoke(156) |2023-03-15 11:45:29,764| Exiting method deleteOldReportRequests
  625. INFO - LoggingAdvice.invoke(116) |2023-03-15 12:45:29,759| In method ReportService.deleteOldReportRequests. Arguments:
  626. INFO - LoggingAdvice.invoke(156) |2023-03-15 12:45:29,765| Exiting method deleteOldReportRequests
  627. INFO - LoggingAdvice.invoke(116) |2023-03-15 13:45:29,759| In method ReportService.deleteOldReportRequests. Arguments:
  628. INFO - LoggingAdvice.invoke(156) |2023-03-15 13:45:29,765| Exiting method deleteOldReportRequests
  629. INFO - LoggingAdvice.invoke(116) |2023-03-15 14:45:29,760| In method ReportService.deleteOldReportRequests. Arguments:
  630. INFO - LoggingAdvice.invoke(156) |2023-03-15 14:45:29,765| Exiting method deleteOldReportRequests
  631. INFO - LoggingAdvice.invoke(116) |2023-03-15 15:45:29,760| In method ReportService.deleteOldReportRequests. Arguments:
  632. INFO - LoggingAdvice.invoke(156) |2023-03-15 15:45:29,766| Exiting method deleteOldReportRequests
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!