dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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@xxxxxxxxx> 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])
>
>
> 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
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>