dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

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