dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olatitle@xxxxxxxxx>]

Hi,

Using the same database as Roger I managed to reproduce this problem and
found that the clearing the hierarchy history as suggested by Lars, solved
it.

The problem was aggregation up the hierarchy from the raw data at district
level to region or national, as all aggregates for orgunits above the
district level were 0 in the report table.

Apparently something has happened during the creation or later fixing of the
orgunit hierarchy which has lead to a problem with the aggregation.
Clearing the hierarchy history made the system rebuild the hierarchy
structure again and then it worked.

It is always good practice to clear the hierarchy history after finishing
the initial customisation work as the history then is more a history of
fixes and tweaking and not a real history of how the organisational
structure has changed over time. This also speeds up the aggregation process
as no history needs to be taken into account.

Of course later when in production and real changes to the hierarchy are
necessary to reflect real world changes then one should not clear the
history after making such changes.....

Lars might fill in more technical details as to how this problem happened.

Ola
----------

2010/6/4 Lars Helge Øverland <larshelge@xxxxxxxxx>

>
>
> On Fri, Jun 4, 2010 at 7:37 AM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> wrote:
>
>> Hi Roger,
>>
>> Ola will probably be able help a bit more with this, but just a few
>> things to check.
>>
>> Have all the resource tables been built? Maintenance->Resource tables
>>
>
>
> Hi Roger,
>
> also try going to data administration -> maintenance -> clear hierarchy
> history.
>
> Lars
>
>
>
>>
>> Regards,
>> Jason
>>
>>
>>
>>
>>
>> On Thu, Jun 3, 2010 at 10:28 PM, Friedman, Roger (CDC/OID/NCHHSTP)
>> (CTR) <rdf4@xxxxxxx> wrote:
>> > No matter what I do, I can't get my data to roll up.  Here is the log
>> from
>> > my latest effort, using a dimension report.  All the headers are
>> correct,
>> > all the periods are correct, there are the right number of rows in the
>> > _report table, it's just that all numbers are 0.  When I look at
>> > aggregateddatavalue, only one of the two periods is there, only 2 of 11
>> > organization units is there, all 44 categoryoptioncomboids are there.
>> >
>> > <<ReportLog1.log>>
>> >
>> > _______________________________________________
>> > Mailing list: https://launchpad.net/~dhis2-users<https://launchpad.net/%7Edhis2-users>
>> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~dhis2-users<https://launchpad.net/%7Edhis2-users>
>> > More help   : https://help.launchpad.net/ListHelp
>> >
>> >
>>
>>
>>
>> --
>> --
>> Jason P. Pickering
>> email: jason.p.pickering@xxxxxxxxx
>> tel:+260968395190
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs<https://launchpad.net/%7Edhis2-devs>
> More help   : https://help.launchpad.net/ListHelp
>
>