API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 13th, 2022
39
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 28.54 KB | None | 0 0
raw download clone embed print report
  1. HTTP Status 500 – Internal Server Error
  2. Type Exception Report
  3.  
  4. Message Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
  5.  
  6. Description The server encountered an unexpected condition that prevented it from fulfilling the request.
  7.  
  8. Exception
  9.  
  10. org.springframework.web.util.NestedServletException: Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
  11. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
  12. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
  13. javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
  14. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  15. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  16. org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  17. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  18. org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  19. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  20. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  21. org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105)
  22. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  23. org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64)
  24. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  25. org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
  26. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  27. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  28. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  29. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  30. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  31. org.openmrs.module.spa.filter.SpaFilter.doFilter(SpaFilter.java:53)
  32. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  33. org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  34. org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:105)
  35. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  36. org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  37. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  38. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  39. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  40. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  41. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  42. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  43. Root Cause
  44.  
  45. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
  46. org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
  47. org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
  48. org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1621)
  49. org.openmrs.api.db.hibernate.HibernatePatientDAO.insertPatientStubIfNeeded(HibernatePatientDAO.java:155)
  50. org.openmrs.api.db.hibernate.HibernatePatientDAO.savePatient(HibernatePatientDAO.java:109)
  51. org.openmrs.api.impl.PatientServiceImpl.savePatient(PatientServiceImpl.java:136)
  52. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  53. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  54. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  55. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  56. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  57. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  58. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  59. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  60. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  61. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  62. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  63. com.sun.proxy.$Proxy233.savePatient(Unknown Source)
  64. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  65. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  66. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  67. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  68. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  69. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  70. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  71. org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  72. org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  73. org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  74. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  75. org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  76. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  77. org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  78. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  79. org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  80. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  81. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  82. com.sun.proxy.$Proxy234.savePatient(Unknown Source)
  83. org.openmrs.module.webservices.rest.web.v1_0.resource.openmrs1_8.PatientResource1_8.save(PatientResource1_8.java:259)
  84. org.openmrs.module.webservices.rest.web.v1_0.resource.openmrs1_8.PatientResource1_8.create(PatientResource1_8.java:224)
  85. org.openmrs.module.webservices.rest.web.v1_0.controller.MainResourceController.create(MainResourceController.java:91)
  86. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  87. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  88. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  89. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  90. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  91. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  92. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  93. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  94. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  95. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  96. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  97. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  98. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  99. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
  100. javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
  101. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  102. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  103. org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  104. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  105. org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  106. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  107. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  108. org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105)
  109. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  110. org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64)
  111. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  112. org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
  113. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  114. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  115. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  116. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  117. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  118. org.openmrs.module.spa.filter.SpaFilter.doFilter(SpaFilter.java:53)
  119. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  120. org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  121. org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:105)
  122. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  123. org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  124. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  125. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  126. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  127. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  128. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  129. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  130. Root Cause
  131.  
  132. org.hibernate.exception.SQLGrammarException: could not execute statement
  133. org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103)
  134. org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
  135. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
  136. org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
  137. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:200)
  138. org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107)
  139. org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1510)
  140. org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:295)
  141. org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1612)
  142. org.openmrs.api.db.hibernate.HibernatePatientDAO.insertPatientStubIfNeeded(HibernatePatientDAO.java:155)
  143. org.openmrs.api.db.hibernate.HibernatePatientDAO.savePatient(HibernatePatientDAO.java:109)
  144. org.openmrs.api.impl.PatientServiceImpl.savePatient(PatientServiceImpl.java:136)
  145. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  146. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  147. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  148. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  149. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  150. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  151. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  152. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  153. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  154. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  155. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  156. com.sun.proxy.$Proxy233.savePatient(Unknown Source)
  157. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  158. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  159. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  160. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  161. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  162. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  163. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  164. org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  165. org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  166. org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  167. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  168. org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  169. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  170. org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  171. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  172. org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  173. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  174. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  175. com.sun.proxy.$Proxy234.savePatient(Unknown Source)
  176. org.openmrs.module.webservices.rest.web.v1_0.resource.openmrs1_8.PatientResource1_8.save(PatientResource1_8.java:259)
  177. org.openmrs.module.webservices.rest.web.v1_0.resource.openmrs1_8.PatientResource1_8.create(PatientResource1_8.java:224)
  178. org.openmrs.module.webservices.rest.web.v1_0.controller.MainResourceController.create(MainResourceController.java:91)
  179. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  180. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  181. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  182. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  183. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  184. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  185. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  186. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  187. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  188. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  189. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  190. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  191. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  192. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
  193. javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
  194. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  195. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  196. org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  197. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  198. org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  199. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  200. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  201. org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105)
  202. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  203. org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64)
  204. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  205. org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
  206. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  207. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  208. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  209. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  210. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  211. org.openmrs.module.spa.filter.SpaFilter.doFilter(SpaFilter.java:53)
  212. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  213. org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  214. org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:105)
  215. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  216. org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  217. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  218. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  219. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  220. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  221. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  222. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  223. Root Cause
  224.  
  225. org.postgresql.util.PSQLException: ERROR: column "voided" is of type boolean but expression is of type integer
  226. Hint: You will need to rewrite or cast the expression.
  227. Position: 81
  228. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
  229. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
  230. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
  231. org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
  232. org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
  233. org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
  234. org.postgresql.jdbc.PgPreparedStatement.executeUpdate(PgPreparedStatement.java:130)
  235. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:1502)
  236. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
  237. org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107)
  238. org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1510)
  239. org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:295)
  240. org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1612)
  241. org.openmrs.api.db.hibernate.HibernatePatientDAO.insertPatientStubIfNeeded(HibernatePatientDAO.java:155)
  242. org.openmrs.api.db.hibernate.HibernatePatientDAO.savePatient(HibernatePatientDAO.java:109)
  243. org.openmrs.api.impl.PatientServiceImpl.savePatient(PatientServiceImpl.java:136)
  244. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  245. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  246. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  247. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  248. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  249. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  250. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  251. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
  252. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
  253. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  254. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  255. com.sun.proxy.$Proxy233.savePatient(Unknown Source)
  256. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  257. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  258. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  259. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  260. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
  261. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
  262. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
  263. org.springframework.cache.interceptor.CacheInterceptor.lambda$invoke$0(CacheInterceptor.java:53)
  264. org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:352)
  265. org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  266. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  267. org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:123)
  268. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  269. org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  270. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  271. org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56)
  272. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
  273. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
  274. com.sun.proxy.$Proxy234.savePatient(Unknown Source)
  275. org.openmrs.module.webservices.rest.web.v1_0.resource.openmrs1_8.PatientResource1_8.save(PatientResource1_8.java:259)
  276. org.openmrs.module.webservices.rest.web.v1_0.resource.openmrs1_8.PatientResource1_8.create(PatientResource1_8.java:224)
  277. org.openmrs.module.webservices.rest.web.v1_0.controller.MainResourceController.create(MainResourceController.java:91)
  278. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  279. java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  280. java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  281. java.base/java.lang.reflect.Method.invoke(Method.java:566)
  282. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  283. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  284. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
  285. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878)
  286. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
  287. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  288. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
  289. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
  290. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
  291. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
  292. javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
  293. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
  294. javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
  295. org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  296. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  297. org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  298. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  299. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  300. org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:105)
  301. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  302. org.openmrs.module.webservices.rest.web.filter.ContentTypeFilter.doFilter(ContentTypeFilter.java:64)
  303. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  304. org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:106)
  305. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  306. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  307. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:93)
  308. org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:61)
  309. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  310. org.openmrs.module.spa.filter.SpaFilter.doFilter(SpaFilter.java:53)
  311. org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  312. org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  313. org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:105)
  314. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  315. org.springframework.orm.hibernate5.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:156)
  316. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  317. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  318. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  319. org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:108)
  320. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
  321. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
  322. Note The full stack trace of the root cause is available in the server logs.
  323.  
  324. Apache Tomcat/7.0.109
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!