[Dhis-dev] Export process from 1.4 to 2.0

Support - Assistance technique
1

Hi Lars,
Thanks for this.
I opted for the first option. Here is the result.

Exception (java.lang.RuntimeException): Failed to set configuration

    * org.hisp.dhis.importexport.dhis14.file.configuration.DefaultIbatisConfigurationManager.setIbatisConfiguration(DefaultIbatisConfigurationManager.java:142)
    * org.hisp.dhis.importexport.action.dhis14.SetDhis14ConfigurationAction.execute(SetDhis14ConfigurationAction.java:99)
    * sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
    * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
    * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
    * java.lang.reflect.Method.invoke(Unknown source)
    * com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
    * com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
    * com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
    * com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
    * org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    * org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
    * org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
    * org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    * org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    * org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    * org.hisp.dhis.servlet.filter.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:71)
    * org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    * org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    * org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    * org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    * org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    * org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    * org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    * org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    * org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    * org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    * org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    * org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    * org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    * java.lang.Thread.run(Unknown source)

[-] Caused by (org.hisp.dhis.external.location.LocationManagerException):
External directory not set

    * org.hisp.dhis.external.location.DefaultLocationManager.getFileForWriting(DefaultLocationManager.java:195)
    * org.hisp.dhis.external.location.DefaultLocationManager.getOutputStream(DefaultLocationManager.java:166)
    * org.hisp.dhis.importexport.dhis14.file.configuration.DefaultIbatisConfigurationManager.setIbatisConfiguration(DefaultIbatisConfigurationManager.java:136)
    * org.hisp.dhis.importexport.action.dhis14.SetDhis14ConfigurationAction.execute(SetDhis14ConfigurationAction.java:99)
    * sun.reflect.NativeMethodAccessorImpl.invoke0(Unknown source)
    * sun.reflect.NativeMethodAccessorImpl.invoke(Unknown source)
    * sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown source)
    * java.lang.reflect.Method.invoke(Unknown source)
    * com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:358)
    * com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:218)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:192)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.webwork.interceptor.WebWorkDisplayPropertyInterceptor.intercept(WebWorkDisplayPropertyInterceptor.java:90)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.webwork.interceptor.WebWorkSortOrderInterceptor.intercept(WebWorkSortOrderInterceptor.java:124)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.security.intercept.WebWorkSecurityInterceptor.intercept(WebWorkSecurityInterceptor.java:98)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * org.hisp.dhis.webwork.interceptor.WebWorkExceptionInterceptor.intercept(WebWorkExceptionInterceptor.java:89)
    * com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:190)
    * com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116)
    * com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:273)
    * com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:202)
    * org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    * org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
    * org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.java:131)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:107)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:108)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:193)
    * org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
    * org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
    * org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
    * org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    * org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    * org.hisp.dhis.servlet.filter.OpenSessionInViewFilter.doFilter(OpenSessionInViewFilter.java:71)
    * org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236)
    * org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    * org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    * org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    * org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    * org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    * org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    * org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    * org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    * org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    * org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    * org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    * org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    * java.lang.Thread.run(Unknown source)

Here are the details of the system..

Current user:
    admin
Version:
    2.0.1-SNAPSHOT
Build date:
    2009-03-03 17:07
User agent:
    Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6)
Gecko/2009011913 Firefox/3.0.6
External configuration directory:
    Not set
Environment variable:
    DHIS2_HOME
Database type:
    H2
Database name:
    dhis2
Database user:
    sa

I do not have a real database setup yet. I am thinking that this may
have to do with the lack of an external configuration directory.

Let me try and set it, but I assume that there should be a more
graceful error returned. :slight_smile:

Regards,
Jason

···

---------- Forwarded message ----------
From: Lars Helge Øverland <larshelge@gmail.com>
Date: Sun, Mar 8, 2009 at 9:16 AM
Subject: Re: [Dhis-dev] Export process from 1.4 to 2.0
To: dhis-dev@hisp.info

Instructions on moving data from DHIS 1.4 to 2.0
---------------------------------------------------------------

There are two approaches:

1) Import from DHIS 1.4 data file

This step requires that you are running Windows and that the relevant
data file is on your computer.

- In DHIS 2.0 go to "DHIS 1.4 File Configuration", enter the path to
the 1.4 data file (eg C:\Dhis14\DHIS_#ZA_LIMPOPO.mdb) and the other
options if necessary.
- In "DHIS 1.4 File Import" click Import.

2) Import from DHIS 1.4 XML file (.zip format)

- Make sure you are running DHIS 1.4 build 112 or later.

- When exporting data from DHIS 1.4, make sure you select DHIS 2 as
export file format.
- When exporting meta data (Advanced export), make sure you select
"Zip archive" as type after clicking "Export".

Make sure that the export file you get is of type ".zip" as this is
the accepted format in DHIS 2.

- In DHIS 2.0, go to "DHIS 1.4 XML Import", select your export file
and click "Import".

Lars

2

Here are the details of the system…

Current user:

admin

Version:

2.0.1-SNAPSHOT

Build date:

2009-03-03 17:07

User agent:

Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6)

Gecko/2009011913 Firefox/3.0.6

External configuration directory:

Not set

Environment variable:

DHIS2_HOME

Database type:

H2

Database name:

dhis2

Database user:

sa

I do not have a real database setup yet. I am thinking that this may

have to do with the lack of an external configuration directory.

Let me try and set it, but I assume that there should be a more

graceful error returned. :slight_smile:

Regards,

Jason

Hi Jason,

you need to install DHIS 2 properly:

  • Set the DHIS2_HOME environment variable to any folder. In this folder the system will create a subfolder called “importexport” where the dhis14 import config file will be stored.

  • Also set up a database, your system is now running on the default H2 in-memory database. Install postgresql/mysql, put the attached hibernate.properties in the DHIS2_HOME directory and modify it to your db setup.

You could also set the “import type” to analysis to reveal problems in the DHIS 1.4 datafile related to unique field/foreign key contraints (access is more lenient that postgres/mysql).

Then try again, let me know if it works.

Lars

hibernate.properties (576 Bytes)

3

Hi Lars,
I have made the required changes to DHIS, and now it reports using the
Postgreql backend.

About DHIS 2

Current user:
    admin
Version:
    2.0.1-SNAPSHOT
Build date:
    2009-03-03 17:07
User agent:
    Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6)
Gecko/2009011913 Firefox/3.0.6
External configuration directory:
    c:\dhis2
Environment variable:
    DHIS2_HOME
Database type:
    PostgreSQL
Database name:
    dhis2_zm
Database user:
    dhis

I have tried method (1) on a clean database and obtain the following
errors (from the Tomcat log)

