[Dhis2-devs] [Bug 1214305] [NEW] error 503 when copying same file from one pc over to antoher

Support - Assistance technique
1

Hi Ignac,

I found a section in your log which may be the cause of your problems, however, I’m not sure how exactly, so I am copying to the DHIS users list, as that’s usually the best place to get help.

Knut

  • INFO 10:35:23,391 Verified import file (DefaultDhis14FileImportService.java [Thread-17])

  • INFO 10:35:23,733 Imported DataElements (DefaultDhis14FileImportService.java [Thread-17])

  • ERROR 10:35:23,868 Internal process failed (AbstractStatementInternalProcess.java [Thread-17])

java.lang.RuntimeException: Query with RowHandler failed

at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:150)

at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:130)

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.ReflectiveMethodInvocation.invokeJoinpoint(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.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy130.queryWithRowhandler(Unknown Source)

at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importIndicatorTypes(DefaultDhis14FileImportService.java:345)

at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:267)

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: General error

at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.SQLAllocConnect(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.allocConnection(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:571)

at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:213)

at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)

at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)

at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithRowHandler(GeneralStatement.java:133)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryWithRowHandler(SqlMapExecutorDelegate.java:644)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryWithRowHandler(SqlMapSessionImpl.java:121)

at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryWithRowHandler(SqlMapClientImpl.java:98)

at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:142)

... 21 more

  • INFO 10:35:39,468 Internal process started (AbstractStatementInternalProcess.java [Thread-18])

  • INFO 10:35:39,933 Verified import file (DefaultDhis14FileImportService.java [Thread-18])

···

On Tue, Aug 20, 2013 at 3:11 PM, Ignac Mare ignac.mare@gmail.com wrote:

As requested the log for the system

Thanks Knut

Ignac Mare

Radio Technical Services/

Information Management

Limpopo Emergency Medical Services

Tel: 082 313 5588

Fax: 086 614 2028

–
Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org

2

Dunno about this one. Lars probably has a better idea. Have you resolved all data integrity violations in your 1.4 database?

There are a number of posts on the archives about importing data from 1.4, so you may want to review these as well.

Best regards,

Jason

···

On Tue, Aug 20, 2013 at 3:50 PM, Knut Staring knutst@gmail.com wrote:

Hi Ignac,

I found a section in your log which may be the cause of your problems, however, I’m not sure how exactly, so I am copying to the DHIS users list, as that’s usually the best place to get help.

Knut

  • INFO 10:35:23,391 Verified import file (DefaultDhis14FileImportService.java [Thread-17])
  • INFO 10:35:23,733 Imported DataElements (DefaultDhis14FileImportService.java [Thread-17])
  • ERROR 10:35:23,868 Internal process failed (AbstractStatementInternalProcess.java [Thread-17])

java.lang.RuntimeException: Query with RowHandler failed

at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:150)

at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:130)

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.ReflectiveMethodInvocation.invokeJoinpoint(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.invoke(TransactionInterceptor.java:94)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)

at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)

at com.sun.proxy.$Proxy130.queryWithRowhandler(Unknown Source)

at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importIndicatorTypes(DefaultDhis14FileImportService.java:345)

at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:267)

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: General error

at sun.jdbc.odbc.JdbcOdbc.throwGenericSQLException(Unknown Source)

at sun.jdbc.odbc.JdbcOdbc.SQLAllocConnect(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.allocConnection(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source)

at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at java.sql.DriverManager.getConnection(Unknown Source)

at com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:571)

at com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:213)

at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48)

at com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89)

at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithRowHandler(GeneralStatement.java:133)

at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryWithRowHandler(SqlMapExecutorDelegate.java:644)

at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryWithRowHandler(SqlMapSessionImpl.java:121)

at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryWithRowHandler(SqlMapClientImpl.java:98)

at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:142)

… 21 more

  • INFO 10:35:39,468 Internal process started (AbstractStatementInternalProcess.java [Thread-18])
  • INFO 10:35:39,933 Verified import file (DefaultDhis14FileImportService.java [Thread-18])

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

On Tue, Aug 20, 2013 at 3:11 PM, Ignac Mare ignac.mare@gmail.com wrote:

As requested the log for the system

Thanks Knut

Ignac Mare

Radio Technical Services/

Information Management

Limpopo Emergency Medical Services

Tel: 082 313 5588

Fax: 086 614 2028

–
Knut Staring

Dept. of Informatics, University of Oslo

+4791880522

http://dhis2.org