You have a foreign key somewhere referring to that row. Do you have a module or other table that refers to those patient searches? You have to delete those first.
Ben On Wed, Nov 23, 2011 at 5:46 AM, Joaquín Blaya < [email protected]> wrote: > I'm using OpenMRS 1.6.2 with Reporting Compatibility 1.5.4.2 and when I go > to Manage Patient Searches and try to delete the patient search Id=1 I get > the error below. I've seen this before in other implementations where I > haven't been able to delete the patient search with Id=1. Is there a way > to do this? > > Joaquín > ___________________________________________________________________ > Gerente de Desarrollo, eHealth Systems <http://www.ehs.cl/> > Research Fellow, Escuela de Medicina de Harvard <http://hms.harvard.edu/> > Moderador, GHDOnline.org <http://www.ghdonline.org/> > > An Internal Error has Occurred > *org.springframework.dao.DataIntegrityViolationException* > Could not execute JDBC batch update; nested exception is > org.hibernate.exception.ConstraintViolationException: Could not execute > JDBC batch update > > > Consult the help document<https://www.mobilecitizen.info/openmrs/help.htm> > . > Contact your friendly neighborhood administrator if it cannot be resolved. > > Hide stack > trace<https://www.mobilecitizen.info/openmrs/admin/reports/patientSearch.list#> > > > org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636) > > org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:789) > > org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663) > > org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) > > org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) > > org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) > > org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) > > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) > > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > $Proxy88.deleteReportObject(Unknown Source) > sun.reflect.GeneratedMethodAccessor1014.invoke(Unknown Source) > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > java.lang.reflect.Method.invoke(Method.java:597) > > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) > > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) > $Proxy147.deleteReportObject(Unknown Source) > * > org.openmrs.web.controller.report.PatientSearchListController.onSubmit(PatientSearchListController.java:107) > * > > org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267) > > org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265) > > org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) > > org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) > > org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) > > org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) > > org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) > > org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) > javax.servlet.http.HttpServlet.service(HttpServlet.java:637) > javax.servlet.http.HttpServlet.service(HttpServlet.java:717) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > * > org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:76) > * > *org.openmrs.module.xforms.web.XformsFilter.doFilter(XformsFilter.java:60) > * > * > org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:74) > * > *org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:58) > * > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > * > org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:112) > * > > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) > > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > *org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:82)* > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > *org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:82)* > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > *org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:82)* > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:96) > > org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) > > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) > > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) > org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) > > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) > org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) > java.lang.Thread.run(Thread.java:662) > > > OpenMRS Version: 1.6.2 Build 16603 > > > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from > OpenMRS Implementers' mailing list _________________________________________ To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-implement-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]
