API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 3rd, 2020
35
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 51.46 KB | None | 0 0
raw download clone embed print report
  1. ERROR - SqlExceptionHelper.logExceptions(142) |2020-08-03T18:16:49,447| ERROR: operator does not exist: boolean = integer
  2. Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  3. Position: 904
  4. ERROR - BaseRestController.handleException(115) |2020-08-03T18:16:49,449| org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  5. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  6. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  7. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1542) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  8. at org.openmrs.module.appointmentscheduling.api.db.hibernate.HibernateTimeSlotDAO.getTimeSlotsByConstraints(HibernateTimeSlotDAO.java:63) ~[appointmentscheduling.jar:?]
  9. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_231]
  10. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_231]
  11. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_231]
  12. at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_231]
  13. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  14. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  15. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  16. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  17. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) ~[spring-tx-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  18. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  19. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  20. at com.sun.proxy.$Proxy326.getTimeSlotsByConstraints(Unknown Source) ~[?:?]
  21. at org.openmrs.module.appointmentscheduling.api.impl.AppointmentServiceImpl.getTimeSlotsByConstraintsIncludingFull(AppointmentServiceImpl.java:666) ~[appointmentscheduling.jar:?]
  22. at org.openmrs.module.appointmentscheduling.api.impl.AppointmentServiceImpl.getTimeSlotsByConstraints(AppointmentServiceImpl.java:638) ~[appointmentscheduling.jar:?]
  23. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_231]
  24. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_231]
  25. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_231]
  26. at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_231]
  27. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  28. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  29. at com.sun.proxy.$Proxy330.getTimeSlotsByConstraints(Unknown Source) ~[?:?]
  30. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_231]
  31. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_231]
  32. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_231]
  33. at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_231]
  34. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  35. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  36. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  37. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  38. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  39. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61) ~[spring-context-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  40. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  41. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123) ~[classes/:?]
  42. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  43. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  44. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  45. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  46. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  47. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) ~[spring-aop-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  48. at com.sun.proxy.$Proxy331.getTimeSlotsByConstraints(Unknown Source) ~[?:?]
  49. at org.openmrs.module.appointmentscheduling.rest.resource.openmrs1_9.TimeSlotResource1_9.doSearch(TimeSlotResource1_9.java:154) ~[appointmentscheduling.jar:?]
  50. at org.openmrs.module.webservices.rest.web.resource.impl.DelegatingCrudResource.search(DelegatingCrudResource.java:202) ~[webservices.rest-omod-common-2.29.0-SNAPSHOT.jar:?]
  51. at org.openmrs.module.webservices.rest.web.v1_0.controller.MainResourceController.get(MainResourceController.java:201) ~[webservices.rest-omod-common-2.29.0-SNAPSHOT.jar:?]
  52. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_231]
  53. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_231]
  54. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_231]
  55. at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_231]
  56. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  57. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  58. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  59. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  60. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  61. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  62. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  63. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  64. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  65. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  66. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) ~[javax.servlet-api-3.1.0.jar:3.1.0]
  67. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  68. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[javax.servlet-api-3.1.0.jar:3.1.0]
  69. at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1395) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  70. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  71. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  72. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60) ~[legacyui.jar:?]
  73. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  74. at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226) ~[websocket-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  75. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  76. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73) ~[classes/:?]
  77. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65) ~[classes/:?]
  78. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  79. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  80. at org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105) ~[webservices.rest-omod-common-2.29.0-SNAPSHOT.jar:?]
  81. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  82. at org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64) ~[webservices.rest-omod-common-2.29.0-SNAPSHOT.jar:?]
  83. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  84. at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  85. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  86. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  87. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93) ~[owa.jar:?]
  88. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61) ~[owa.jar:?]
  89. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  90. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57) ~[classes/:?]
  91. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  92. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109) ~[classes/:?]
  93. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  94. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  95. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  96. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  97. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  98. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107) ~[classes/:?]
  99. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  100. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107) ~[classes/:?]
  101. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  102. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107) ~[classes/:?]
  103. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  104. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  105. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  106. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  107. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  108. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  109. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590) ~[jetty-security-9.4.25.v20191220.jar:9.4.25.v20191220]
  110. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  111. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  112. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  113. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  114. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  115. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  116. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  117. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  118. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  119. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  120. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  121. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  122. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  123. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  124. at org.eclipse.jetty.server.Server.handle(Server.java:500) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  125. at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  126. at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547) [jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  127. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  128. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270) [jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  129. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.25.v20191220.jar:9.4.25.v20191220]
  130. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.25.v20191220.jar:9.4.25.v20191220]
  131. at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.25.v20191220.jar:9.4.25.v20191220]
  132. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  133. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  134. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  135. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  136. at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  137. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  138. at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  139. at java.lang.Thread.run(Thread.java:748) [?:1.8.0_231]
  140. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  141. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  142. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  143. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  144. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  145. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  146. at org.hibernate.loader.Loader.getResultSet(Loader.java:2311) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  147. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  148. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  149. at org.hibernate.loader.Loader.doQuery(Loader.java:951) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  150. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  151. at org.hibernate.loader.Loader.doList(Loader.java:2857) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  152. at org.hibernate.loader.Loader.doList(Loader.java:2839) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  153. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2671) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  154. at org.hibernate.loader.Loader.list(Loader.java:2666) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  155. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  156. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  157. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  158. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  159. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  160. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  161. ... 132 more
  162. Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
  163. Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  164. Position: 904
  165. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) ~[postgresql-42.2.14.jar:42.2.14]
  166. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267) ~[postgresql-42.2.14.jar:42.2.14]
  167. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) ~[postgresql-42.2.14.jar:42.2.14]
  168. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) ~[postgresql-42.2.14.jar:42.2.14]
  169. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) ~[postgresql-42.2.14.jar:42.2.14]
  170. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153) ~[postgresql-42.2.14.jar:42.2.14]
  171. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:103) ~[postgresql-42.2.14.jar:42.2.14]
  172. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379) ~[c3p0-0.9.5.3.jar:0.9.5.3]
  173. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  174. at org.hibernate.loader.Loader.getResultSet(Loader.java:2311) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  175. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  176. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  177. at org.hibernate.loader.Loader.doQuery(Loader.java:951) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  178. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  179. at org.hibernate.loader.Loader.doList(Loader.java:2857) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  180. at org.hibernate.loader.Loader.doList(Loader.java:2839) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  181. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2671) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  182. at org.hibernate.loader.Loader.list(Loader.java:2666) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  183. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  184. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  185. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  186. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  187. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  188. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533) ~[hibernate-core-5.4.18.Final.jar:5.4.18.Final]
  189. ... 132 more
  190. WARN - ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(414) |2020-08-03T18:16:49,467| Failure in @ExceptionHandler org.openmrs.module.appointmentscheduling.rest.controller.AppointmentRestController#handleException(Exception, HttpServletRequest, HttpServletResponse)
  191. org.springframework.http.converter.HttpMessageNotWritableException: No converter found for return value of type: class org.openmrs.module.webservices.rest.SimpleObject
  192. at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:230) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  193. at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.handleReturnValue(RequestResponseBodyMethodProcessor.java:181) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  194. at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:82) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  195. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:123) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  196. at org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(ExceptionHandlerExceptionResolver.java:403) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  197. at org.springframework.web.servlet.handler.AbstractHandlerMethodExceptionResolver.doResolveException(AbstractHandlerMethodExceptionResolver.java:61) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  198. at org.springframework.web.servlet.handler.AbstractHandlerExceptionResolver.resolveException(AbstractHandlerExceptionResolver.java:141) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  199. at org.springframework.web.servlet.DispatcherServlet.processHandlerException(DispatcherServlet.java:1300) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  200. at org.springframework.web.servlet.DispatcherServlet.processDispatchResult(DispatcherServlet.java:1111) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  201. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1057) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  202. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  203. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  204. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  205. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) ~[javax.servlet-api-3.1.0.jar:3.1.0]
  206. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  207. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) ~[javax.servlet-api-3.1.0.jar:3.1.0]
  208. at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1395) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  209. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  210. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  211. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60) ~[legacyui.jar:?]
  212. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  213. at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226) ~[websocket-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  214. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  215. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73) ~[classes/:?]
  216. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65) ~[classes/:?]
  217. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  218. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  219. at org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105) ~[webservices.rest-omod-common-2.29.0-SNAPSHOT.jar:?]
  220. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  221. at org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64) ~[webservices.rest-omod-common-2.29.0-SNAPSHOT.jar:?]
  222. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  223. at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  224. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  225. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  226. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93) ~[owa.jar:?]
  227. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61) ~[owa.jar:?]
  228. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71) ~[classes/:?]
  229. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57) ~[classes/:?]
  230. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  231. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109) ~[classes/:?]
  232. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  233. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  234. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156) ~[spring-orm-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  235. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  236. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  237. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107) ~[classes/:?]
  238. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  239. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107) ~[classes/:?]
  240. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  241. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107) ~[classes/:?]
  242. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  243. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  244. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.7.RELEASE.jar:5.2.7.RELEASE]
  245. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  246. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  247. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  248. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590) ~[jetty-security-9.4.25.v20191220.jar:9.4.25.v20191220]
  249. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  250. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  251. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  252. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  253. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  254. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  255. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485) ~[jetty-servlet-9.4.25.v20191220.jar:9.4.25.v20191220]
  256. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  257. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  258. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  259. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  260. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  261. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  262. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  263. at org.eclipse.jetty.server.Server.handle(Server.java:500) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  264. at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  265. at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547) [jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  266. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  267. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270) [jetty-server-9.4.25.v20191220.jar:9.4.25.v20191220]
  268. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.25.v20191220.jar:9.4.25.v20191220]
  269. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.25.v20191220.jar:9.4.25.v20191220]
  270. at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.25.v20191220.jar:9.4.25.v20191220]
  271. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  272. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  273. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  274. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  275. at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  276. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  277. at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938) [jetty-util-9.4.25.v20191220.jar:9.4.25.v20191220]
  278. at java.lang.Thread.run(Thread.java:748) [?:1.8.0_231]
  279. [WARNING] /openmrs/ws/rest/v1/appointmentscheduling/timeslot
  280. javax.servlet.ServletException: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  281. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:162)
  282. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  283. at org.eclipse.jetty.server.Server.handle(Server.java:500)
  284. at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
  285. at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
  286. at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
  287. at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
  288. at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
  289. at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
  290. at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
  291. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
  292. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
  293. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
  294. at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
  295. at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
  296. at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
  297. at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
  298. at java.lang.Thread.run(Thread.java:748)
  299. Caused by: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  300. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
  301. at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
  302. at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
  303. at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  304. at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
  305. at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1395)
  306. at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
  307. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
  308. at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  309. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  310. at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)
  311. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  312. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  313. at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  314. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  315. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  316. at org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105)
  317. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  318. at org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64)
  319. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  320. at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
  321. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  322. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  323. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  324. at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  325. at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  326. at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  327. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  328. at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  329. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  330. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  331. at org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  332. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  333. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  334. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  335. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  336. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  337. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  338. at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  339. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
  340. at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  341. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  342. at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1596)
  343. at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
  344. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
  345. at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
  346. at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
  347. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
  348. at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
  349. at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
  350. at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
  351. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
  352. at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
  353. at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
  354. at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
  355. at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
  356. at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
  357. at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:221)
  358. at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
  359. ... 17 more
  360. Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  361. at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
  362. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1542)
  363. at org.openmrs.module.appointmentscheduling.api.db.hibernate.HibernateTimeSlotDAO.getTimeSlotsByConstraints(HibernateTimeSlotDAO.java:63)
  364. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  365. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  366. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  367. at java.lang.reflect.Method.invoke(Method.java:498)
  368. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  369. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  370. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  371. at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  372. at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  373. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  374. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  375. at com.sun.proxy.$Proxy326.getTimeSlotsByConstraints(Unknown Source)
  376. at org.openmrs.module.appointmentscheduling.api.impl.AppointmentServiceImpl.getTimeSlotsByConstraintsIncludingFull(AppointmentServiceImpl.java:666)
  377. at org.openmrs.module.appointmentscheduling.api.impl.AppointmentServiceImpl.getTimeSlotsByConstraints(AppointmentServiceImpl.java:638)
  378. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  379. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  380. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  381. at java.lang.reflect.Method.invoke(Method.java:498)
  382. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  383. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:205)
  384. at com.sun.proxy.$Proxy330.getTimeSlotsByConstraints(Unknown Source)
  385. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  386. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  387. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  388. at java.lang.reflect.Method.invoke(Method.java:498)
  389. at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  390. at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  391. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  392. at org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  393. at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  394. at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  395. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  396. at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  397. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  398. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  399. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  400. at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  401. at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  402. at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  403. at com.sun.proxy.$Proxy331.getTimeSlotsByConstraints(Unknown Source)
  404. at org.openmrs.module.appointmentscheduling.rest.resource.openmrs1_9.TimeSlotResource1_9.doSearch(TimeSlotResource1_9.java:154)
  405. at org.openmrs.module.webservices.rest.web.resource.impl.DelegatingCrudResource.search(DelegatingCrudResource.java:202)
  406. at org.openmrs.module.webservices.rest.web.v1_0.controller.MainResourceController.get(MainResourceController.java:201)
  407. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  408. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  409. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  410. at java.lang.reflect.Method.invoke(Method.java:498)
  411. at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  412. at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  413. at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  414. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
  415. at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
  416. at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  417. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  418. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  419. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  420. ... 75 more
  421. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  422. at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
  423. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  424. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  425. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  426. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
  427. at org.hibernate.loader.Loader.getResultSet(Loader.java:2311)
  428. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2064)
  429. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2026)
  430. at org.hibernate.loader.Loader.doQuery(Loader.java:951)
  431. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:352)
  432. at org.hibernate.loader.Loader.doList(Loader.java:2857)
  433. at org.hibernate.loader.Loader.doList(Loader.java:2839)
  434. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2671)
  435. at org.hibernate.loader.Loader.list(Loader.java:2666)
  436. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:506)
  437. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:400)
  438. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
  439. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1412)
  440. at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1565)
  441. at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1533)
  442. ... 132 more
  443. Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer
  444. Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  445. Position: 904
  446. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532)
  447. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267)
  448. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312)
  449. at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448)
  450. at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369)
  451. at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153)
  452. at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:103)
  453. at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:379)
  454. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
  455. ... 147 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!