← Back to team overview

dhis2-users team mailing list archive

Re: Pivot Table does not display correct data

 

Hi Ola

I tried again to turn the tables manually analytics. The system remains
locked and does not write error file in Apache Tomcat. Not sure what might
be happening. A little time to migrate to postgres mysql base.

Thanks


2014-05-26 8:18 GMT-03:00 Ola Hodne Titlestad <olati@xxxxxxxxxx>:

> Hi José,
>
> As you pointed out the missing data for January in your pivot table is
> most likely caused by a problem with the analytics tables generation.
>
> In order to find out what went wrong with the analytics process we need to
> see your tomcat log.
>
> The current analytics tables are only replaced when a new analytics export
> process has completed successfully, and if it fails the tables remain as
> before.
> So that is likely why you can still see older data in your pivots, but not
> the new January data (you write that analytics process runs indefinitely).
>
> Can you try to run analytics (manually from UI) one more time and then
> monitor your tomcat log at the same time, and possibly share the relevant
> part of the log with us?
>
> Thanks.
>
> Ola
> -------
>
>
> ----------------------------------
> Ola Hodne Titlestad (Mr)
> HISP
> Department of Informatics
> University of Oslo
>
> Mobile: +47 48069736
> Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16>
>
>
> On 22 May 2014 18:32, José Berilo <jberilo@xxxxxxxxxxxxx> wrote:
>
>> Hi All,
>>
>> I have the following problem:
>>
>>   Data entered in the data entry module does not appear in the pivot
>> table as a sequence of screens figure 1, Figure 2 and figure 3. Follow the
>> example in the screenshot below with data entered in a unit
>> hierarchically linked to Prog Maranhão in January 2014. Pivot Table data that
>> month is not displayed. Have tried to update the analytical tables but did
>> not work. Is running indefinitely.
>>
>> Can someone help?
>>
>> Thank you.
>>
>> --
>> ____________________________
>> José Berilo
>> Estatístico
>> DEAVE - BEMFAM
>> jberilo@xxxxxxxxxxxxx
>> Tel. 21 30052412
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
José Berilo
jberilo@xxxxxxxxx
tel. 998060123

References