dhis2-devs team mailing list archive

[Farai Mutero <fmutero@xxxxxxxxx>]

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