* INFO 14:04:16,440 Environment variable DHIS2_HOME points to
c:\dhis2 (DefaultLocationManager.java [Thread-1])
* INFO 14:04:18,643 Hibernate properties file found:
jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webapps/dhis/WEB-INF/lib/dhis-support-hibernate-2.0.1-SNAPSHOT.jar!/hibernate-default.properties
(DefaultHibernateConfigurationProvider.java [Thread-1])
* INFO 14:04:18,643 Hibernate properties file found:
jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webapps/dhis/WEB-INF/lib/dhis-web-maintenance-dataadmin.jar!/hibernate.properties
(DefaultHibernateConfigurationProvider.java [Thread-1])
* INFO 14:04:18,658 Hibernate properties file found:
c:\dhis2\hibernate.properties
(DefaultHibernateConfigurationProvider.java [Thread-1])
* INFO 14:04:42,969 Executing startup routine [1 of 11, runlevel 0]:
DataElementDefaultDimensionPopulator
(DefaultStartupRoutineExecutor.java [Thread-1])
* INFO 14:04:59,093 Added default dataelement dimension
(DataElementDefaultDimensionPopulator.java [Thread-1])
* INFO 14:04:59,125 Executing startup routine [2 of 11, runlevel 0]:
DataSetShortNamePopulator (DefaultStartupRoutineExecutor.java
[Thread-1])
* INFO 14:04:59,140 Populated DataSet short name and code
(DataSetShortNamePopulator.java [Thread-1])
* INFO 14:04:59,140 Executing startup routine [3 of 11, runlevel 0]:
CategoryOptionShortNamePopulator (DefaultStartupRoutineExecutor.java
[Thread-1])
* INFO 14:04:59,218 Populated CategoryOption shortname
(CategoryOptionShortNamePopulator.java [Thread-1])
* INFO 14:04:59,218 Executing startup routine [4 of 11, runlevel 0]:
OrganisationUnitHierarchyVerifier (DefaultStartupRoutineExecutor.java
[Thread-1])
* WARN 14:04:59,546 firstResult/maxResults specified with collection
fetch; applying in memory! (QueryTranslatorImpl.java [Thread-1])
* INFO 14:04:59,578 Added organistion unit hierarchy
(OrganisationUnitHierarchyVerifier.java [Thread-1])
* INFO 14:04:59,578 Executing startup routine [5 of 11, runlevel 0]:
OpenHealthDataSourceWriter (DefaultStartupRoutineExecutor.java
[Thread-1])
* INFO 14:04:59,578 Environment variable OPENHEALTH_HOME not set
(OpenHealthDataSourceWriter.java [Thread-1])
* INFO 14:04:59,578 Executing startup routine [6 of 11, runlevel 0]:
ReportTableUpgrader (DefaultStartupRoutineExecutor.java [Thread-1])
* INFO 14:04:59,593 Upgraded report tables (ReportTableUpgrader.java
[Thread-1])
* INFO 14:04:59,593 Executing startup routine [7 of 11, runlevel 1]:
PeriodTypePopulator (DefaultStartupRoutineExecutor.java [Thread-1])
* INFO 14:04:59,625 Executing startup routine [8 of 11, runlevel 2]:
MultiDimensionExpressionUpgrader (DefaultStartupRoutineExecutor.java
[Thread-1])
* INFO 14:04:59,656 Executing startup routine [9 of 11, runlevel 3]:
AggregationTableCreator (DefaultStartupRoutineExecutor.java
[Thread-1])
* INFO 14:04:59,750 Created table aggregateddatavalue
(AggregationTableCreator.java [Thread-1])
* INFO 14:04:59,750 Created table aggregatedindicatorvalue
(AggregationTableCreator.java [Thread-1])
* INFO 14:04:59,828 Created index crosstab on table datavalue
(AggregationTableCreator.java [Thread-1])
* INFO 14:04:59,843 Created table aggregateddatasetcompleteness
(AggregationTableCreator.java [Thread-1])
* INFO 14:04:59,843 Executing startup routine [10 of 11, runlevel 3]:
DataElementCategoryOptionComboStartupRoutine
(DefaultStartupRoutineExecutor.java [Thread-1])
* INFO 14:04:59,906 Verified CategoryOptionCombos
(DataElementCategoryOptionComboStartupRoutine.java [Thread-1])
* INFO 14:04:59,906 Executing startup routine [11 of 11, runlevel
10]: I18nUpgrader (DefaultStartupRoutineExecutor.java [Thread-1])
* INFO 14:05:00,125 I18n Upgrader running using locale engelska
(Storbritannien) (I18nUpgrader.java [Thread-1])
* INFO 14:05:00,187 I81n Upgrader: DataElementCategory (1)
(I18nUpgrader.java [Thread-1])
* INFO 14:05:00,203 I81n Upgrader: DataElementCategoryOption (1)
(I18nUpgrader.java [Thread-1])
* INFO 14:05:00,218 I81n Upgrader: DataElementCategoryCombo (1)
(I18nUpgrader.java [Thread-1])
* INFO 14:05:00,218 All startup routines done
(DefaultStartupRoutineExecutor.java [Thread-1])
* INFO 14:05:02,765 Reading datasource config file from
datasources.xml,
file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%206.0/webapps/openhealth-fp/WEB-INF/classes/datasources.xml
(MondrianOlapQueryProcessor.java [Thread-1])
* INFO 14:05:02,999 xmla output: '<Discover
xmlns="urn:schemas-microsoft-com:xml-analysis">
<RequestType>MDSCHEMA_DIMENSIONS</RequestType>
<Restrictions>
  <RestrictionList>
    <CATALOG_NAME>OpenHealth</CATALOG_NAME>
    <CUBE_NAME>Diseases</CUBE_NAME>
      </RestrictionList>
</Restrictions>
<Properties>
  <PropertyList>
    <DataSourceInfo>OpenHealthData</DataSourceInfo>
    <Catalog>OpenHealth</Catalog>
    <Format>Tabular</Format>
    <Content>SchemaData</Content>
  </PropertyList>
</Properties>
</Discover>
' (MondrianOlapQueryProcessor.java [Thread-1])
17 mar 14:05:12 ERROR [geoserver.global] -
<omitting Geoserver startup messages>

* INFO 14:06:48,946 Imported DataElements
(DefaultDhis14FileImportService.java [Thread-16])
* WARN 14:06:52,837 Value is null for key: '908' (LoggingHashMap.java
[Thread-16])
* ERROR 14:06:52,837 The process threw exception (ProcessExecutor.java
[Thread-16])
java.lang.RuntimeException: Query with RowHandler failed
  at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:141)
  at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:124)
  at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importCalculatedDataElements(DefaultDhis14FileImportService.java:346)
  at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:257)
  at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:84)
  at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:85)
  at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:37)
  at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:126)
  at java.lang.Thread.run(Unknown Source)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/calculatedDataElement.sqlmap.xml.
--- The error occurred while applying a result map.
--- Check the calculatedDataElement.calculatedDataElementResultMap.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)
  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:135)
  ... 8 more
Caused by: java.lang.NullPointerException
  at org.hisp.dhis.expression.DefaultExpressionService.convertExpression(DefaultExpressionService.java:187)
  at sun.reflect.GeneratedMethodAccessor199.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:307)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
  at $Proxy35.convertExpression(Unknown Source)
  at org.hisp.dhis.importexport.dhis14.file.rowhandler.CalculatedDataElementRowHandler.handleRow(CalculatedDataElementRowHandler.java:115)
  at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:76)
  at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:395)
  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
  ... 13 more

I would assume this would be caused by the fact I am using a
completely new database.

So essentially, I would like to perform a completely clean
installation from 1.4 to 2.0. We will need to do this on a regular
basis, as 2.0 (at least for the time being in Zambia) will only be
used for reporting and analysis. No data will be entered or modified.
Each quarter, a new import from the master 1.4 database will need to
take place.

Thanks in advance for your help.

I will attempt the second procedure now,and see what happens .

Best regards,
Jason

···

On Wed, Mar 11, 2009 at 12:40 PM, Lars Helge Øverland <larshelge@gmail.com> wrote:

Here are the details of the system..

Current user:
admin
Version:
2.0.1-SNAPSHOT
Build date:
2009-03-03 17:07
User agent:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.6)
Gecko/2009011913 Firefox/3.0.6
External configuration directory:
Not set
Environment variable:
DHIS2_HOME
Database type:
H2
Database name:
dhis2
Database user:
sa

I do not have a real database setup yet. I am thinking that this may
have to do with the lack of an external configuration directory.

Let me try and set it, but I assume that there should be a more
graceful error returned. :slight_smile:

Regards,
Jason

Hi Jason,

you need to install DHIS 2 properly:

- Set the DHIS2_HOME environment variable to any folder. In this folder the
system will create a subfolder called "importexport" where the dhis14 import
config file will be stored.

- Also set up a database, your system is now running on the default H2
in-memory database. Install postgresql/mysql, put the attached
hibernate.properties in the DHIS2_HOME directory and modify it to your db
setup.

You could also set the "import type" to analysis to reveal problems in the
DHIS 1.4 datafile related to unique field/foreign key contraints (access is
more lenient that postgres/mysql).

Then try again, let me know if it works.

Lars

4

I would assume this would be caused by the fact I am using a

completely new database.

So essentially, I would like to perform a completely clean

installation from 1.4 to 2.0. We will need to do this on a regular

basis, as 2.0 (at least for the time being in Zambia) will only be

used for reporting and analysis. No data will be entered or modified.

Each quarter, a new import from the master 1.4 database will need to

take place.

Thanks in advance for your help.

I will attempt the second procedure now,and see what happens .

Best regards,

Jason

