HISP-SA requires urgent assistance please.
One of our provinces (Free State) is using DHIS2 for data capturing, but currently we cannot report on any of the data that has been captured because the analytics tables won’t generate and populate.
Lars determined that the reason for this is because some of our UIDs start with numbers (we imported them from the DHIS1.4 data file).
Excerpt from Gmail Chat:
Lars Helge Øverland
"the underlying problem here is that we use uids as column names, and that the uid starts with a number
in dhis2 all uids always start with an alpha character so that they become valid column names and xml element names
there is a small flaw in the dhis2 code - this should have been escaped
We have changed the 1.4 data file conversion process to pull in our existing DHIS1.4 UIDs, since 1.4 is still currently our master system.
Is it an easy fix?
Lars Helge Øverland
but it could cause problems further down the line
Lars made a code change in DHIS2 which partially addressed the problem (the resource tables are now generating), but was not able to provide further support due to prior committments [Refer to http://apps.dhis2.org/ci/job/dhis-2.13/, #4]. The Tomcat logs and errors are attached and in the email below.
We are hoping someone is available and able to provide immediate assistance in finalizing this code fix as we urgently need to report on this data.
Any help will be much appreciated.
localhost_access_log.2013-11-26.txt (177 KB)
catalina.2013-11-26.log (8.81 KB)
localhost.2013-11-26.log (1.76 KB)
commons-daemon.2013-11-26.log (916 Bytes)
Software Development and Information Systems
Cell: +27 84 580 3342
Fax: 0866 509 502
---------- Forwarded message ----------
From: Crizelle Nel email@example.com
Date: Tue, Nov 26, 2013 at 7:21 AM
Subject: Fwd: Issue with Analytics tables
To: Lars Helge Øverland firstname.lastname@example.org
Tomcat logs attached and and screen shot of my Tomcat window and DHIS2 screen below (I attached all the log files since my Tomcat window and my log files are not the same…don’t know why not).
As mentioned, the analytics tables are not generating. Seems like the same UID issue that prohibited the resource tables to generate.