← Back to team overview

dhis2-devs team mailing list archive

Re: Urgent: Analytics Tables Not Generating or Populating

 

Hi I can confirm that a bug slipped into r 13021 in analytics table
generation. Fixing now.

Lars


On Wed, Nov 27, 2013 at 3:51 PM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

> Hi Crizelle,
> The one log (catalina.out) which you did not append (screenshots only) is
> the one which might help to get to the bottom of this. It is not very clear
> from the screenshots. Could you post this someplace (pastebin.com?), or
> at least the part when the analytics process starts? This might help to
> diagnose exactly what is going on. Also, please let us know the version of
> DHIS2 and Postgres which you are using.
>
> Best regards,
> Jason
>
>
>
> On Wed, Nov 27, 2013 at 2:52 PM, Crizelle Nel <crizellenel@xxxxxxxxx>wrote:
>
>> Dear all,
>>
>> 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
>>
>>
>>
>> *Crizelle Nel*
>>
>> 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*
>>
>> ok
>>
>> yes
>>
>> 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.
>>
>> --
>>
>> Regards,
>> Crizelle Nel
>>
>> [image: HISP_Logo_sm]
>> Software Development and Information Systems
>>
>>
>> *Health Information Systems Program (HISP) -
>> SA------------------------------------------------------------------------------
>> *Email:       crizellenel@xxxxxxxxx
>> Cell:          +27 84 580 3342
>> Fax:          0866 509 502
>> Skype:      crizelle_nel
>> Website:   http://hispsa.org
>>
>>
>> ---------- Forwarded message ----------
>> From: Crizelle Nel <crizellenel@xxxxxxxxx>
>> Date: Tue, Nov 26, 2013 at 7:21 AM
>> Subject: Fwd: Issue with Analytics tables
>> To: Lars Helge Øverland <larshelge@xxxxxxxxx>
>>
>>
>> Hi Lars,
>>
>> 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).
>>
>> [image: Inline image 1]
>>
>> [image: Inline image 2]
>>
>> [image: Inline image 3]
>>
>> [image: Inline image 4]
>>
>> As mentioned, the analytics tables are not generating. Seems like the
>> same UID issue that prohibited the resource tables to generate.
>>
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

PNG image

PNG image

PNG image

PNG image

PNG image


Follow ups

References