I had a look in the DHIS 1.4 Zambia database and found a few inconsistencies.

  1. The table “DataElementCalculated” represents the formula for calculated data elements, and there are a few entries that refer to data elements that don’t exist. These can be revealed by opening the table, sort the DataElementCalculatedID column from A-Z and remove the entries with only identifiers/numbers. Existing data elements will be mapped and appear as names. Then do the same for the DataElementID column and remove entries with numbers/identifiers. Ideally this should be included in the data integrity checks in 1.4.

  2. There are a few “EntryNumber” entries in the “RoutineData” table that exceed what the JDBC driver is able to read. Open the “RoutineData” table, sort big->small on “EntryNumber” and remove the 3 highest numbers.

Then try importing again. Should take around 15 minutes.

Lars

5

Hi there,

I had seen these integrity check messages from 1.4 actually, but did
not fix them. I see now that I need to do this. I just wanted to
ensure that a complete "clean" import from 1.4 to 2.0 was actually
possible, and it seems that it is.

2) There are a few "EntryNumber" entries in the "RoutineData" table that
exceed what the JDBC driver is able to read. Open the "RoutineData" table,
sort big->small on "EntryNumber" and remove the 3 highest numbers.

What is the maximum then? I would assume that we would need to do
something to prevent this from happening in the first place.

We have a new version of the DHIS 1.4 Zambia database, that includes
some more historical data (as of last Friday), but I am not sure if
that is the version that you are using. This is part of the problem
here, but that deserves another thread.

Thanks again, and I will revert to the list again if I encounter more issues.

Best regards,
jason

···

2009/3/18 Lars Helge Øverland <larshelge@gmail.com>:

I would assume this would be caused by the fact I am using a
completely new database.

So essentially, I would like to perform a completely clean
installation from 1.4 to 2.0. We will need to do this on a regular
basis, as 2.0 (at least for the time being in Zambia) will only be
used for reporting and analysis. No data will be entered or modified.
Each quarter, a new import from the master 1.4 database will need to
take place.

Thanks in advance for your help.

I will attempt the second procedure now,and see what happens .

Best regards,
Jason

I had a look in the DHIS 1.4 Zambia database and found a few
inconsistencies.

1) The table "DataElementCalculated" represents the formula for calculated
data elements, and there are a few entries that refer to data elements that
don't exist. These can be revealed by opening the table, sort the
DataElementCalculatedID column from A-Z and remove the entries with only
identifiers/numbers. Existing data elements will be mapped and appear as
names. Then do the same for the DataElementID column and remove entries
with numbers/identifiers. Ideally this should be included in the data
integrity checks in 1.4.

2) There are a few "EntryNumber" entries in the "RoutineData" table that
exceed what the JDBC driver is able to read. Open the "RoutineData" table,
sort big->small on "EntryNumber" and remove the 3 highest numbers.

Then try importing again. Should take around 15 minutes.

Lars

6

What is the maximum then? I would assume that we would need to do

something to prevent this from happening in the first place.

Im pretty sure the JDBC driver will map the access “number” type to a java integer, in that case it’s 2^31 = 2 147 483 648

We have a new version of the DHIS 1.4 Zambia database, that includes

some more historical data (as of last Friday), but I am not sure if

that is the version that you are using. This is part of the problem

here, but that deserves another thread.

Thanks again, and I will revert to the list again if I encounter more issues.

Good.

Lars

···
7

Hi Everyone,

I wanted to pick up this thread again, after trying everything that I
can to get the import process from 1.4 to 2.0 to work, but am still
not succeeding.

I have checked a database provided to me by Ola several months ago.
This database contained roughly 3 million records. Since then, there
have been several new imports into the master 1.4 database here in
Zambia. According to DHIS 2, the database that was imported by Ola has
the folliowing characteristics According to DHIS 1.4 the database
contains roughly 3 million records with only 100 or so being
archived.

Data Statistics
Type Number
Data elements 3114
Data element groups 128
Indicator types 6
Indicators 390
Indicator groups 128
Data sets 19
Data dictionaries 0
Organisation units 12729
Validation rules 0
Periods 85
Data values 1646537

The database that I have recently imported (with over 4.5 million
records with 2.2 million that are archived according to DHIS 1.4) has
the following attributes.

Type Number
Data elements 3124
Data element groups 128
Indicator types 6
Indicators 396
Indicator groups 128
Data sets 22
Data dictionaries 0
Organisation units 11484
Validation rules 0
Periods 38
Data values 543599

As you can see, there are significantly fewer data values that have
been imported even though DHIS 1.4 is reporting more data values.

I have been importing directly from the DHIS on a XP machine that has
both systems. I have included a stack trace of an import process
towards the end of this email.

Then try importing again. Should take around 15 minutes.

When Lars tried a few week back, he indicated the process would take
about 15 minutes. In my case, the process is almost instantaneous,
which seems impossible, given the amount of data in the original 1.4
database. I do have a new laptop, but it cannot be that fast, or can
it!!

So, I am asking for any pointers here about how to get all the data
from 1.4 into 2.0. I can of course provide all files to you if you can
assist me, but I have been struggling for several days now, and really
cannot figure out a way forward. It is crucial here in Zambia that we
establish a clear, reliable workflow for the regular importation of
data from 1.4 into 2.0. Any help, would be appreciated.

Best regards,
Jason

Below, stack trace from the import process...

