dhis2-users team mailing list archive

[Morten Olav Hansen <mortenoh@xxxxxxxxx>]

Yes, it should work.. but something has changed in the tracker api, I will
have a look at it

--
Morten


On Mon, Jan 27, 2014 at 2:14 AM, Jose Garcia Muñoz <josemp10@xxxxxxxxx>wrote:

>
> Great! With the status="ACTIVE" everything are working: UIDs, codes, WEB
> UI, API,...
>
> Would it be possible to allow also "COMPLETE" status?
>
> Thanks Morten!
>
>
> On Sun, Jan 26, 2014 at 7:42 PM, Morten Olav Hansen <mortenoh@xxxxxxxxx>wrote:
>
>> This must be related to something else, can you try with status="ACTIVE" ?
>>
>> --
>> Morten
>>
>>
>> On Mon, Jan 27, 2014 at 1:33 AM, Jose Garcia Muñoz <josemp10@xxxxxxxxx>wrote:
>>
>>>
>>> Hi Morten,
>>>
>>> I am using the 12953 revision now.
>>>
>>> Still getting errors when I try to import SEwoR (it does not matter if
>>> am using the uid or the code). The tomcat writes the following error:
>>>
>>>
>>> There are some Spanish sentences (sorry). The first one said: "The
>>> insertion in the table patiendatavalue violates the foreign key
>>> fk_patientdatavalue_programstageinstance"
>>>
>>> The second one: "The key  (programstageinstanceid)=(0) is not presented
>>> in the table programstageinstane".
>>>
>>> Any ideas?
>>>
>>> * INFO  2014-01-26 19:13:41,695 'josemp10' update
>>> org.hisp.dhis.program.ProgramS
>>> tageInstance, uid: ZBQZwXnO2xN (AuditLogUtil.java [taskScheduler-1])
>>> * INFO  2014-01-26 19:13:41,909 'josemp10' create
>>> org.hisp.dhis.program.ProgramS
>>> tageInstance, uid: ZBQZwXnO2xN (AuditLogUtil.java [taskScheduler-1])
>>> * WARN  2014-01-26 19:13:43,495 SQL Error: 0, SQLState: 23503
>>> (SqlExceptionHelpe
>>> r.java [taskScheduler-1])
>>> * ERROR 2014-01-26 19:13:43,496 ERROR: inserci¾n o actualizaci¾n en la
>>> tabla ½pa
>>> tientdatavalue╗ viola la llave forßnea
>>> ½fk_patientdatavalue_programstageinstance
>>> id╗
>>>   Detail: La llave (programstageinstanceid)=(0) no estß presente en la
>>> tabla ½pr
>>> ogramstageinstance╗. (SqlExceptionHelper.java [taskScheduler-1])
>>> * ERROR 2014-01-26 19:13:43,570 Application exception overridden by
>>> commit excep
>>> tion (TransactionAspectSupport.java [taskScheduler-1])
>>> com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException:
>>> Unrecognized f
>>> ield "eventList" (class org.hisp.dhis.dxf2.events.event.Event), not
>>> marked as ig
>>> norable (11 known properties: , "program", "orgUnit", "eventDate",
>>> "href", "data
>>> Values", "status", "person", "coordinate", "event", "storedBy",
>>> "programStage"])
>>>
>>>  at [Source: java.io.StringReader@7f3e53d5; line: 4, column: 144]
>>> (through refer
>>> ence chain: org.hisp.dhis.dxf2.events.event.Event["eventList"])
>>>         at
>>> com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException.from
>>> (UnrecognizedPropertyException.java:79)
>>>         at
>>> com.fasterxml.jackson.databind.DeserializationContext.reportUnknownPr
>>> operty(DeserializationContext.java:568)
>>>         at
>>> com.fasterxml.jackson.databind.deser.std.StdDeserializer.handleUnknow
>>> nProperty(StdDeserializer.java:650)
>>>         at
>>> com.fasterxml.jackson.databind.deser.BeanDeserializerBase.handleUnkno
>>> wnProperty(BeanDeserializerBase.java:830)
>>>         at
>>> com.fasterxml.jackson.databind.deser.BeanDeserializer.deserializeFrom
>>> Object(BeanDeserializer.java:310)
>>>         at
>>> com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(Bea
>>> nDeserializer.java:112)
>>>         at
>>> com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMa
>>> pper.java:2580)
>>>         at
>>> com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.ja
>>> va:1810)
>>>         at
>>> org.hisp.dhis.dxf2.events.event.JacksonEventService.fromXml(JacksonEv
>>> entService.java:76)
>>>         at
>>> org.hisp.dhis.dxf2.events.event.JacksonEventService.saveEventsXml(Jac
>>> ksonEventService.java:133)
>>>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>>>         at
>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
>>> java:57)
>>>         at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
>>> sorImpl.java:43)
>>>         at java.lang.reflect.Method.invoke(Method.java:606)
>>>         at
>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
>>> on(AopUtils.java:317)
>>>         at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
>>> inpoint(ReflectiveMethodInvocation.java:183)
>>>         at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>>> ReflectiveMethodInvocation.java:150)
>>>         at
>>> org.springframework.transaction.interceptor.TransactionInterceptor$1.
>>> proceedWithInvocation(TransactionInterceptor.java:96)
>>>         at
>>> org.springframework.transaction.interceptor.TransactionAspectSupport.
>>> invokeWithinTransaction(TransactionAspectSupport.java:260)
>>>         at
>>> org.springframework.transaction.interceptor.TransactionInterceptor.in
>>> voke(TransactionInterceptor.java:94)
>>>         at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>>> ReflectiveMethodInvocation.java:172)
>>>         at
>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>>> cAopProxy.java:204)
>>>         at com.sun.proxy.$Proxy105.saveEventsXml(Unknown Source)
>>>         at
>>> org.hisp.dhis.dxf2.events.event.ImportEventTask.run(ImportEventTask.j
>>> ava:86)
>>>         at
>>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
>>> e.run(DelegatingErrorHandlingRunnable.java:53)
>>>         at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
>>> 1)
>>>         at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>>         at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
>>> access$201(ScheduledThreadPoolExecutor.java:178)
>>>         at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
>>> run(ScheduledThreadPoolExecutor.java:292)
>>>         at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
>>> java:1145)
>>>         at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
>>> .java:615)
>>>         at java.lang.Thread.run(Thread.java:744)
>>> * ERROR 2014-01-26 19:13:43,610 Unexpected error occurred in scheduled
>>> task. (Ta
>>> skUtils.java [taskScheduler-1])
>>> org.springframework.transaction.UnexpectedRollbackException: Transaction
>>> rolled
>>> back because it has been marked as rollback-only
>>>         at
>>> org.springframework.transaction.support.AbstractPlatformTransactionMa
>>> nager.commit(AbstractPlatformTransactionManager.java:718)
>>>         at
>>> org.springframework.transaction.interceptor.TransactionAspectSupport.
>>> completeTransactionAfterThrowing(TransactionAspectSupport.java:513)
>>>         at
>>> org.springframework.transaction.interceptor.TransactionAspectSupport.
>>> invokeWithinTransaction(TransactionAspectSupport.java:264)
>>>         at
>>> org.springframework.transaction.interceptor.TransactionInterceptor.in
>>> voke(TransactionInterceptor.java:94)
>>>         at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
>>> ReflectiveMethodInvocation.java:172)
>>>         at
>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
>>> cAopProxy.java:204)
>>>         at com.sun.proxy.$Proxy105.saveEventsXml(Unknown Source)
>>>         at
>>> org.hisp.dhis.dxf2.events.event.ImportEventTask.run(ImportEventTask.j
>>> ava:86)
>>>         at
>>> org.springframework.scheduling.support.DelegatingErrorHandlingRunnabl
>>> e.run(DelegatingErrorHandlingRunnable.java:53)
>>>         at
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:47
>>> 1)
>>>         at java.util.concurrent.FutureTask.run(FutureTask.java:262)
>>>         at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
>>> access$201(ScheduledThreadPoolExecutor.java:178)
>>>         at
>>> java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
>>> run(ScheduledThreadPoolExecutor.java:292)
>>>         at
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.
>>> java:1145)
>>>         at
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
>>> .java:615)
>>>         at java.lang.Thread.run(Thread.java:744)
>>>
>>>
>>>
>>>
>>>
>>> On Sun, Jan 26, 2014 at 11:55 AM, Morten Olav Hansen <mortenoh@xxxxxxxxx
>>> > wrote:
>>>
>>>> That seems very old... can you try this direct link:
>>>>
>>>> http://apps.dhis2.org/ci/job/dhis-2.13/lastSuccessfulBuild/artifact/dhis-2/dhis-web/dhis-web-portal/target/dhis.war
>>>>
>>>> This was built today
>>>>
>>>> --
>>>> Morten
>>>>
>>>>
>>>> On Sun, Jan 26, 2014 at 5:48 PM, Jose Garcia Muñoz <josemp10@xxxxxxxxx>wrote:
>>>>
>>>>>
>>>>> Hi Morten, I have just donwloaded the war file again. The revision is
>>>>> 12947. And the date 2014-01-20 21:20
>>>>>
>>>>> So maybe the war file I am downloading is not updated yet?
>>>>>
>>>>>
>>>>> On Sun, Jan 26, 2014 at 4:59 AM, Morten Olav Hansen <
>>>>> mortenoh@xxxxxxxxx> wrote:
>>>>>
>>>>>> Which revision?
>>>>>> On Jan 26, 2014 2:46 AM, "Jose Garcia Muñoz" <josemp10@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>>
>>>>>>> Hi Morten,
>>>>>>>
>>>>>>> I downloaded the 2.13 war version this Saturday at 13.30 (Oslo
>>>>>>> time). Unfortunately I´ve got the same results than before. I have also
>>>>>>> tested the demo with same results as well.
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Jan 24, 2014 at 5:48 AM, Morten Olav Hansen <
>>>>>>> mortenoh@xxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> Please give our servers a bit of time to compile.. then download
>>>>>>>> and try again. It should work now.
>>>>>>>>
>>>>>>>> --
>>>>>>>> Morten
>>>>>>>>
>>>>>>>>
>>>>>>>> On Thu, Jan 23, 2014 at 1:38 AM, Jose Garcia Muñoz <
>>>>>>>> josemp10@xxxxxxxxx> wrote:
>>>>>>>>
>>>>>>>>>
>>>>>>>>> Hi Morten,
>>>>>>>>>
>>>>>>>>> Still, it is not working. I have tried with the demo version and
>>>>>>>>> with the war file (2.13 version) that I downloaded at 19:30 Oslo time
>>>>>>>>> (Wednesday).
>>>>>>>>>
>>>>>>>>> Yep, with cURL you are not going to get any error, but if you send
>>>>>>>>> a list of events the system is only going to store the last one. You can do
>>>>>>>>> the test with the file previously attached (eventsList.xml) that shoud
>>>>>>>>> introduce 5 events in the OrgUnit "Njandama MCHP".
>>>>>>>>>
>>>>>>>>> Many thanks for your time
>>>>>>>>> Jose
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Jan 22, 2014 at 10:29 AM, Morten Olav Hansen <
>>>>>>>>> mortenoh@xxxxxxxxx> wrote:
>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> I have fixed this issue now, the problem was that it defaulted to
>>>>>>>>>> JSON format.. and there was no way to change it. Now the UI allows you to
>>>>>>>>>> select the format (default XML), and do the import. I tested it with 10
>>>>>>>>>> events now, and it was working fine.
>>>>>>>>>>
>>>>>>>>>> Could you try it again? I will backport to 2.13, 2.14, and our
>>>>>>>>>> download server should be updated in a couple of hours.
>>>>>>>>>>
>>>>>>>>>> I had no problem when I used cURL though...
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Morten
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Tue, Jan 21, 2014 at 7:30 PM, Jose Garcia Muñoz <
>>>>>>>>>> josemp10@xxxxxxxxx> wrote:
>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Dear all,
>>>>>>>>>>>
>>>>>>>>>>> From PSI, we need to automatically introduce into DHIS2
>>>>>>>>>>> thousands of single events without registration, so we would like to use
>>>>>>>>>>> the Event Data Import service of DHIS2. However, it seems that that
>>>>>>>>>>> funcionality was not really working as nothing was happening in the system,
>>>>>>>>>>> although I did not receive any error message in the Catalina.out:
>>>>>>>>>>>
>>>>>>>>>>> INFO  2014-01-20 21:42:22,909 [Level: INFO, category: EVENT_IMPORT, time: Mon Jan 20 21:42:22 UTC 2014, message: Importing events] (InMemoryNotifier.java [taskScheduler-8])
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> I tried to replicate the same problem in the Sierra Leone Demo
>>>>>>>>>>> instance, so first at all I used the Event Data Export to get one xml
>>>>>>>>>>> example of the program "Inpatient Morbidity and Mortality" under the
>>>>>>>>>>> OrgUnit "Njandama MCHP", I edited the xml file and when I tried to import
>>>>>>>>>>> it, again, nothing happened.  Please find attached in this email a copy of
>>>>>>>>>>> that file (named as events.xml), as maybe I am missing something...
>>>>>>>>>>>
>>>>>>>>>>> However, when if  I use the curl utility to call the API:( curl
>>>>>>>>>>> -d @events.xml "http://apps.dhis2.org/demo/api/events"; -H
>>>>>>>>>>> "Content-Type:application/xml" -u admin:district -v ) the event
>>>>>>>>>>> is correctly stored in the database.
>>>>>>>>>>>
>>>>>>>>>>> BUT, if we have several events in the same file, as in the
>>>>>>>>>>> attached file eventsList.xml, it seems that the API only is storing the
>>>>>>>>>>> last event.
>>>>>>>>>>>
>>>>>>>>>>> Any ideas?
>>>>>>>>>>>
>>>>>>>>>>> We are using the 2.13 version till the end of March, so it would
>>>>>>>>>>> be nice if you could look for a solution in the 2.13 version as well :).
>>>>>>>>>>>
>>>>>>>>>>> Many thanks
>>>>>>>>>>> Jose
>>>>>>>>>>>
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>
>>>>
>>>
>>
>