dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hm. The log doesn't say anything about which foreign key is still
referenced. Can you please do the following query directly in the
database/pgadmin and post the output/look for which table is still
referenced?

delete from orgunitgroup where orgunitgroupid='74358'



On Fri, May 21, 2010 at 7:52 AM, Kim Anh Vo <catakim@xxxxxxxxx> wrote:

> ...
> Caused by: java.sql.BatchUpdateException: Batch entry 0 delete from
> orgunitgroup
>  where orgunitgroupid='74358' was aborted.  Call getNextException to see
> the cau
> se.
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handle
> Error(AbstractJdbc2Statement.java:2569)
>        at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
> Impl.java:1796)
>        at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
> va:407)
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc
> 2Statement.java:2708)
>        at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
> oxyPreparedStatement.java:1723)
>        at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
> a:48)
>        at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 246)
>        ... 96 more
> * ERROR 12:49:26,543 Error while executing action
> (ExceptionInterceptor.java [ht
> tp-8080-6])
> org.springframework.dao.DataIntegrityViolationException: Could not execute
> JDBC
> batch update; nested exception is
> org.hibernate.exception.ConstraintViolationExc
> eption: Could not execute JDBC batch update
>        at
> org.springframework.orm.hibernate3.SessionFactoryUtils.convertHiberna
> teAccessException(SessionFactoryUtils.java:636)
>        at
> org.springframework.orm.hibernate3.HibernateTransactionManager.conver
> tHibernateAccessException(HibernateTransactionManager.java:789)
>        at
> org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
> it(HibernateTransactionManager.java:663)
>        at
> org.springframework.transaction.support.AbstractPlatformTransactionMa
> nager.processCommit(AbstractPlatformTransactionManager.java:732)
>        at
> org.springframework.transaction.support.AbstractPlatformTransactionMa
> nager.commit(AbstractPlatformTransactionManager.java:701)
>        at
> org.springframework.transaction.interceptor.TransactionAspectSupport.
> commitTransactionAfterReturning(TransactionAspectSupport.java:321)
>        at
> org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:116)
>        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:171)
>        at
> org.springframework.aop.framework.adapter.MethodBeforeAdviceIntercept
> or.invoke(MethodBeforeAdviceInterceptor.java:50)
>        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:171)
>        at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
> e(ExposeInvocationInterceptor.java:89)
>        at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:171)
>        at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:204)
>        at $Proxy11.deleteOrganisationUnitGroup(Unknown Source)
>        at
> org.hisp.dhis.oum.action.organisationunitgroup.RemoveOrganisationUnit
> GroupAction.execute(RemoveOrganisationUnitGroupAction.java:70)
>        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>        at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:39)
>        at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:25)
>        at java.lang.reflect.Method.invoke(Method.java:597)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
> ctionInvocation.java:440)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
> ultActionInvocation.java:279)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:242)
>        at
> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
> ept(XWorkPortalUserInterceptor.java:82)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
> rcept(XWorkPortalModuleInterceptor.java:85)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
> ept(XWorkPortalMenuInterceptor.java:91)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
> rcept(XWorkPortalParamsInterceptor.java:117)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor
> .java:89)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSe
> ttingInterceptor.java:94)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.DataDictionaryModeInterceptor.intercept(Dat
> aDictionaryModeInterceptor.java:109)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(Displa
> yPropertyInterceptor.java:90)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInt
> erceptor.java:124)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(X
> WorkSecurityInterceptor.java:98)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.j
> ava:141)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(Cha
> iningInterceptor.java:126)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept
> (ParametersInterceptor.java:195)
>        at
> com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept
> (MethodFilterInterceptor.java:87)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
> cept(StaticParametersInterceptor.java:148)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
> erceptor.java:89)
>        at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:236)
>        at
> org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
> ava:52)
>        at
> org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
> a:468)
>        at
> org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatc
> her.java:395)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:235)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:206)
>        at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain
> .doFilter(FilterChainProxy.java:378)
>        at
> org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLo
> ginFilter.java:129)
>        at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain
> .doFilter(FilterChainProxy.java:390)
>        at
> org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
> cAccessFilter.java:112)
>        at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain
> .doFilter(FilterChainProxy.java:390)
>        at
> org.springframework.security.ui.logout.LogoutFilter.doFilterHttp(Logo
> utFilter.java:89)
>        at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
> ecurityFilter.java:53)
>        at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain
> .doFilter(FilterChainProxy.java:390)
>        at
> org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp
> (AbstractProcessingFilter.java:278)
>        at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
> ecurityFilter.java:53)
>        at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain
> .doFilter(FilterChainProxy.java:390)
>        at
> org.springframework.security.context.HttpSessionContextIntegrationFil
> ter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235)
>        at
> org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringS
> ecurityFilter.java:53)
>        at
> org.springframework.security.util.FilterChainProxy$VirtualFilterChain
> .doFilter(FilterChainProxy.java:390)
>        at
> org.springframework.security.util.FilterChainProxy.doFilter(FilterCha
> inProxy.java:175)
>        at
> org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
> elegatingFilterProxy.java:236)
>        at
> org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
> ingFilterProxy.java:167)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:235)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:206)
>        at
> org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.do
> FilterInternal(OpenSessionInViewFilter.java:198)
>        at
> org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
> equestFilter.java:76)
>        at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
> icationFilterChain.java:235)
>        at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
> ilterChain.java:206)
>        at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
> alve.java:233)
>        at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
> alve.java:191)
>        at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
> ava:127)
>        at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
> ava:102)
>        at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
> ve.java:109)
>        at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
> a:298)
>        at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
> :852)
>        at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
> ss(Http11Protocol.java:588)
>        at
> org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
> 9)
>        at java.lang.Thread.run(Thread.java:619)
> Caused by: org.hibernate.exception.ConstraintViolationException: Could not
> execu
> te JDBC batch update
>        at
> org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
> ava:71)
>        at
> org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
> er.java:43)
>        at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 253)
>        at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
>
>        at
> org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
>
>        at
> org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
> ns(AbstractFlushingEventListener.java:298)
>        at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
> hEventListener.java:27)
>        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
>        at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
>        at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
> :106)
>        at
> org.springframework.orm.hibernate3.HibernateTransactionManager.doComm
> it(HibernateTransactionManager.java:655)
>        ... 88 more
> Caused by: java.sql.BatchUpdateException: Batch entry 0 delete from
> orgunitgroup
>  where orgunitgroupid='74358' was aborted.  Call getNextException to see
> the cau
> se.
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handle
> Error(AbstractJdbc2Statement.java:2569)
>        at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
> Impl.java:1796)
>        at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
> va:407)
>        at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc
> 2Statement.java:2708)
>        at
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewPr
> oxyPreparedStatement.java:1723)
>        at
> org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.jav
> a:48)
>        at
> org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
> 246)
>        ... 96 more
>
> --
> no error messages/warnings for ougroup deletion
> https://bugs.launchpad.net/bugs/583205
> You received this bug notification because you are a member of DHIS 2
> coordinators, which is the registrant for DHIS.
>
> Status in DHIS 2 - District Health Information Software: New
>
> Bug description:
> DHIS 2.0.4: when deleting an ougroup with existing assignments and
> relationships with other elements/objects ... the process is stuck without
> any error messages/warnings/instructions for users to solve the issue.
>
> Suggestion: check-out the relationships between ou, ougroup, ougroupset,
> etc. for the process of deletion PLUS showing the
> warning/message/instruction for users
>
>
>

-- 
no error messages/warnings for ougroup deletion
https://bugs.launchpad.net/bugs/583205
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.

Status in DHIS 2 - District Health Information Software: New

Bug description:
DHIS 2.0.4: when deleting an ougroup with existing assignments and relationships with other elements/objects ... the process is stuck without any error messages/warnings/instructions for users to solve the issue.

Suggestion: check-out the relationships between ou, ougroup, ougroupset, etc. for the process of deletion PLUS showing the warning/message/instruction for users