dhis2-users team mailing list archive

[Jose Garcia Muñoz <josemp10@xxxxxxxxx>]

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