dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Great.


On Mon, Jul 22, 2013 at 10:05 AM, Farai Mutero <fmutero@xxxxxxxxx> wrote:

> Wow, thank you so much Lars. Will import a couple of DHIS 1.4 data files
> and let you know how it goes.
>
> Thanks Jason for the input.
>
>
> On Fri, Jul 19, 2013 at 7:47 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>
>> Hi Farai,
>>
>> I think I have found and fixed the bug in trunk and 2.12 in r 11453.
>>
>> You can get it from dhis2.org/downloads in 30 min or build the source
>> yourself.
>>
>> Let us know if this fixes your problem.
>>
>> Lars
>>
>>
>>
>> On Fri, Jul 19, 2013 at 3:57 PM, Farai Mutero <fmutero@xxxxxxxxx> wrote:
>>
>>> Current user:admin Version:2.13-SNAPSHOT Build revision:11315 Build
>>> date:2013-07-03 05:02
>>>
>>> Hi All
>>>
>>> I'm importing a DHIS1.4 data file into DHIS2 and I'm getting the
>>> following error in my log file. Any idea what might be causing the error.
>>> Please see my log file details below :
>>>
>>> * INFO  15:25:40,813 All startup routines done
>>> (DefaultStartupRoutineExecutor.java [Thread-2])
>>> * INFO  15:25:53,436 Lifecycle: server started (TrayApp.java [Thread-2])
>>> * INFO  15:26:43,808 Login success for user: 'admin', ip:
>>> '0:0:0:0:0:0:0:1' (DefaultUserAuditService.java [8790081@qtp-18379432-0
>>> ])
>>> * INFO  15:27:46,273 Internal process started
>>> (AbstractStatementInternalProcess.java [Thread-20])
>>> * ERROR 15:28:11,581 Internal process failed
>>> (AbstractStatementInternalProcess.java [Thread-20])
>>> java.lang.RuntimeException: Query for Object failed
>>>  at
>>> org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryForObject(IbatisQueryManager.java:79)
>>> 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.invokeJoinpointUsingReflection(AopUtils.java:317)
>>>  at
>>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
>>> at $Proxy130.queryForObject(Unknown Source)
>>>  at
>>> org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.verifyImportFile(DefaultDhis14FileImportService.java:788)
>>> at
>>> org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:256)
>>>  at
>>> org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:89)
>>> at
>>> org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:103)
>>>  at
>>> org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:40)
>>> at
>>> org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
>>>  at java.lang.Thread.run(Unknown Source)
>>> Caused by: java.sql.SQLException: Error: executeQueryForObject returned
>>> too many results.
>>> at
>>> com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForObject(GeneralStatement.java:108)
>>>  at
>>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:561)
>>> at
>>> com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForObject(SqlMapExecutorDelegate.java:536)
>>>  at
>>> com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForObject(SqlMapSessionImpl.java:93)
>>> at
>>> com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForObject(SqlMapClientImpl.java:70)
>>>  at
>>> org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryForObject(IbatisQueryManager.java:69)
>>> ... 14 more
>>>
>>> Regards
>>>
>>> --
>>> Farai Mutero
>>>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>
>
> --
> Farai Mutero
>
>