* INFO 16:24:32,484 Imported DataElements
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:36,078 Imported CalculatedDataElements
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:36,375 Imported IndicatorTypes
(DefaultDhis14FileImportService.java [Thread-23])
* WARN 16:24:38,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,890 'Inpatient referral rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:38,890 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:38,890 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Weighing rate under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Weighing rate under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,921 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,921 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,921 'Children with severe malnutrition' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,937 'Diarrhoea nonbloody incidence under 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,937 'Severe Diarrhoea with dehydration incidence
under 5 years' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,937 'Pneumonia incidence under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Vitamin A coverage under 1 year' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Vitamin A coverage 1 to 4 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Vitamin A coverage 1 to 4 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Mebendazole coverage to children 1 to 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Mebendazole coverage to children 1 to 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,984 'DPT Hib Hep 1st dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,984 'DPT Hib Hep 2nd dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,984 'DPT Hib Hep 3rd dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 3 to Measles 1 doses drop out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 3 to Measles 1 doses drop out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,015 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,015 'Cold chain fridge downtime' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,031 'Women year protection rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,031 'Couple year protection rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,062 'Male sterilisation rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,062 'Female sterilisation rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,062 'Cervical cancer screening coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,078 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,078 'Breast cancer screening' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,156 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,156 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,156 'Delivery complications sepsis' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,171 'Delivery complications obstructed labour'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,171 'Delivery complications ruptured uterus' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,171 'Delivery complications retained placenta'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,187 'Delivery Pregnancy complications hypertensive
disorders' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,187 'Delivery Pregnancy complications haemorrhage'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,218 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'STI treated new episode incidence' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'Male urethritis syndrome incidence' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'Genital ulcer treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'Genital warts treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,250 'Inguinal bubo treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,265 'HIV testing rate' contains a non-existing data
element identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,328 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,328 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,328 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,328 'Proportion treatment start among TB smear
positive' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,343 'Proportion new HIV pos patients started INH
preventive therapy' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,343 'Proportion new HIV pos patients started
Cotrimoxazole prophylaxis' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria under 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria over 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria over 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria under 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria over 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria over 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria treatment rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria under 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria over 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria over 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Malaria under 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Malaria over 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Malaria over 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Tracer items stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Tracer items stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,406 'Any 1st line antimalarial stock out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,421 'DPT HepB Hib vaccine stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,437 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,437 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,437 'Proportion vaccine fridges missing or not
working' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,546 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,546 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,546 'Percentage MOH Releases to district level'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,609 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,609 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,625 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,625 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,625 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Vitamin A coverage 1 to 4 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Vitamin A coverage 1 to 4 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Vitamin A coverage under 1 year (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,656 'Utilisation rate PHC Total (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,656 'Utilisation rate PHC Total (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,671 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,671 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,671 'Women year protection rate (annulised)' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,687 'DPT Hib Hep 1st dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,687 'DPT Hib Hep 2nd dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,687 'DPT Hib Hep 3rd dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,703 'Children with severe malnutrition (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,703 'Pneumonia incidence under 5 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,703 'Couple year protection rate (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,718 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,718 'Male sterilisation rate (annualised)' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,718 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,718 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,718 'Female sterilisation rate (annualised)' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,843 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,890 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,890 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:40,140 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:40,140 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:40,140 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:40,156 Key is null (LoggingHashMap.java [Thread-23])
* INFO 16:24:40,187 Imported Indicators
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:40,953 Imported DataElementGroups
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:45,000 Imported DataElementGroup members
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:45,562 Imported IndicatorGroups
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:46,578 Imported IndicatorGroup members
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:47,125 Imported DataSets
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:50,906 Imported DataSet members
(DefaultDhis14FileImportService.java [Thread-23])

8

Hi Jason,

I would need the whole stack trace as the part with the data values comes at the end.

Im happy to help, it would be easier for me if you could upload the DHIS 1.4 database somewhere so I can try on my side.

This might be caused by an aborted import process. I am sorry for the trouble but the problem is that Access is more lenient when it comes to constraints than Postgres/Mysql, so it’s hard to foresee all kinds of situations that can arise.

Lars

···

On Tue, Mar 31, 2009 at 5:05 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Everyone,

I wanted to pick up this thread again, after trying everything that I

can to get the import process from 1.4 to 2.0 to work, but am still

not succeeding.

I have checked a database provided to me by Ola several months ago.

This database contained roughly 3 million records. Since then, there

have been several new imports into the master 1.4 database here in

Zambia. According to DHIS 2, the database that was imported by Ola has

the folliowing characteristics According to DHIS 1.4 the database

contains roughly 3 million records with only 100 or so being

archived.

Data Statistics

Type Number

Data elements 3114

Data element groups 128

Indicator types 6

Indicators 390

Indicator groups 128

Data sets 19

Data dictionaries 0

Organisation units 12729

Validation rules 0

Periods 85

Data values 1646537

The database that I have recently imported (with over 4.5 million

records with 2.2 million that are archived according to DHIS 1.4) has

the following attributes.

Type Number

Data elements 3124

Data element groups 128

Indicator types 6

Indicators 396

Indicator groups 128

Data sets 22

Data dictionaries 0

Organisation units 11484

Validation rules 0

Periods 38

Data values 543599

As you can see, there are significantly fewer data values that have

been imported even though DHIS 1.4 is reporting more data values.

I have been importing directly from the DHIS on a XP machine that has

both systems. I have included a stack trace of an import process

towards the end of this email.

Then try importing again. Should take around 15 minutes.

When Lars tried a few week back, he indicated the process would take

about 15 minutes. In my case, the process is almost instantaneous,

which seems impossible, given the amount of data in the original 1.4

database. I do have a new laptop, but it cannot be that fast, or can

it!!

So, I am asking for any pointers here about how to get all the data

from 1.4 into 2.0. I can of course provide all files to you if you can

assist me, but I have been struggling for several days now, and really

cannot figure out a way forward. It is crucial here in Zambia that we

establish a clear, reliable workflow for the regular importation of

data from 1.4 into 2.0. Any help, would be appreciated.

Best regards,

Jason

Below, stack trace from the import process…

  • INFO 16:24:32,484 Imported DataElements

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:36,078 Imported CalculatedDataElements

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:36,375 Imported IndicatorTypes

(DefaultDhis14FileImportService.java [Thread-23])

  • WARN 16:24:38,875 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,890 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,890 ‘Inpatient referral rate’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:38,890 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:38,890 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,906 ‘Facility mortality under 5 years rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,906 ‘Facility mortality under 5 years rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,906 ‘Facility mortality under 5 years rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,906 ‘Facility mortality under 5 years rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,906 ‘Weighing rate under 5 years’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,906 ‘Weighing rate under 5 years’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,921 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,921 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,921 ‘Children with severe malnutrition’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,937 ‘Diarrhoea nonbloody incidence under 5 years’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,937 'Severe Diarrhoea with dehydration incidence

under 5 years’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,937 ‘Pneumonia incidence under 5 years’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,937 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,953 ‘Vitamin A coverage under 1 year’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,953 ‘Vitamin A coverage 1 to 4 years’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,953 ‘Vitamin A coverage 1 to 4 years’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,953 ‘Mebendazole coverage to children 1 to 5 years’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,953 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,953 ‘Mebendazole coverage to children 1 to 5 years’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,984 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,984 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,984 ‘DPT Hib Hep 1st dose coverage’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,984 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,984 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,984 ‘DPT Hib Hep 2nd dose coverage’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:38,984 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:38,984 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:38,984 ‘DPT Hib Hep 3rd dose coverage’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,000 ‘DPT Hib Hep 1 to 3 doses drop out rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,000 ‘DPT Hib Hep 1 to 3 doses drop out rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,000 ‘DPT Hib Hep 1 to 3 doses drop out rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,000 ‘DPT Hib Hep 3 to Measles 1 doses drop out rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,000 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,000 ‘DPT Hib Hep 3 to Measles 1 doses drop out rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,015 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,015 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:39,015 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,015 ‘Cold chain fridge downtime’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,031 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,031 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,031 ‘Women year protection rate’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,031 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,031 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,031 ‘Couple year protection rate’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,062 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,062 ‘Male sterilisation rate’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:39,062 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,062 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,062 ‘Female sterilisation rate’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,062 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,062 ‘Cervical cancer screening coverage’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,078 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,078 ‘Breast cancer screening’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:39,156 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,156 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,156 ‘Delivery complications sepsis’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,171 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,171 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,171 ‘Delivery complications obstructed labour’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,171 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,171 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,171 ‘Delivery complications ruptured uterus’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,171 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,171 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,171 ‘Delivery complications retained placenta’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,187 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,187 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,187 'Delivery Pregnancy complications hypertensive

disorders’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,187 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,187 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,187 ‘Delivery Pregnancy complications haemorrhage’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,218 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,234 ‘STI treated new episode incidence’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,234 ‘Male urethritis syndrome incidence’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,234 ‘Genital ulcer treated new episode incidence’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,234 ‘Genital warts treated new episode incidence’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,234 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,250 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,250 ‘Inguinal bubo treated new episode incidence’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,265 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,265 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,265 ‘HIV testing rate’ contains a non-existing data

element identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,328 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,328 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:39,328 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,328 'Proportion treatment start among TB smear

positive’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,343 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,343 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,343 'Proportion new HIV pos patients started INH

preventive therapy’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,343 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,343 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,343 'Proportion new HIV pos patients started

Cotrimoxazole prophylaxis’ contains a non-existing data element

identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,359 ‘Malaria under 5 suspect incidence rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,359 ‘Malaria over 5 suspect incidence rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,359 ‘Malaria over 5 suspect incidence rate’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,359 ‘Malaria under 5 confirmed incidence rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,359 ‘Malaria over 5 confirmed incidence rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,359 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,375 ‘Malaria over 5 confirmed incidence rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,375 ‘Malaria treatment rate’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,375 ‘Malaria under 5 suspect case fatality rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,375 ‘Malaria over 5 suspect case fatality rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,375 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,375 ‘Malaria over 5 suspect case fatality rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,390 ‘Malaria under 5 confirmed case fatality rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,390 ‘Malaria over 5 confirmed case fatality rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,390 ‘Malaria over 5 confirmed case fatality rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,390 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,390 ‘Tracer items stock out rate’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,390 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,390 ‘Tracer items stock out rate’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,406 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,406 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,406 ‘Any 1st line antimalarial stock out rate’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,421 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,421 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,421 ‘DPT HepB Hib vaccine stock out rate’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,437 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,437 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,437 'Proportion vaccine fridges missing or not

working’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,546 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,546 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,546 ‘Percentage MOH Releases to district level’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,609 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:39,609 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:39,625 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,625 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,625 'Utilisation rate for child health services under

5 years total’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,625 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,625 'Utilisation rate for child health services under

5 years total’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,625 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,625 'Utilisation rate for child health services under

5 years total’ contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,625 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,640 ‘Vitamin A coverage 1 to 4 years (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,640 ‘Vitamin A coverage 1 to 4 years (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,640 ‘Vitamin A coverage under 1 year (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,640 'Utilisation rate for child health services under

5 years total (annualised)’ contains a non-existing data element

identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,640 'Utilisation rate for child health services under

5 years total (annualised)’ contains a non-existing data element

identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,640 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,640 'Utilisation rate for child health services under

5 years total (annualised)’ contains a non-existing data element

identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,656 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,656 ‘Utilisation rate PHC Total (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,656 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,656 ‘Utilisation rate PHC Total (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,671 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,671 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,671 ‘Women year protection rate (annulised)’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,687 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,687 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,687 ‘DPT Hib Hep 1st dose coverage (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,687 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,687 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,687 ‘DPT Hib Hep 2nd dose coverage (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,687 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,687 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,687 ‘DPT Hib Hep 3rd dose coverage (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,703 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,703 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,703 ‘Children with severe malnutrition (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,703 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,703 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,703 ‘Pneumonia incidence under 5 years (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,703 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,703 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,703 ‘Couple year protection rate (annualised)’

contains a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,718 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,718 ‘Male sterilisation rate (annualised)’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,718 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,718 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,718 ‘Female sterilisation rate (annualised)’ contains

a non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,843 Key is null (LoggingHashMap.java [Thread-23])

  • WARN 16:24:39,890 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,890 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,890 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,890 ‘Bed side cabinet locker budget’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,890 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,890 ‘Bed side cabinet locker budget’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,906 ‘Bed side cabinet locker budget’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:39,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:39,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,906 ‘Bed side screen budget’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:39,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,906 ‘Bed side screen budget’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:39,906 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:39,906 ‘Bed side screen budget’ contains a non-existing

data element identifier: 0 (Dhis14ExpressionConverter.java

[Thread-23])

  • WARN 16:24:40,140 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:40,140 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • WARN 16:24:40,140 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:40,140 ‘Dental x-ray unit budget’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:40,140 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:40,140 ‘Dental x-ray unit budget’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:40,140 Value is null for key: ‘0’ (LoggingHashMap.java

[Thread-23])

  • ERROR 16:24:40,140 ‘Dental x-ray unit budget’ contains a

non-existing data element identifier: 0

(Dhis14ExpressionConverter.java [Thread-23])

  • WARN 16:24:40,156 Key is null (LoggingHashMap.java [Thread-23])

  • INFO 16:24:40,187 Imported Indicators

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:40,953 Imported DataElementGroups

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:45,000 Imported DataElementGroup members

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:45,562 Imported IndicatorGroups

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:46,578 Imported IndicatorGroup members

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:47,125 Imported DataSets

(DefaultDhis14FileImportService.java [Thread-23])

  • INFO 16:24:50,906 Imported DataSet members

(DefaultDhis14FileImportService.java [Thread-23])

–~–~---------~–~----~------------~-------~–~----~

You received this message because you are subscribed to the Google Groups “dhis-users” group.

To post to this group, send email to dhis-users@googlegroups.com

To unsubscribe from this group, send email to dhis-users+unsubscribe@googlegroups.com

For more options, visit this group at http://groups.google.co.in/group/dhis-users?hl=en-GB

-~----------~----~----~----~------~----~------~–~—

9

Hi Lars,
Thanks for the offer. I am preparing the DB now for upload and will
upload it. It will likely take some time as the internet is quite slow
on my side. There is another version, that is very similar, except for
a few changes to the organizational hierarchy that I uploaded to our
internet server a few days back.I will send you the link in another
email, as the data is not public yet.

That was (what I thought) was the entire stack trace of the import
process as far as I can tell. This is another stack trace from
yesterday, using a slightly different database (I corrected some
issues with the organizational hierarchy, and that was the stack trace
I included in the last mail. It seems a bit more complete, so I am not
sure what happened with the other one. That was all there was as far
as the import went. (Attached at the bottom) .

Let me know if you come up with anything.

* INFO 16:10:43,093 Imported DataElements
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:46,218 Imported CalculatedDataElements
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:46,796 Imported IndicatorTypes
(DefaultDhis14FileImportService.java [Thread-18])
* WARN 16:10:49,078 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,078 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,078 'Inpatient referral rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:49,109 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,109 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,125 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,125 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,125 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,125 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,125 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,125 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,125 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,125 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,125 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,125 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,140 'Weighing rate under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,140 'Weighing rate under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,156 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,156 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,156 'Children with severe malnutrition' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,171 'Diarrhoea nonbloody incidence under 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,171 'Severe Diarrhoea with dehydration incidence
under 5 years' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,171 'Pneumonia incidence under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,187 'Vitamin A coverage under 1 year' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,187 'Vitamin A coverage 1 to 4 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,187 'Vitamin A coverage 1 to 4 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,203 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,203 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,203 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,203 'Mebendazole coverage to children 1 to 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,203 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,203 'Mebendazole coverage to children 1 to 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,234 'DPT Hib Hep 1st dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,250 'DPT Hib Hep 2nd dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,250 'DPT Hib Hep 3rd dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,265 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,265 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,265 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,265 'DPT Hib Hep 3 to Measles 1 doses drop out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,265 'DPT Hib Hep 3 to Measles 1 doses drop out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,281 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,281 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,281 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,281 'Cold chain fridge downtime' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,281 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,281 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,281 'Women year protection rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,296 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,296 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,296 'Couple year protection rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,296 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,296 'Male sterilisation rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:49,296 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,296 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,296 'Female sterilisation rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,312 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,312 'Cervical cancer screening coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,312 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,312 'Breast cancer screening' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:49,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,406 'Delivery complications sepsis' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,406 'Delivery complications obstructed labour'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,421 'Delivery complications ruptured uterus' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,421 'Delivery complications retained placenta'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,421 'Delivery Pregnancy complications hypertensive
disorders' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,437 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,437 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,437 'Delivery Pregnancy complications haemorrhage'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,468 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,468 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,468 'STI treated new episode incidence' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,468 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,468 'Male urethritis syndrome incidence' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,484 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,484 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,484 'Genital ulcer treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,484 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,484 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,484 'Genital warts treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,484 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,484 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,484 'Inguinal bubo treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,500 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,500 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,500 'HIV testing rate' contains a non-existing data
element identifier: 0 (Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,562 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,562 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,562 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,562 'Proportion treatment start among TB smear
positive' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,562 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,562 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,562 'Proportion new HIV pos patients started INH
preventive therapy' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,578 'Proportion new HIV pos patients started
Cotrimoxazole prophylaxis' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,578 'Malaria under 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,578 'Malaria over 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,578 'Malaria over 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,578 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,593 'Malaria under 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,593 'Malaria over 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,593 'Malaria over 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,593 'Malaria treatment rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,593 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,593 'Malaria under 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,609 'Malaria over 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,609 'Malaria over 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,609 'Malaria under 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,609 'Malaria over 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,609 'Malaria over 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,609 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,609 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,625 'Tracer items stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,625 'Tracer items stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,625 'Any 1st line antimalarial stock out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,656 'DPT HepB Hib vaccine stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,656 'Proportion vaccine fridges missing or not
working' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,781 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,781 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,781 'Percentage MOH Releases to district level'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,859 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,859 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:49,859 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,859 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,875 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,875 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,875 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,875 'Vitamin A coverage 1 to 4 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,875 'Vitamin A coverage 1 to 4 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,890 'Vitamin A coverage under 1 year (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,890 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,890 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,890 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,906 'Utilisation rate PHC Total (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,906 'Utilisation rate PHC Total (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:49,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:49,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:49,937 'Women year protection rate (annulised)' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,000 'DPT Hib Hep 1st dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,000 'DPT Hib Hep 2nd dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,015 'DPT Hib Hep 3rd dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,015 'Children with severe malnutrition (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,031 'Pneumonia incidence under 5 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,031 'Couple year protection rate (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,031 'Male sterilisation rate (annualised)' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,046 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,046 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,046 'Female sterilisation rate (annualised)' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,187 Key is null (LoggingHashMap.java [Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,234 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,234 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,234 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,234 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,234 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:50,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,250 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-18])
* WARN 16:10:50,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* WARN 16:10:50,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,421 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,421 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-18])
* ERROR 16:10:50,421 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-18])
* WARN 16:10:50,453 Key is null (LoggingHashMap.java [Thread-18])
* INFO 16:10:50,468 Imported Indicators
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:51,046 Imported DataElementGroups
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:54,984 Imported DataElementGroup members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:55,468 Imported IndicatorGroups
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:56,421 Imported IndicatorGroup members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:10:56,796 Imported DataSets
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:11:00,781 Imported DataSet members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:11:40,609 Imported OrganisationUnits
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:11:40,968 Imported OrganisationUnitGroups
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:11:49,500 Imported OrganisationUnitGroup members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:11:49,750 Imported OrganisationUnitGroupSets
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:11:50,109 Imported OrganisationUnitGroupSet members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:12:48,562 Imported OrganisationUnitRelationships
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:12:52,859 Imported OrganisationUnitHierarchy
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:13:05,250 Imported DataSet OrganisationUnit Associations
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 16:13:22,453 Imported Periods
(DefaultDhis14FileImportService.java [Thread-18])

···

2009/3/31 Lars Helge Øverland <larshelge@gmail.com>:

Hi Jason,

I would need the whole stack trace as the part with the data values comes at
the end.

Im happy to help, it would be easier for me if you could upload the DHIS 1.4
database somewhere so I can try on my side.

This might be caused by an aborted import process. I am sorry for the
trouble but the problem is that Access is more lenient when it comes to
constraints than Postgres/Mysql, so it's hard to foresee all kinds of
situations that can arise.

Lars

On Tue, Mar 31, 2009 at 5:05 PM, Jason Pickering > <jason.p.pickering@gmail.com> wrote:

Hi Everyone,

I wanted to pick up this thread again, after trying everything that I
can to get the import process from 1.4 to 2.0 to work, but am still
not succeeding.

I have checked a database provided to me by Ola several months ago.
This database contained roughly 3 million records. Since then, there
have been several new imports into the master 1.4 database here in
Zambia. According to DHIS 2, the database that was imported by Ola has
the folliowing characteristics According to DHIS 1.4 the database
contains roughly 3 million records with only 100 or so being
archived.

Data Statistics
Type Number
Data elements 3114
Data element groups 128
Indicator types 6
Indicators 390
Indicator groups 128
Data sets 19
Data dictionaries 0
Organisation units 12729
Validation rules 0
Periods 85
Data values 1646537

The database that I have recently imported (with over 4.5 million
records with 2.2 million that are archived according to DHIS 1.4) has
the following attributes.

Type Number
Data elements 3124
Data element groups 128
Indicator types 6
Indicators 396
Indicator groups 128
Data sets 22
Data dictionaries 0
Organisation units 11484
Validation rules 0
Periods 38
Data values 543599

As you can see, there are significantly fewer data values that have
been imported even though DHIS 1.4 is reporting more data values.

I have been importing directly from the DHIS on a XP machine that has
both systems. I have included a stack trace of an import process
towards the end of this email.

> Then try importing again. Should take around 15 minutes.

When Lars tried a few week back, he indicated the process would take
about 15 minutes. In my case, the process is almost instantaneous,
which seems impossible, given the amount of data in the original 1.4
database. I do have a new laptop, but it cannot be that fast, or can
it!!

So, I am asking for any pointers here about how to get all the data
from 1.4 into 2.0. I can of course provide all files to you if you can
assist me, but I have been struggling for several days now, and really
cannot figure out a way forward. It is crucial here in Zambia that we
establish a clear, reliable workflow for the regular importation of
data from 1.4 into 2.0. Any help, would be appreciated.

Best regards,
Jason

Below, stack trace from the import process...

* INFO 16:24:32,484 Imported DataElements
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:36,078 Imported CalculatedDataElements
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:36,375 Imported IndicatorTypes
(DefaultDhis14FileImportService.java [Thread-23])
* WARN 16:24:38,875 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,890 'Inpatient referral rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:38,890 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:38,890 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Facility mortality under 5 years rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Weighing rate under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,906 'Weighing rate under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,921 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,921 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,921 'Children with severe malnutrition' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,937 'Diarrhoea nonbloody incidence under 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,937 'Severe Diarrhoea with dehydration incidence
under 5 years' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,937 'Pneumonia incidence under 5 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,937 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Vitamin A coverage under 1 year' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Vitamin A coverage 1 to 4 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Vitamin A coverage 1 to 4 years' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Mebendazole coverage to children 1 to 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,953 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,953 'Mebendazole coverage to children 1 to 5 years'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,984 'DPT Hib Hep 1st dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,984 'DPT Hib Hep 2nd dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:38,984 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:38,984 'DPT Hib Hep 3rd dose coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 1 to 3 doses drop out rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 3 to Measles 1 doses drop out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,000 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,000 'DPT Hib Hep 3 to Measles 1 doses drop out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,015 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,015 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,015 'Cold chain fridge downtime' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,031 'Women year protection rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,031 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,031 'Couple year protection rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,062 'Male sterilisation rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,062 'Female sterilisation rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,062 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,062 'Cervical cancer screening coverage' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,078 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,078 'Breast cancer screening' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,156 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,156 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,156 'Delivery complications sepsis' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,171 'Delivery complications obstructed labour'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,171 'Delivery complications ruptured uterus' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,171 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,171 'Delivery complications retained placenta'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,187 'Delivery Pregnancy complications hypertensive
disorders' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,187 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,187 'Delivery Pregnancy complications haemorrhage'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,218 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'STI treated new episode incidence' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'Male urethritis syndrome incidence' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'Genital ulcer treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,234 'Genital warts treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,234 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,250 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,250 'Inguinal bubo treated new episode incidence'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,265 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,265 'HIV testing rate' contains a non-existing data
element identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,328 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,328 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,328 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,328 'Proportion treatment start among TB smear
positive' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,343 'Proportion new HIV pos patients started INH
preventive therapy' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,343 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,343 'Proportion new HIV pos patients started
Cotrimoxazole prophylaxis' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria under 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria over 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria over 5 suspect incidence rate' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria under 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,359 'Malaria over 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,359 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria over 5 confirmed incidence rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria treatment rate' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria under 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria over 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,375 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,375 'Malaria over 5 suspect case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Malaria under 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Malaria over 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Malaria over 5 confirmed case fatality rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Tracer items stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,390 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,390 'Tracer items stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,406 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,406 'Any 1st line antimalarial stock out rate'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,421 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,421 'DPT HepB Hib vaccine stock out rate' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,437 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,437 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,437 'Proportion vaccine fridges missing or not
working' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,546 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,546 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,546 'Percentage MOH Releases to district level'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,609 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,609 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,625 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,625 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,625 'Utilisation rate for child health services under
5 years total' contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,625 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Vitamin A coverage 1 to 4 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Vitamin A coverage 1 to 4 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Vitamin A coverage under 1 year (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,640 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,640 'Utilisation rate for child health services under
5 years total (annualised)' contains a non-existing data element
identifier: 0 (Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,656 'Utilisation rate PHC Total (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,656 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,656 'Utilisation rate PHC Total (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,671 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,671 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,671 'Women year protection rate (annulised)' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,687 'DPT Hib Hep 1st dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,687 'DPT Hib Hep 2nd dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,687 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,687 'DPT Hib Hep 3rd dose coverage (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,703 'Children with severe malnutrition (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,703 'Pneumonia incidence under 5 years (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,703 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,703 'Couple year protection rate (annualised)'
contains a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,718 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,718 'Male sterilisation rate (annualised)' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,718 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,718 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,718 'Female sterilisation rate (annualised)' contains
a non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,843 Key is null (LoggingHashMap.java [Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,890 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,890 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,890 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side cabinet locker budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:39,906 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:39,906 'Bed side screen budget' contains a non-existing
data element identifier: 0 (Dhis14ExpressionConverter.java
[Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:40,140 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:40,140 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:40,140 Value is null for key: '0' (LoggingHashMap.java
[Thread-23])
* ERROR 16:24:40,140 'Dental x-ray unit budget' contains a
non-existing data element identifier: 0
(Dhis14ExpressionConverter.java [Thread-23])
* WARN 16:24:40,156 Key is null (LoggingHashMap.java [Thread-23])
* INFO 16:24:40,187 Imported Indicators
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:40,953 Imported DataElementGroups
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:45,000 Imported DataElementGroup members
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:45,562 Imported IndicatorGroups
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:46,578 Imported IndicatorGroup members
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:47,125 Imported DataSets
(DefaultDhis14FileImportService.java [Thread-23])
* INFO 16:24:50,906 Imported DataSet members
(DefaultDhis14FileImportService.java [Thread-23])

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"dhis-users" group.
To post to this group, send email to dhis-users@googlegroups.com
To unsubscribe from this group, send email to
dhis-users+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.co.in/group/dhis-users?hl=en-GB

-~----------~----~----~----~------~----~------~--~---

10

OK if this is the whole ting the system does not even attempt at importing data values. This is weird, I will have a look at the data file.

Regarding import work flow, I would recommend doing one initial import from data file with legacy data and everything you have by now. Then use the XML based import to for the data you receive on a regular basis. That is “DHIS 1.4 XML Import”, remember that the DHIS 1.4 installation that produced the XML file must be build 112 or later.

···

On Tue, Mar 31, 2009 at 6:16 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Lars,

Thanks for the offer. I am preparing the DB now for upload and will

upload it. It will likely take some time as the internet is quite slow

on my side. There is another version, that is very similar, except for

a few changes to the organizational hierarchy that I uploaded to our

internet server a few days back.I will send you the link in another

email, as the data is not public yet.

That was (what I thought) was the entire stack trace of the import

process as far as I can tell. This is another stack trace from

yesterday, using a slightly different database (I corrected some

issues with the organizational hierarchy, and that was the stack trace

I included in the last mail. It seems a bit more complete, so I am not

sure what happened with the other one. That was all there was as far

as the import went. (Attached at the bottom) .

Let me know if you come up with anything.

11

Yes you are right. We are working on making it more robust.

···

On Tue, Mar 31, 2009 at 6:33 PM, Calle Hedberg chedberg@telkomsa.net wrote:

Lars,

If the missing data element ids in some of the indicator formulas result in

the import process into 2.0 bombing out, then something is not right -

random errors in e.g. formulas do not need to result in the whole process

aborting. My suggestion would be to simply disregard any such indicators

(but log a user-friendly message) and then continue the import.

1.4 is doing the same for indicator processing - any erroneously defined

indicator is reported to the user and then disregarded.

12

Jason,

o I have now imported the database I downloaded last night without problems in 32 minutes, giving 4,9 million data values.

  • The code now manages missing calculated data element identifiers. Will be a part of next DHIS 2 release. If you remove them manually it will work anyway.

  • I had to remove the data values larger than 2^31, which is basically the budget data, from the database manually.

o To speed things up you can do the following (you have probably done a few of them):

  • Set the environment variable JAVA_OPTS, mine is -Xms128m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=1024m

  • Give Postgres more memory in pginstalldir/data/postgresql.conf by setting the shared_buffers property, mine is 256MB

  • For inital imports (!), in the DHIS 2 import screen - “Show advanced options” - set “Skip check for matching datavalues” to “yes (empty database)”

o Regarding db maintenance I did a few things under “Data administration” - “Maintenance”:

  • I ran “Clear zero values” which reduced the total amount of data values from 4.9 to 3.3 millions.

  • I ran “Prune periods” which reduced the total amount of periods from 99 to 68, all of this will speed up the datamart process.

  • I entered the orgunit level names manually under “Organisation Unit” - “Organisation Unit Levels”.

o What you need to do is the following:

  • Have a look at the indicator and calculated data element identifiers. I am now replacing missing identifiers with “0”, which might imply unwanted results or division-by-zero.

  • Change the aggregation operator from SUM to AVERAGE for data elements where you want to do the average when aggregating, eg. Age and Population related elements. The sustainable solution to this is to change this in DHIS 1.4, which simply always sets this property to SUM.

o I am not sure why you didn’t get it to work. This sounds a little silly but are you sure you waited long enough? My import on a high-end maching took 32 min. Is the GUI message saying “Import process complete”, or is it still saying “Importing routine data values” ? This is the end of my log. Yours stops at “Imported Periods”:

···

  • INFO 12:58:25,726 Imported Periods (DefaultDhis14FileImportService.java [Thre
    ad-9])

  • INFO 13:27:31,520 Imported RoutineDataValues (DefaultDhis14FileImportService.
    java [Thread-9])

  • INFO 13:27:34,427 Imported OnChangePeriods (DefaultDhis14FileImportService.ja
    va [Thread-9])

  • INFO 13:27:58,880 Imported SemiPermanentDataValues (DefaultDhis14FileImportSe
    rvice.java [Thread-9])

  • INFO 13:27:58,958 Import process completed: 0:32:01.611 (ImportInternalProces

s.java [Thread-9])

You can download the pg backup file here (created in windows/pgadmin):

http://folk.uio.no/larshelg/files/dhis2zambiaMarch2009.backup

best regards, Lars

13

Hi Lars,
Thanks for this. It is a huge relief to know that it will work, albeit
only with the developer massaging it at this point. :slight_smile:

- I had to remove the data values larger than 2^31, which is basically the
budget data, from the database manually.

We will need to change this in DHIS 1.4 somehow. Would it be possible
for DHIS to implement a check to ensure that the value is not out of
the allowable range? If it is, then perhaps it could simply ignore
these values, and inform the user.

- Set the environment variable JAVA_OPTS, mine is -Xms128m -Xmx512m
-XX:PermSize=128m -XX:MaxPermSize=1024m

After looking at the logs again, I saw some PermGenSpace errors that
occurred directly after the import started. I am not sure if they are
related to the import or something else. It could be related but there
were no timestamps on the errors, so it is difficult to tell. I assume
they are related though, because I did not see the last part of what
showed up in your log, in my log. I will try and up the memory a bit
more on this machine and see what happens.

- Give Postgres more memory in pginstalldir/data/postgresql.conf by setting
the shared_buffers property, mine is 256MB

Thanks. I will take a look at it.

- For inital imports (!), in the DHIS 2 import screen - "Show advanced
options" - set "Skip check for matching datavalues" to "yes (empty
database)"

Could you explain this option? I would assume that it will check for
existing data values and not overwrite them. If I choose no, I will
assume it will attempt to insert everything?

o Regarding db maintenance I did a few things under "Data administration" -
"Maintenance":

- I ran "Clear zero values" which reduced the total amount of data values
from 4.9 to 3.3 millions.

- I ran "Prune periods" which reduced the total amount of periods from 99 to
68, all of this will speed up the datamart process.

I think we can do this from the DHIS 1.4 side as well. WIll take a look at it.

- I entered the orgunit level names manually under "Organisation Unit" -
"Organisation Unit Levels".

o What you need to do is the following:

- Have a look at the indicator and calculated data element identifiers. I am
now replacing missing identifiers with "0", which might imply unwanted
results or division-by-zero.

We are working on this now. Am having some difficulties with DHIS 1.4
in this regard, but we know it is an issue with this database.

- Change the aggregation operator from SUM to AVERAGE for data elements
where you want to do the average when aggregating, eg. Age and Population
related elements. The sustainable solution to this is to change this in DHIS
1.4, which simply always sets this property to SUM.

Also known to us. We thought this had been fixed sometime ago by Ola
but it seems to have crept back into the system through a recent
update.

o I am not sure why you didn't get it to work. This sounds a little silly
but are you sure you waited long enough? My import on a high-end maching
took 32 min. Is the GUI message saying "Import process complete", or is it
still saying "Importing routine data values" ? This is the end of my log.
Yours stops at "Imported Periods"

Yes, I waited. Well, in fact ,I did not have to wait. It just executed
like lightning and gave me a "null" response in the browser window. I
did not get anything like "Import process complete".

-------------

* INFO 12:58:25,726 Imported Periods (DefaultDhis14FileImportService.java
[Thre
ad-9])
* INFO 13:27:31,520 Imported RoutineDataValues
(DefaultDhis14FileImportService.
java [Thread-9])
* INFO 13:27:34,427 Imported OnChangePeriods
(DefaultDhis14FileImportService.ja
va [Thread-9])
* INFO 13:27:58,880 Imported SemiPermanentDataValues
(DefaultDhis14FileImportSe
rvice.java [Thread-9])
* INFO 13:27:58,958 Import process completed: 0:32:01.611
(ImportInternalProces
s.java [Thread-9])

------------------

You can download the pg backup file here (created in windows/pgadmin):

http://folk.uio.no/larshelg/files/dhis2zambiaMarch2009.backup

Big help Lars. This will at least enable me to start having a look at
the development of the reports (which they need ASAP) and then we can
continue to clean up the other issues.

Tack,
Jason

14

We will need to change this in DHIS 1.4 somehow. Would it be possible

for DHIS to implement a check to ensure that the value is not out of

the allowable range? If it is, then perhaps it could simply ignore

these values, and inform the user.

That would have been very nice but this happens when the JDBC driver accesses the database and doesn’t give the DHIS 2 application a chance to do something about it.

  • For inital imports (!), in the DHIS 2 import screen - "Show advanced

options" - set “Skip check for matching datavalues” to "yes (empty

database)"

Could you explain this option? I would assume that it will check for

existing data values and not overwrite them. If I choose no, I will

assume it will attempt to insert everything?

Exactly. “No” is the default and will do a check for matching data values for every row, which is redundant on empty databases.

o I am not sure why you didn’t get it to work. This sounds a little silly

but are you sure you waited long enough? My import on a high-end maching

took 32 min. Is the GUI message saying “Import process complete”, or is it

still saying “Importing routine data values” ? This is the end of my log.

Yours stops at “Imported Periods”

Yes, I waited. Well, in fact ,I did not have to wait. It just executed

like lightning and gave me a “null” response in the browser window. I

did not get anything like “Import process complete”.

Strange, normally something would have emerged in the logs.

http://folk.uio.no/larshelg/files/dhis2zambiaMarch2009.backup

Big help Lars. This will at least enable me to start having a look at

the development of the reports (which they need ASAP) and then we can

continue to clean up the other issues.

Tack,

Jason

Det e lugnt…

15

Whew. We have cleaned up the DHIS 1.4 database a lot to remove some of
the issues we were having with incorrect indicator formulas, and
problems with the organization hierarchy. I have removed all values
over 2^31 per your email as well as making some deletions from the
DataElementCalculated table. Finally, it worked (See stack trace
below).

Thanks for all your help.

Regards,
Jason

* INFO 12:24:23,359 Imported DataElements
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:31,937 Imported CalculatedDataElements
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:32,234 Imported IndicatorTypes
(DefaultDhis14FileImportService.java [Thread-18])
* WARN 12:24:34,484 Key is null (LoggingHashMap.java [Thread-18])
* WARN 12:24:34,500 Key is null (LoggingHashMap.java [Thread-18])
* WARN 12:24:34,781 Key is null (LoggingHashMap.java [Thread-18])
* WARN 12:24:35,562 Key is null (LoggingHashMap.java [Thread-18])
* WARN 12:24:35,578 Key is null (LoggingHashMap.java [Thread-18])
* WARN 12:24:36,125 Key is null (LoggingHashMap.java [Thread-18])
* WARN 12:24:36,703 Key is null (LoggingHashMap.java [Thread-18])
* INFO 12:24:36,937 Imported Indicators
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:37,421 Imported DataElementGroups
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:41,156 Imported DataElementGroup members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:41,546 Imported IndicatorGroups
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:42,578 Imported IndicatorGroup members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:43,640 Imported DataSets
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:48,593 Imported DataSet members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:59,015 Imported OrganisationUnits
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:24:59,359 Imported OrganisationUnitGroups
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:04,031 Imported OrganisationUnitGroup members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:04,250 Imported OrganisationUnitGroupSets
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:04,625 Imported OrganisationUnitGroupSet members
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:14,156 Imported OrganisationUnitRelationships
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:16,015 Imported OrganisationUnitHierarchy
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:25,203 Imported DataSet OrganisationUnit Associations
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 12:25:43,484 Imported Periods
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 13:24:14,562 Imported RoutineDataValues
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 13:24:30,953 Imported OnChangePeriods
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 13:25:06,921 Imported SemiPermanentDataValues
(DefaultDhis14FileImportService.java [Thread-18])
* INFO 13:25:07,000 Import process completed: 1:01:08.109
(ImportInternalProcess.java [Thread-18])

···

2009/4/1 Lars Helge Øverland <larshelge@gmail.com>:

We will need to change this in DHIS 1.4 somehow. Would it be possible
for DHIS to implement a check to ensure that the value is not out of
the allowable range? If it is, then perhaps it could simply ignore
these values, and inform the user.

That would have been very nice but this happens when the JDBC driver
accesses the database and doesn't give the DHIS 2 application a chance to do
something about it.

> - For inital imports (!), in the DHIS 2 import screen - "Show advanced
> options" - set "Skip check for matching datavalues" to "yes (empty
> database)"
>

Could you explain this option? I would assume that it will check for
existing data values and not overwrite them. If I choose no, I will
assume it will attempt to insert everything?

Exactly. "No" is the default and will do a check for matching data values
for every row, which is redundant on empty databases.

>
> o I am not sure why you didn't get it to work. This sounds a little
> silly
> but are you sure you waited long enough? My import on a high-end maching
> took 32 min. Is the GUI message saying "Import process complete", or is
> it
> still saying "Importing routine data values" ? This is the end of my
> log.
> Yours stops at "Imported Periods"

Yes, I waited. Well, in fact ,I did not have to wait. It just executed
like lightning and gave me a "null" response in the browser window. I
did not get anything like "Import process complete".

Strange, normally something would have emerged in the logs.

>
> http://folk.uio.no/larshelg/files/dhis2zambiaMarch2009.backup

Big help Lars. This will at least enable me to start having a look at
the development of the reports (which they need ASAP) and then we can
continue to clean up the other issues.

Tack,
Jason

Det e lugnt..

16

Thats great news, well done…

Lars

···

2009/4/2 Jason Pickering jason.p.pickering@gmail.com

Whew. We have cleaned up the DHIS 1.4 database a lot to remove some of

the issues we were having with incorrect indicator formulas, and

problems with the organization hierarchy. I have removed all values

over 2^31 per your email as well as making some deletions from the

DataElementCalculated table. Finally, it worked (See stack trace

below).

Thanks for all your help.

Regards,

Jason

17

Hi there. I need to do a fresh import of the Zambia DHIS 1.4 database
after a long round of changes in the 1.4 database, but get stuck with
the following stack trace. Hopefully, this will be the last before we
start doing incremental XML updates.

Data integrity checks in 1.4 version 116 are OK. Also, I checked the
data in the DataElementCalculated table and it looks OK.

Any idea what this might be caused by?

Best regards,
Jason

* ERROR 08:26:23,406 The process threw exception (ProcessExecutor.java
[Thread-14])
java.lang.RuntimeException: Query with RowHandler failed
  at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:144)
  at org.hisp.dhis.importexport.dhis14.file.query.IbatisQueryManager.queryWithRowhandler(IbatisQueryManager.java:126)
  at sun.reflect.GeneratedMethodAccessor212.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:307)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
  at $Proxy45.queryWithRowhandler(Unknown Source)
  at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importRoutineDataValues(DefaultDhis14FileImportService.java:766)
  at org.hisp.dhis.importexport.dhis14.file.importer.DefaultDhis14FileImportService.importData(DefaultDhis14FileImportService.java:296)
  at org.hisp.dhis.importexport.ImportInternalProcess.executeStatements(ImportInternalProcess.java:97)
  at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:90)
  at org.hisp.dhis.system.process.AbstractStatementInternalProcess.execute(AbstractStatementInternalProcess.java:37)
  at org.amplecode.cave.process.ProcessExecutor.run(ProcessExecutor.java:125)
  at java.lang.Thread.run(Unknown Source)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in sqlmap/routineDataValue.sqlmap.xml.
--- The error occurred while applying a result map.
--- Check the routineDataValue.routineDataValueResultMap.
--- The error happened while setting a property on the result object.
--- Cause: java.lang.NullPointerException
Caused by: java.lang.NullPointerException
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188)
  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:138)
  ... 18 more
Caused by: java.lang.NullPointerException
  at org.hisp.dhis.importexport.converter.AbstractDataValueConverter.getMatching(AbstractDataValueConverter.java:79)
  at org.hisp.dhis.importexport.converter.AbstractDataValueConverter.getMatching(AbstractDataValueConverter.java:39)
  at org.hisp.dhis.importexport.converter.AbstractConverter.read(AbstractConverter.java:77)
  at org.hisp.dhis.importexport.dhis14.file.rowhandler.RoutineDataValueRowHandler.handleRow(RoutineDataValueRowHandler.java:116)
  at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:76)
  at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:395)
  at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:185)
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
  at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
  ... 23 more