Problem on CSV Data Element import - Version 2.25

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

···

AHIAGNO Aanyo
HISP West Africa

0022890962285

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut

···

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Images intégrées 1

Thanks

DataElement.csv (109 Bytes)

···

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

AHIAGNO Aanyo
HISP West Africa

0022890962285

Do you have access to the log from the server?

···

On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])

  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle

···

On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


Hi,

I’ve tested this with the simplest CSV file imagineable - just two data element names:

“Emergency headcount total”

“OPD headcount not referred new”

Error is the same

The manual states very clearly that the ONLY compulsory field when importing Data Elements in CSV format is the first “Name” field.

Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR ELSE there is something missing from our installations, some library or something.

Sigh - I hope this can be fixed asap, it’s a real real pain to have to shift an instance back to e.g. 2.24 or earlier to make this type of basic functionality work

Regards

Calle

···

On 26 November 2016 at 16:10, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle

On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


IS Okay now.
Put categorycomboid = default and it will be fine.

Thanks

···

2016-11-26 14:28 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

I’ve tested this with the simplest CSV file imagineable - just two data element names:

“Emergency headcount total”

“OPD headcount not referred new”

Error is the same

The manual states very clearly that the ONLY compulsory field when importing Data Elements in CSV format is the first “Name” field.

Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR ELSE there is something missing from our installations, some library or something.

Sigh - I hope this can be fixed asap, it’s a real real pain to have to shift an instance back to e.g. 2.24 or earlier to make this type of basic functionality work

Regards

Calle

On 26 November 2016 at 16:10, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

AHIAGNO Aanyo
HISP West Africa

0022890962285

Hi,

So you are actually saying that categorycomboid is no longer optional… Then that is either a BUG or else the developer manual documentation is out of synch…

Will try

Regards

Calle

···

On 26 November 2016 at 17:13, Aanyo AHIAGNO meloprod7@gmail.com wrote:

IS Okay now.
Put categorycomboid = default and it will be fine.

Thanks

2016-11-26 14:28 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

I’ve tested this with the simplest CSV file imagineable - just two data element names:

“Emergency headcount total”

“OPD headcount not referred new”

Error is the same

The manual states very clearly that the ONLY compulsory field when importing Data Elements in CSV format is the first “Name” field.

Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR ELSE there is something missing from our installations, some library or something.

Sigh - I hope this can be fixed asap, it’s a real real pain to have to shift an instance back to e.g. 2.24 or earlier to make this type of basic functionality work

Regards

Calle


AHIAGNO Aanyo
HISP West Africa

0022890962285

On 26 November 2016 at 16:10, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


Yes, is not optional on 2.25. So don’t worry, the developer manual documentation will be mention it

···

2016-11-26 15:25 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

So you are actually saying that categorycomboid is no longer optional… Then that is either a BUG or else the developer manual documentation is out of synch…

Will try

Regards

Calle

On 26 November 2016 at 17:13, Aanyo AHIAGNO meloprod7@gmail.com wrote:

IS Okay now.
Put categorycomboid = default and it will be fine.

Thanks


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


2016-11-26 14:28 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

I’ve tested this with the simplest CSV file imagineable - just two data element names:

“Emergency headcount total”

“OPD headcount not referred new”

Error is the same

The manual states very clearly that the ONLY compulsory field when importing Data Elements in CSV format is the first “Name” field.

Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR ELSE there is something missing from our installations, some library or something.

Sigh - I hope this can be fixed asap, it’s a real real pain to have to shift an instance back to e.g. 2.24 or earlier to make this type of basic functionality work

Regards

Calle


AHIAGNO Aanyo
HISP West Africa

0022890962285

On 26 November 2016 at 16:10, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

AHIAGNO Aanyo
HISP West Africa

0022890962285

But this will be confirmed by Dev team.

Thanks

···

2016-11-26 15:38 GMT+00:00 Aanyo AHIAGNO meloprod7@gmail.com:

Yes, is not optional on 2.25. So don’t worry, the developer manual documentation will be mention it

2016-11-26 15:25 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

So you are actually saying that categorycomboid is no longer optional… Then that is either a BUG or else the developer manual documentation is out of synch…

Will try

Regards

Calle


AHIAGNO Aanyo
HISP West Africa

0022890962285

On 26 November 2016 at 17:13, Aanyo AHIAGNO meloprod7@gmail.com wrote:

IS Okay now.
Put categorycomboid = default and it will be fine.

Thanks


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


2016-11-26 14:28 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

I’ve tested this with the simplest CSV file imagineable - just two data element names:

“Emergency headcount total”

“OPD headcount not referred new”

Error is the same

The manual states very clearly that the ONLY compulsory field when importing Data Elements in CSV format is the first “Name” field.

Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR ELSE there is something missing from our installations, some library or something.

Sigh - I hope this can be fixed asap, it’s a real real pain to have to shift an instance back to e.g. 2.24 or earlier to make this type of basic functionality work

Regards

Calle


AHIAGNO Aanyo
HISP West Africa

0022890962285

On 26 November 2016 at 16:10, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org

AHIAGNO Aanyo
HISP West Africa

0022890962285

Hi,

You are correct - it imports (fast!!) if a number of additional fields are added.

Best regards
Calle

···

On 26 November 2016 at 18:25, Aanyo AHIAGNO meloprod7@gmail.com wrote:

But this will be confirmed by Dev team.

Thanks

2016-11-26 15:38 GMT+00:00 Aanyo AHIAGNO meloprod7@gmail.com:

Yes, is not optional on 2.25. So don’t worry, the developer manual documentation will be mention it


