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 <larshe...@gmail.com>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 <fmut...@gmail.com> 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@lists.launchpad.net >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > -- Farai Mutero
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp