Re: [Dhis2-devs] Error while removing a DataElement from a ProgramStage (2.20)

[Jose Garcia Muñoz]

Sorry guys, I really don't want to bore you, but this is becoming pretty
urgent :)... We have a program with more than 1600 DElements that is
causing an exception in the analytics engine (we can not update the
analytic tables at all in the server), and we need to remove some DElements
from that program before the next week (PSI is leading a training on next
Tuesday using the server). Would you be able to try to solve this problem?
We just need to know if it is possible (otherwise I have to look for other
potentital solutions asap).

Many thanks!
Jose

On Mon, Feb 8, 2016 at 9:06 PM, Jose Garcia Muñoz 
wrote:

>
> Hi devs,
>
> We get an exception each time we want to remove a particular data element
> from its program (programstage). It seems that does not matter if the
> datalement has a trackedentityvalue or not (and it shouldn't matter
> right?). We are running 2.20 (revision 19968). It works fine for 2.22, but
> it is important for us to have this problem solved for 2.20 (if possible),
> as many dataelements do not make sense for us anymore (even we can not run
> the analytics because of this ...)
>
> Is there anything you can do from your side?
>
> Thanks guys!
> Jose
>
> Here is the error trace...
>
> * ERROR 2016-02-08 20:38:26,194 Error while executing action
> (ExceptionIntercept
> or.java [http-apr-8080-exec-6])
> org.springframework.dao.InvalidDataAccessApiUsageException: deleted object
> would
>  be re-saved by cascade (remove deleted object from associations):
> [org.hisp.dhi
> s.program.ProgramStageDataElement#21547]; nested exception is
> org.hibernate.Obje
> ctDeletedException: deleted object would be re-saved by cascade (remove
> deleted
> object from associations):
> [org.hisp.dhis.program.ProgramStageDataElement#21547]
>
> at
> org.springframework.orm.hibernate4.SessionFactoryUtils.convertHiberna
> teAccessException(SessionFactoryUtils.java:193)
> at
> org.springframework.orm.hibernate4.HibernateTransactionManager.conver
> tHibernateAccessException(HibernateTransactionManager.java:730)
> at
> org.springframework.orm.hibernate4.HibernateTransactionManager.doComm
> it(HibernateTransactionManager.java:592)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionMa
> nager.processCommit(AbstractPlatformTransactionManager.java:757)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionMa
> nager.commit(AbstractPlatformTransactionManager.java:726)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.
> commitTransactionAfterReturning(TransactionAspectSupport.java:521)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.
> invokeWithinTransaction(TransactionAspectSupport.java:291)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.in
> voke(TransactionInterceptor.java:96)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.adapter.MethodBeforeAdviceIntercept
> or.invoke(MethodBeforeAdviceInterceptor.java:52)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
> e(ExposeInvocationInterceptor.java:92)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
> ReflectiveMethodInvocation.java:179)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
> cAopProxy.java:207)
> at com.sun.proxy.$Proxy91.deleteProgramStageDataElement(Unknown
> Source)
> at
> org.hisp.dhis.trackedentity.action.programstage.UpdateProgramStageAct
> ion.execute(UpdateProgramStageAction.java:474)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
> java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
> sorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
> ctionInvocation.java:450)
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
> ultActionInvocation.java:289)
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:252)
> at
> org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
> ept(XWorkPortalUserInterceptor.java:91)
> at
> com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
> nvocation.java:246)
> at
> org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
> rcept(XWorkPortalModuleInterceptor.java:92)
> at
> 

[Dhis2-devs] Error while removing a DataElement from a ProgramStage (2.20)

[Jose Garcia Muñoz]

Hi devs,

We get an exception each time we want to remove a particular data element
from its program (programstage). It seems that does not matter if the
datalement has a trackedentityvalue or not (and it shouldn't matter
right?). We are running 2.20 (revision 19968). It works fine for 2.22, but
it is important for us to have this problem solved for 2.20 (if possible),
as many dataelements do not make sense for us anymore (even we can not run
the analytics because of this ...)

Is there anything you can do from your side?

Thanks guys!
Jose

Here is the error trace...

* ERROR 2016-02-08 20:38:26,194 Error while executing action
(ExceptionIntercept
or.java [http-apr-8080-exec-6])
org.springframework.dao.InvalidDataAccessApiUsageException: deleted object
would
 be re-saved by cascade (remove deleted object from associations):
[org.hisp.dhi
s.program.ProgramStageDataElement#21547]; nested exception is
org.hibernate.Obje
ctDeletedException: deleted object would be re-saved by cascade (remove
deleted
object from associations):
[org.hisp.dhis.program.ProgramStageDataElement#21547]

at
org.springframework.orm.hibernate4.SessionFactoryUtils.convertHiberna
teAccessException(SessionFactoryUtils.java:193)
at
org.springframework.orm.hibernate4.HibernateTransactionManager.conver
tHibernateAccessException(HibernateTransactionManager.java:730)
at
org.springframework.orm.hibernate4.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:592)
at
org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.processCommit(AbstractPlatformTransactionManager.java:757)
at
org.springframework.transaction.support.AbstractPlatformTransactionMa
nager.commit(AbstractPlatformTransactionManager.java:726)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.
commitTransactionAfterReturning(TransactionAspectSupport.java:521)
at
org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:291)
at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.adapter.MethodBeforeAdviceIntercept
or.invoke(MethodBeforeAdviceInterceptor.java:52)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.interceptor.ExposeInvocationInterceptor.invok
e(ExposeInvocationInterceptor.java:92)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:179)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:207)
at com.sun.proxy.$Proxy91.deleteProgramStageDataElement(Unknown
Source)
at
org.hisp.dhis.trackedentity.action.programstage.UpdateProgramStageAct
ion.execute(UpdateProgramStageAction.java:474)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultA
ctionInvocation.java:450)
at
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(Defa
ultActionInvocation.java:289)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:252)
at
org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.interc
ept(XWorkPortalUserInterceptor.java:91)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at
org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.inte
rcept(XWorkPortalModuleInterceptor.java:92)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at
org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.interc
ept(XWorkPortalMenuInterceptor.java:100)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at
org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.inte
rcept(XWorkPortalParamsInterceptor.java:150)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at
org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterce
ptor.java:83)
at
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
at
org.hisp.dhis.interceptor.UserSettingInterceptor.intercept(UserSettin
gInterceptor.java:84)
at