dhis2-devs team mailing list archive

Thread
Date
DHIS2.0.4: import errors referring to DataElementCategoryOption?

To: DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Kim-Anh Vo <catakim@xxxxxxxxx>
Date: Wed, 5 May 2010 10:49:02 +0700
Hi,

Can't run import for datavalue due to duplication of
DataElementCategoryOption... but checked out the equivalent table - it seems
fine...
*
See the logs:*
*
* INFO  10:12:34,832 Internal process started
(AbstractStatementInternalProcess.java [Thread-15])
* INFO  10:12:43,949 Imported DataElementCategoryOptions
(DefaultImportObjectManager.java [Thread-15])
* INFO  10:12:50,396 Imported DataElementCategories
(DefaultImportObjectManager.java [Thread-15])
* INFO  10:12:59,588 Imported DataElementCategoryCombos
(DefaultImportObjectManager.java [Thread-15])
* ERROR 10:13:14,721 Internal process failed
(AbstractStatementInternalProcess.java [Thread-15])
org.hibernate.HibernateException: More than one row with the given
identifier was found: 10878, for class:
org.hisp.dhis.dataelement.DataElementCategoryOption
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:69)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:42)
        at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractE
ntityPersister.java:3049)
        at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(D
efaultLoadEventListener.java:399)
        at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEv
entListener.java:375)
        at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEven
tListener.java:139)
        at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultL
oadEventListener.java:195)
        at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEv
entListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
        at
org.hisp.dhis.hibernate.HibernateGenericStore.get(HibernateGenericSto
re.java:162)
        at
org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataEl
ementCategoryOption(DefaultDataElementCategoryService.java:168)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        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 $Proxy17.getDataElementCategoryOption(Unknown Source)
        at
org.hisp.dhis.importexport.service.DefaultImportObjectManager.importC
ategoryOptionCombos(DefaultImportObjectManager.java:342)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy45.importCategoryOptionCombos(Unknown Source)
        at
org.hisp.dhis.importexport.service.DefaultImportObjectService.importA
ll(DefaultImportObjectService.java:637)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:198)
        at $Proxy46.importAll(Unknown Source)
        at
org.hisp.dhis.importexport.ImportPreviewInternalProcess.executeStatem
ents(ImportPreviewInternalProcess.java:69)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:92)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:40)
        at
org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
25)
        at java.lang.Thread.run(Thread.java:619)
* ERROR 10:13:14,886 org.hibernate.HibernateException: More than one row
with th
e given identifier was found: 10878, for class:
org.hisp.dhis.dataelement.DataEl
ementCategoryOption
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:69)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:42)
        at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractE
ntityPersister.java:3049)
        at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(D
efaultLoadEventListener.java:399)
        at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEv
entListener.java:375)
        at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEven
tListener.java:139)
        at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultL
oadEventListener.java:195)
        at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEv
entListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
        at
org.hisp.dhis.hibernate.HibernateGenericStore.get(HibernateGenericSto
re.java:162)
        at
org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataEl
ementCategoryOption(DefaultDataElementCategoryService.java:168)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        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 $Proxy17.getDataElementCategoryOption(Unknown Source)
        at
org.hisp.dhis.importexport.service.DefaultImportObjectManager.importC
ategoryOptionCombos(DefaultImportObjectManager.java:342)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy45.importCategoryOptionCombos(Unknown Source)
        at
org.hisp.dhis.importexport.service.DefaultImportObjectService.importA
ll(DefaultImportObjectService.java:637)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:198)
        at $Proxy46.importAll(Unknown Source)
        at
org.hisp.dhis.importexport.ImportPreviewInternalProcess.executeStatem
ents(ImportPreviewInternalProcess.java:69)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:92)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:40)
        at
org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
25)
        at java.lang.Thread.run(Thread.java:619)
 (AbstractStatementInternalProcess.java [Thread-15])
org.hibernate.HibernateException: More than one row with the given
identifier wa
s found: 10878, for class:
org.hisp.dhis.dataelement.DataElementCategoryOption
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:69)
        at
org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityL
oader.java:42)
        at
org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractE
ntityPersister.java:3049)
        at
org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(D
efaultLoadEventListener.java:399)
        at
org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEv
entListener.java:375)
        at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEven
tListener.java:139)
        at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultL
oadEventListener.java:195)
        at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEv
entListener.java:103)
        at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
        at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
        at
org.hisp.dhis.hibernate.HibernateGenericStore.get(HibernateGenericSto
re.java:162)
        at
org.hisp.dhis.dataelement.DefaultDataElementCategoryService.getDataEl
ementCategoryOption(DefaultDataElementCategoryService.java:168)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        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 $Proxy17.getDataElementCategoryOption(Unknown Source)
        at
org.hisp.dhis.importexport.service.DefaultImportObjectManager.importC
ategoryOptionCombos(DefaultImportObjectManager.java:342)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:182)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:149)
        at
org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:106)
        at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:171)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:204)
        at $Proxy45.importCategoryOptionCombos(Unknown Source)
        at
org.hisp.dhis.importexport.service.DefaultImportObjectService.importA
ll(DefaultImportObjectService.java:637)
        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
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:307)
        at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:198)
        at $Proxy46.importAll(Unknown Source)
        at
org.hisp.dhis.importexport.ImportPreviewInternalProcess.executeStatem
ents(ImportPreviewInternalProcess.java:69)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:92)
        at
org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:40)
        at
org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
25)
        at java.lang.Thread.run(Thread.java:619)*


Because of not knowing the association/relations relating between
dataelement, dataelementCategoryOption, and , etc.... CAN anyone help?
The database_backup and expected datavalues with import file (exported by
DHIS2.0.4) are attached!


-- 
-- 
Best regards,
Kim-Anh Vo

+84.906612246
kavo@xxxxxxxxxx
Coordinator of HISP(hisp.info) in Vietnam
Master of Information Systems
at the University of Oslo
------------------------------------
join facebook at www.facebook.com join LinkedIn at www.linkedin.com
Attachment: dhis2_vietnam_warehouse_MAY5.backup
Description: Binary data
Attachment: Export_2009-01-01_2010-05-04_TP.HCM.zip
Description: Zip archive
Follow ups

Re: DHIS2.0.4: import errors referring to DataElementCategoryOption?
From: Kim-Anh Vo, 2010-05-07