AHIAGNO Aanyo
HISP West Africa

0022890962285

2016-11-26 15:25 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

So you are actually saying that categorycomboid is no longer optional… Then that is either a BUG or else the developer manual documentation is out of synch…

Will try

Regards

Calle


AHIAGNO Aanyo
HISP West Africa

0022890962285

On 26 November 2016 at 17:13, Aanyo AHIAGNO meloprod7@gmail.com wrote:

IS Okay now.
Put categorycomboid = default and it will be fine.

Thanks


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


2016-11-26 14:28 GMT+00:00 Calle Hedberg calle.hedberg@gmail.com:

Hi,

I’ve tested this with the simplest CSV file imagineable - just two data element names:

“Emergency headcount total”

“OPD headcount not referred new”

Error is the same

The manual states very clearly that the ONLY compulsory field when importing Data Elements in CSV format is the first “Name” field.

Bottom line - the import from CSV is broken in 2.25 and 2.26 Trunk. OR ELSE there is something missing from our installations, some library or something.

Sigh - I hope this can be fixed asap, it’s a real real pain to have to shift an instance back to e.g. 2.24 or earlier to make this type of basic functionality work

Regards

Calle


AHIAGNO Aanyo
HISP West Africa

0022890962285

On 26 November 2016 at 16:10, Calle Hedberg calle.hedberg@gmail.com wrote:

Hi,

I’ve just tried the same in Trunk - importing a CSV file with data elements, same format as what used to work in previous versions. My tomcat log shows the following:

  • INFO 2016-11-26 16:04:24,017 (Calle_Hedberg) Import:Preheat[REFERENCE] took 0.11 seconds (DefaultPreheatService.java [taskScheduler-8])
  • ERROR 2016-11-26 16:04:24,027 Unexpected error occurred in scheduled task. (TaskUtils.java [taskScheduler-8])

org.hibernate.LazyInitializationException: failed to lazily initialize a collection of role: org.hisp.dhis.dataelement.DataElementCategoryCombo.translations, could not initialize p

roxy - no Session

at org.hibernate.collection.internal.AbstractPersistentCollection.throwLazyInitializationException(AbstractPersistentCollection.java:579)

at org.hibernate.collection.internal.AbstractPersistentCollection.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)

at org.hibernate.collection.internal.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:558)

at org.hibernate.collection.internal.AbstractPersistentCollection.read(AbstractPersistentCollection.java:131)

at org.hibernate.collection.internal.PersistentSet.iterator(PersistentSet.java:163)

at java.util.AbstractCollection.addAll(Unknown Source)

at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseIdentifiableObject.java:763)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:327)

at org.hisp.dhis.dataelement.DataElementCategoryCombo.mergeWith(DataElementCategoryCombo.java:51)

at org.hisp.dhis.preheat.DefaultPreheatService.lambda$collectObjectReferences$28(DefaultPreheatService.java:635)

at java.util.ArrayList.forEach(Unknown Source)

at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectReferences(DefaultPreheatService.java:624)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy236.collectObjectReferences(Unknown Source)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:208)

at com.sun.proxy.$Proxy165.collectObjectReferences(Unknown Source)

at org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.create(DefaultObjectBundleService.java:113)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy186.create(Unknown Source)

at org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:107)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)

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:281)

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:208)

at com.sun.proxy.$Proxy188.importMetadata(Unknown Source)

at org.hisp.dhis.importexport.action.util.ImportMetaDataCsvTask.call(ImportMetaDataCsvTask.java:98)

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(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Regards

Calle


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On 26 November 2016 at 12:34, Knut Staring knutst@gmail.com wrote:

Do you have access to the log from the server?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg


On Nov 26, 2016 11:20 AM, “Aanyo AHIAGNO” meloprod7@gmail.com wrote:

Thanks,

I making a test, so i try to import on my csv just 2 data element.

but it load too long. i’m not sure that is working.

i join my csv.

2016-11-26 09:41:46
(admin) Import:Start

Thanks

2016-11-26 10:10 GMT+00:00 Knut Staring knutst@gmail.com:

Hi Aanyo,

Could you describe what is happening? “Is not working” is not very helpful for understanding what the problem might be.

Knut


AHIAGNO Aanyo
HISP West Africa

0022890962285

On Sat, Nov 26, 2016 at 11:06 AM, Aanyo AHIAGNO meloprod7@gmail.com wrote:

Hi all,

The CSV data elemnt import does not work well on the 2.25. Does someone have a good template CSV of Data Element for 2.25?

Is not working

Is not working

name,uid,code,shortname,description,formname,domaintype,valuetype,aggregationtype,categorycomboid,url,zeroissignificant,optionset

DS_Polio 1st dose given,DS_Polio 1st dose given,DS_Polio 1st dose given,AGGREGATE,TEXT,GvTQH2bALqZ,beLZmBucDZa

Is not working

name,uid,code,shortname,description

“Women participated in skill development training”,“D0001”,"Women participated

development training"

“Women participated in community organizations”,“D0002”,"Women participated community

organizations"

Thanks

AHIAGNO Aanyo
HISP West Africa

0022890962285


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Knut Staring

Dept. of Informatics, University of Oslo

Norway: +4791880522

Skype: knutstar

http://dhis2.org


Calle Hedberg

46D Alma Road, 7700 Rosebank, SOUTH AFRICA

Tel/fax (home): +27-21-685-6472

Cell: +27-82-853-5352

Iridium SatPhone: +8816-315-19119

Email: calle.hedberg@gmail.com

Skype: calle_hedberg