dhis2-devs team mailing list archive

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

Hi again,
I had sent a message to the group earlier regarding importation of
data from a legacy source by DXF. Previously, I have used direct
inserts into the DHIS2 database, but because of the nature of this
data source, I want to try and use DXF. I am having problems however,
and could use some pointers.

The DXF file is here (382kB)

http://dl.dropbox.com/u/11802917/test_dxf_export8.7z


Basically, everything runs smoothly, up until the last stage when the
data values are to be imported.. When I get the error message posted
at the end of the mail.

If I import the same DXF without the <dataValues> block, it imports
just fine. I really cannot decipher the log message however to
determine what the exact problem is. Any help appreciated.

Thanks,
Jason




* INFO  08:08:50,741 Content-type: text/plain, filename: C:\Users\jason\AppData\
Local\Temp\Jetty_0_0_0_0_8888_dhis____.al3jm9\upload__59f6bd88_12d30795f48__8000
_00000026.tmp (ImportAction.java [2779391@qtp-1027049-15])
* INFO  08:08:50,782 Internal process started (AbstractStatementInternalProcess.
java [Thread-32])
* INFO  08:08:50,782 Importing stream (DefaultImportService.java [Thread-32])
* INFO  08:08:50,784 Importing DXF native stream (DefaultImportService.java [Thr
ead-32])
* INFO  08:08:50,791 Deleted previewed objects (DXFConverter.java [Thread-32])
* WARN  08:08:50,836 Resource Leaking:  Could not remove uploaded file 'C:\Users
\jason\AppData\Local\Temp\Jetty_0_0_0_0_8888_dhis____.al3jm9\upload__59f6bd88_12
d30795f48__8000_00000026.tmp'. (CommonsLogger.java [2779391@qtp-1027049-15])
* INFO  08:08:50,857 Imported DataElementCategoryOptions (DXFConverter.java [Thr
ead-32])
* INFO  08:08:50,907 Imported DataElementCategories (DXFConverter.java [Thread-3
2])
* INFO  08:08:50,956 Imported DataElementCategoryCombos (DXFConverter.java [Thre
ad-32])
* INFO  08:08:51,054 Imported DataElementCategoryOptionCombos (DXFConverter.java
 [Thread-32])
* INFO  08:08:51,195 Imported CategoryCategoryOption associations (DXFConverter.
java [Thread-32])
* INFO  08:08:51,308 Imported CategoryComboCategory associations (DXFConverter.j
ava [Thread-32])
* INFO  08:08:52,568 Imported DataElements (DXFConverter.java [Thread-32])
* INFO  08:22:23,426 Imported OrganisationUnits (DXFConverter.java [Thread-32])
* INFO  08:22:40,145 Imported OrganisationUnit relationships (DXFConverter.java
[Thread-32])
* INFO  08:22:40,466 Imported OrganisationUnitGroups (DXFConverter.java [Thread-
32])
* INFO  08:23:54,931 Imported OrganisationUnitGroup members (DXFConverter.java [
Thread-32])
* INFO  08:23:55,005 Imported OrganisationUnitGroupSets (DXFConverter.java [Thre
ad-32])
* INFO  08:23:55,175 Imported OrganisationUnitGroupSet members (DXFConverter.jav
a [Thread-32])
* INFO  08:23:55,255 Imported OrganisationUnitLevels (DXFConverter.java [Thread-
32])
* ERROR 08:23:55,419 Internal process failed (AbstractStatementInternalProcess.j
ava [Thread-32])
java.lang.NumberFormatException: null
        at java.lang.Integer.parseInt(Integer.java:417)
        at java.lang.Integer.parseInt(Integer.java:499)
        at org.hisp.dhis.importexport.dxf.converter.DataValueConverter.read(Data
ValueConverter.java:195)
        at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
(DefaultConverterInvoker.java:45)
        at sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:202)
        at $Proxy49.invokeRead(Unknown Source)
        at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
er.java:968)
        at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
ortService.java:185)
        at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
portInternalProcess.java:89)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:91)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:40)
        at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
25)
        at java.lang.Thread.run(Thread.java:662)
java.lang.NumberFormatException: null
        at java.lang.Integer.parseInt(Integer.java:417)
        at java.lang.Integer.parseInt(Integer.java:499)
        at org.hisp.dhis.importexport.dxf.converter.DataValueConverter.read(Data
ValueConverter.java:195)
        at org.hisp.dhis.importexport.invoker.DefaultConverterInvoker.invokeRead
(DefaultConverterInvoker.java:45)
        at sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflecti
on(AopUtils.java:309)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJo
inpoint(ReflectiveMethodInvocation.java:183)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
        at org.springframework.transaction.interceptor.TransactionInterceptor.in
voke(TransactionInterceptor.java:110)
        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynami
cAopProxy.java:202)
        at $Proxy49.invokeRead(Unknown Source)
        at org.hisp.dhis.importexport.dxf.converter.DXFConverter.read(DXFConvert
er.java:968)
        at org.hisp.dhis.importexport.DefaultImportService.importData(DefaultImp
ortService.java:185)
        at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(Im
portInternalProcess.java:89)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:91)
        at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute
(AbstractStatementInternalProcess.java:40)
        at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:1
25)
        at java.lang.Thread.run(Thread.java:662)
Dec 29, 2010 8:23:57 AM org.apache.velocity.runtime.log.JdkLogChute log
SEVERE: Left side ($status) of '==' operation has null value. If a reference, it
 may not be in the context. Operation not possible. /dhis-web-importexport/previ
ewForm.vm [line 92, column 157]
Dec 29, 2010 8:23:57 AM org.apache.velocity.runtime.log.JdkLogChute log
SEVERE: Left side ($status) of '==' operation has null value. If a reference, it
 may not be in the context. Operation not possible. /dhis-web-importexport/previ
ewForm.vm [line 93, column 161]



Current user:
    admin
Version:
    2.0.5
Build revision:
    2095
Build date:
    2010-11-25 10:47
User agent:
    Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.2.13)
Gecko/20101203 Firefox/3.6.13
External configuration directory:
    C:\Program Files\DHIS2-2.0.5\conf
Environment variable:
    DHIS2_HOME
Database type:
    PostgreSQL
Database name:
    harvard
Database user:
    postgres
Java Opts:
Java version:
    1.6.0_22
Java vendor:
    Sun Microsystems Inc.
OS name:
    Windows 7
OS architecture:
    x86
OS version:
    6.1
-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260968395190