Error when importing DHIS1.4 data file.

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

Hi Faria,

Have you resolved all data integrity violations on your 1.4 database?

Regards,

Jason

···

On Fri, Jul 19, 2013 at 3:57 PM, Farai Mutero fmutero@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

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

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


Farai Mutero

On Fri, Jul 19, 2013 at 3:57 PM, Farai Mutero fmutero@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

Great.

···

On Mon, Jul 22, 2013 at 10:05 AM, Farai Mutero fmutero@gmail.com 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@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


Farai Mutero

On Fri, Jul 19, 2013 at 3:57 PM, Farai Mutero fmutero@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