dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #03762
Re: Event Data Import not working properly?
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
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>
>>
>
Follow ups
References