dhis2-devs team mailing list archive

[Aanyo AHIAGNO <meloprod7@xxxxxxxxx>]

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


-- 
AHIAGNO Aanyo
HISP West Africa
0022890962285