dhis2-users team mailing list archive

[Ramón José Jiménez Pomareta <dhis2@xxxxxxxxxxx>]

Here's the server log :)

2017-11-20 12:11 GMT+01:00 Ramón José Jiménez Pomareta <dhis2@xxxxxxxxxxx>:

> Hello,
>
> We are experiencing some problems to import events with the import-export
> data App. It only allows to import one line. When we import more than one
> it raises an error on the serve (see the serverlog attached).
>
> The user received a part of the serverlog error :
> Process failed: A different object with the same identifier value was
> already associated with the session : [org.hisp.dhis.
> trackedentitydatavalue.TrackedEntityDataValue#TrackedEntityDataValue{dataElement={"class":"class
> org.hisp.dhis.dataelement.DataElement", "hashCode":"582086769",
> "id":"92040",
>
> JIRA ticket : https://jira.dhis2.org/browse/DHIS2-2518
>
> Thank you for helping.
>
> PS: The documentation should be updated in order to know the correct csv
> format: c.f. (https://jira.dhis2.org/browse/DHIS2-1905)
>
> Best,
> Ramón Jimenez Pomareta
>

* INFO  2017-11-20 11:57:30,354 [Level: INFO, category: EVENT_IMPORT, time: Mon Nov 20 11:57:30 CET 2017, message: Importing events] (InMemoryNotifier.java [taskScheduler-16])
* INFO  2017-11-20 11:57:30,394 'ramon' update org.hisp.dhis.program.ProgramStageInstance, uid: AAAAAAAAA (AuditLogUtil.java [taskScheduler-16])
* INFO  2017-11-20 11:57:30,401 'ramon' update org.hisp.dhis.program.ProgramInstance, uid: BBBBBBBBBBB (AuditLogUtil.java [taskScheduler-16])
* ERROR 2017-11-20 11:57:30,410 org.hibernate.NonUniqueObjectException: A different object with the same identifier value was already associated with the session : [org.hisp.dhis.trackedentitydatavalue.TrackedEntityDataValue#TrackedEntityDataValue{dataElement={"class":"class org.hisp.dhis.dataelement.DataElement", "hashCode":"582086769", "id":"92040", "uid":"CCCCCCCCCC", "code":"Yaws_cases_byProvenance_T", "name":"Yaws_cases_by provenance_T", "shortName":"Yaws_cases_by provenance_T", "description":"Number of yaws cases, reported by place of provenance.", "created":"2017-03-20 13:40:45.219", "lastUpdated":"2017-10-02 09:00:39.284" }, programStageInstance={"class":"class org.hisp.dhis.program.ProgramStageInstance", "id":"126872", "uid":"AAAAAAAAA", "code":"null", "name":"null", "created":"Mon Nov 20 11:57:30 CET 2017", "lastUpdated":"Mon Nov 20 11:57:30 CET 2017" }, lastUpdated=Mon Nov 20 11:57:30 CET 2017, value='65', providedElsewhere=null, storedBy='ramon'}]
        at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:169)
        at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)
        at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)
        at org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)
        at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)
        at org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)
        at org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)
        at org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)
        at org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)
        at org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)
        at org.hisp.dhis.trackedentitydatavalue.hibernate.HibernateTrackedEntityDataValueStore.saveVoid(HibernateTrackedEntityDataValueStore.java:56)
        at org.hisp.dhis.trackedentitydatavalue.DefaultTrackedEntityDataValueService.saveTrackedEntityDataValue(DefaultTrackedEntityDataValueService.java:105)
        at sun.reflect.GeneratedMethodAccessor2551.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy180.saveTrackedEntityDataValue(Unknown Source)
        at org.hisp.dhis.dxf2.events.event.AbstractEventService.saveDataValue(AbstractEventService.java:1388)
        at org.hisp.dhis.dxf2.events.event.AbstractEventService.saveEvent(AbstractEventService.java:1354)
        at org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvent(AbstractEventService.java:440)
        at org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvents(AbstractEventService.java:230)
        at org.hisp.dhis.dxf2.events.event.AbstractEventService.addEvents(AbstractEventService.java:250)
        at sun.reflect.GeneratedMethodAccessor2917.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy248.addEvents(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor2916.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy197.addEvents(Unknown Source)
        at org.hisp.dhis.dxf2.events.event.ImportEventsTask.call(ImportEventsTask.java:63)
        at org.hisp.dhis.security.SecurityContextRunnable.run(SecurityContextRunnable.java:57)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)
 (AbstractEventService.java [taskScheduler-16])
* INFO  2017-11-20 11:57:30,410 [Level: ERROR, category: EVENT_IMPORT, time: Mon Nov 20 11:57:30 CET 2017, message: Process failed: A different object with the same identifier value was already associated with the session : [org.hisp.dhis.trackedentitydatavalue.TrackedEntityDataValue#TrackedEntityDataValue{dataElement={"class":"class org.hisp.dhis.dataelement.DataElement", "hashCode":"582086769", "id":"92040", "uid":"CCCCCCCCCC", "code":"Yaws_cases_byProvenance_T", "name":"Yaws_cases_by provenance_T", "shortName":"Yaws_cases_by provenance_T", "description":"Number of yaws cases, reported by place of provenance.", "created":"2017-03-20 13:40:45.219", "lastUpdated":"2017-10-02 09:00:39.284" }, programStageInstance={"class":"class org.hisp.dhis.program.ProgramStageInstance", "id":"126872", "uid":"AAAAAAAAA", "code":"null", "name":"null", "created":"Mon Nov 20 11:57:30 CET 2017", "lastUpdated":"Mon Nov 20 11:57:30 CET 2017" }, lastUpdated=Mon Nov 20 11:57:30 CET 2017, value='65', providedElsewhere=null, storedBy='ramon'}]] (InMemoryNotifier.java [taskScheduler-16])
* ERROR 2017-11-20 11:57:30,412 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-16])
org.springframework.transaction.UnexpectedRollbackException: Transaction rolled back because it has been marked as rollback-only
        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:724)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:504)
        at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:292)
        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy248.addEvents(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor2916.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133)
        at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
        at com.sun.proxy.$Proxy197.addEvents(Unknown Source)
        at org.hisp.dhis.dxf2.events.event.ImportEventsTask.call(ImportEventsTask.java:63)
        at org.hisp.dhis.security.SecurityContextRunnable.run(SecurityContextRunnable.java:57)
        at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
        at java.util.concurrent.FutureTask.run(FutureTask.java:266)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
        at java.lang.Thread.run(Thread.java:745)