dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxx>:
>
>> 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@xxxxxxxxx>
>> 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.Data
>>> ElementCategoryCombo.translations, could not initialize p
>>> roxy - no Session
>>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>>> on.throwLazyInitializationException(AbstractPersistentCollec
>>> tion.java:579)
>>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>>> on.withTemporarySessionIfNeeded(AbstractPersistentCollection.java:203)
>>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>>> on.initialize(AbstractPersistentCollection.java:558)
>>>         at org.hibernate.collection.internal.AbstractPersistentCollecti
>>> on.read(AbstractPersistentCollection.java:131)
>>>         at org.hibernate.collection.internal.PersistentSet.iterator(Per
>>> sistentSet.java:163)
>>>         at java.util.AbstractCollection.addAll(Unknown Source)
>>>         at org.hisp.dhis.common.BaseIdentifiableObject.mergeWith(BaseId
>>> entifiableObject.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$collectOb
>>> jectReferences$28(DefaultPreheatService.java:635)
>>>         at java.util.ArrayList.forEach(Unknown Source)
>>>         at org.hisp.dhis.preheat.DefaultPreheatService.collectObjectRef
>>> erences(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.invokeJoinpointUsin
>>> gReflection(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.TransactionInter
>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>         at org.springframework.transaction.interceptor.TransactionAspec
>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>>         at org.springframework.transaction.interceptor.TransactionInter
>>> ceptor.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.invokeJoinpointUsin
>>> gReflection(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.DelegatingIntroductionInterc
>>> eptor.doProceed(DelegatingIntroductionInterceptor.java:133)
>>>         at org.springframework.aop.support.DelegatingIntroductionInterc
>>> eptor.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.DefaultObjectBundle
>>> Service.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.invokeJoinpointUsin
>>> gReflection(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.TransactionInter
>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>         at org.springframework.transaction.interceptor.TransactionAspec
>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>>         at org.springframework.transaction.interceptor.TransactionInter
>>> ceptor.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.imp
>>> ortMetadata(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.invokeJoinpointUsin
>>> gReflection(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.TransactionInter
>>> ceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
>>>         at org.springframework.transaction.interceptor.TransactionAspec
>>> tSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
>>>         at org.springframework.transaction.interceptor.TransactionInter
>>> ceptor.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(SecurityC
>>> ontextRunnable.java:57)
>>>         at org.springframework.scheduling.support.DelegatingErrorHandli
>>> ngRunnable.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@xxxxxxxxx> wrote:
>>>
>>>> Do you have access to the log from the server?
>>>>
>>>> On Nov 26, 2016 11:20 AM, "Aanyo AHIAGNO" <meloprod7@xxxxxxxxx> 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
>>>>>
>>>>>
>>>>>
>>>>> [image: Images intégrées 1]
>>>>>
>>>>>
>>>>> Thanks
>>>>>
>>>>> 2016-11-26 10:10 GMT+00:00 Knut Staring <knutst@xxxxxxxxx>:
>>>>>
>>>>>> 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@xxxxxxxxx>
>>>>>> 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*
>>>>>>>
>>>>>>> [image: Images intégrées 1]
>>>>>>>
>>>>>>> *Is not working*
>>>>>>>
>>>>>>> name,uid,code,shortname,description,formname,domaintype,valu
>>>>>>> etype,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@xxxxxxxxxxxxxxxxxxx
>>>>>>> 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
>>>>>
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> 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@xxxxxxxxx
>>>
>>> Skype: calle_hedberg
>>>
>>> *******************************************
>>>
>>>
>>
>>
>> --
>>
>> *******************************************
>>
>> 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@xxxxxxxxx
>>
>> Skype: calle_hedberg
>>
>> *******************************************
>>
>>
>
>
> --
> AHIAGNO Aanyo
> HISP West Africa
> 0022890962285
>



-- 

*******************************************

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@xxxxxxxxx

Skype: calle_hedberg

*******************************************