API tools faq
paste
Advertisement
Guest User

openmrs 1.10.2 savePatient error

a guest
May 23rd, 2015
259
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 17.18 KB | None | 0 0
raw download clone embed print report
  1. ERROR - JDBCExceptionReporter.logExceptions(234) |2015-05-23 09:03:29,979| Column 'value' cannot be null
  2. ERROR - LoggingAdvice.invoke(131) |2015-05-23 09:03:29,981| An error occurred while executing this method.
  3. Current user: admin
  4. Error message: Could not execute JDBC batch update
  5. org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  6.         at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
  7.         at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  8.         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
  9.         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
  10.         at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
  11.         at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:244)
  12.         at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2541)
  13.         at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2494)
  14.         at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2821)
  15.         at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113)
  16.         at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
  17.         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
  18.         at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185)
  19.         at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
  20.         at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
  21.         at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
  22.         at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
  23.         at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
  24.         at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
  25.         at org.openmrs.api.db.hibernate.HibernatePatientDAO.isIdentifierInUseByAnotherPatient(HibernatePatientDAO.java:540)
  26.         at org.openmrs.api.impl.PatientServiceImpl.isIdentifierInUseByAnotherPatient(PatientServiceImpl.java:1383)
  27.         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
  28.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  29.         at java.lang.reflect.Method.invoke(Method.java:597)
  30.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  31.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  32.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  33.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  34.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  35.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  36.         at $Proxy551.isIdentifierInUseByAnotherPatient(Unknown Source)
  37.         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
  38.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  39.         at java.lang.reflect.Method.invoke(Method.java:597)
  40.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  41.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  42.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  43.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  44.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  45.         at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:118)
  46.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  47.         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
  48.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  49.         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
  50.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  51.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  52.         at $Proxy552.isIdentifierInUseByAnotherPatient(Unknown Source)
  53.         at sun.reflect.GeneratedMethodAccessor1383.invoke(Unknown Source)
  54.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  55.         at java.lang.reflect.Method.invoke(Method.java:597)
  56.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  57.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  58.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  59.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  60.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  61.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  62.         at $Proxy552.isIdentifierInUseByAnotherPatient(Unknown Source)
  63.         at org.openmrs.validator.PatientIdentifierValidator.validateIdentifier(PatientIdentifierValidator.java:92)
  64.         at org.openmrs.api.impl.PatientServiceImpl.checkPatientIdentifier(PatientServiceImpl.java:285)
  65.         at org.openmrs.api.impl.PatientServiceImpl.checkPatientIdentifiers(PatientServiceImpl.java:237)
  66.         at org.openmrs.api.impl.PatientServiceImpl.savePatient(PatientServiceImpl.java:135)
  67.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  68.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  69.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  70.         at java.lang.reflect.Method.invoke(Method.java:597)
  71.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  72.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  73.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  74.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  75.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  76.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  77.         at $Proxy551.savePatient(Unknown Source)
  78.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  79.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  80.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  81.         at java.lang.reflect.Method.invoke(Method.java:597)
  82.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  83.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  84.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  85.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  86.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  87.         at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:118)
  88.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  89.         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
  90.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  91.         at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:50)
  92.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  93.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  94.         at $Proxy552.savePatient(Unknown Source)
  95.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  96.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  97.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  98.         at java.lang.reflect.Method.invoke(Method.java:597)
  99.         at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
  100.         at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
  101.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
  102.         at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
  103.         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
  104.         at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
  105.         at $Proxy552.savePatient(Unknown Source)
  106.         at org.openmrs.web.controller.patient.ShortPatientFormController.saveShortPatient(ShortPatientFormController.java:236)
  107.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  108.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
  109.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  110.         at java.lang.reflect.Method.invoke(Method.java:597)
  111.         at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
  112.         at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
  113.         at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
  114.         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
  115.         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
  116.         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
  117.         at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
  118.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
  119.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  120.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
  121.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  122.         at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:61)
  123.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  124.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  125.         at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:72)
  126.         at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:54)
  127.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  128.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  129.         at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:107)
  130.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  131.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  132.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  133.         at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
  134.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  135.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  136.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  137.         at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  138.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  139.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  140.         at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  141.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  142.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  143.         at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:105)
  144.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  145.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  146.         at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  147.         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
  148.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
  149.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
  150.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
  151.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
  152.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
  153.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
  154.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
  155.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
  156.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
  157.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
  158.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
  159.         at java.lang.Thread.run(Thread.java:680)
  160. Caused by: java.sql.BatchUpdateException: Column 'value' cannot be null
  161.         at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055)
  162.         at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
  163.         at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
  164.         at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
  165.         at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
  166.         ... 151 more
  167. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'value' cannot be null
  168.         at sun.reflect.GeneratedConstructorAccessor597.newInstance(Unknown Source)
  169.         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
  170.         at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
  171.         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  172.         at com.mysql.jdbc.Util.getInstance(Util.java:386)
  173.         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
  174.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
  175.         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4169)
  176.         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2617)
  177.         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2778)
  178.         at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
  179.         at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
  180.         at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2441)
  181.         at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2007)
  182.         ... 155 more
  183. INFO - LoggingAdvice.invoke(150) |2015-05-23 09:03:29,984| Exiting method savePatient
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!