dhis2-users team mailing list archive

[Stanley Kalyati <skalyati@xxxxxxxxxxxxx>]

Lars,

Here you are.Remember am using the DHIS Live downloaded from dhis2.org.


 2014-02-12 08:53:15

Analytics tables updated

2014-02-12 08:53:15

Table not valid, aborted update

2014-02-12 08:53:15

Updating event analytics tables

2014-02-12 08:53:15

Table update done

2014-02-12 08:53:15

Swapping analytics tables

2014-02-12 08:53:15

Vacuuming tables

2014-02-12 08:53:15

Creating indexes

2014-02-12 08:53:15

Applying aggregation levels

2014-02-12 08:53:15

Pruned analytics tables

2014-02-12 08:53:15

Populating analytics tables

2014-02-12 08:53:15

Creating analytics tables

2014-02-12 08:53:15

Updating compeleteness target table

2014-02-12 08:53:15

Table not valid, aborted update

2014-02-12 08:53:15

Updating completeness tables

2014-02-12 08:53:15

Table not valid, aborted update

2014-02-12 08:53:15

Updating analytics tables

2014-02-12 08:53:04

Updating resource tables


*Stanley Kalyati | Monitoring and Evaluation Technical Lead*

*PSI/Malawi*
Head Office & Main Warehouse,Off M1 Road,Kanengo,Area 28 Plot 198

PO Box 30132, Capital City, Lilongwe 3 Malawi

Tel: +265 (0) 1 711 484  |  Fax: +265 (0) 1 711 486

skalyati@xxxxxxxxxxxxx  <kmalewezi@xxxxxxxxxxxxx%C2%A0>|  www.psi.org/malawi

Skype: stanley.kalyati1  | Gmail: skalyati@xxxxxxxxx




On 12 February 2014 11:11, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

> Okay, can you please post all output in the yellow area related to the
> analytics process (where you get that "table not valid" message).
>
>
> On Wed, Feb 12, 2014 at 10:05 AM, Stanley Kalyati <skalyati@xxxxxxxxxxxxx>wrote:
>
>> I am able to run the Reporting rate summary and its giving me the report
>> very well BUT when it comes to Pivot tables and Visualiser,do data values
>> found?
>>
>>
>> *Stanley Kalyati | Monitoring and Evaluation Technical Lead *
>>
>> *PSI/Malawi*
>> Head Office & Main Warehouse,Off M1 Road,Kanengo,Area 28 Plot 198
>>
>> PO Box 30132, Capital City, Lilongwe 3 Malawi
>>
>>
>> Tel: +265 (0) 1 711 484  |  Fax: +265 (0) 1 711 486
>>
>> skalyati@xxxxxxxxxxxxx  <kmalewezi@xxxxxxxxxxxxx%C2%A0>|
>> www.psi.org/malawi
>>
>> Skype: stanley.kalyati1  | Gmail: skalyati@xxxxxxxxx
>>
>>
>>
>>
>> On 12 February 2014 11:03, Stanley Kalyati <skalyati@xxxxxxxxxxxxx>wrote:
>>
>>> Lars,
>>>
>>> Then how come when ever i want to run Pivot tables and Visualizer,i am
>>> getting the message "No values found".
>>>
>>> Regards
>>>
>>>
>>> *Stanley Kalyati | Monitoring and Evaluation Technical Lead*
>>>
>>> *PSI/Malawi*
>>> Head Office & Main Warehouse,Off M1 Road,Kanengo,Area 28 Plot 198
>>>
>>> PO Box 30132, Capital City, Lilongwe 3 Malawi
>>>
>>>
>>> Tel: +265 (0) 1 711 484  |  Fax: +265 (0) 1 711 486
>>>
>>> skalyati@xxxxxxxxxxxxx  <kmalewezi@xxxxxxxxxxxxx%C2%A0>|
>>> www.psi.org/malawi
>>>
>>> Skype: stanley.kalyati1  | Gmail: skalyati@xxxxxxxxx
>>>
>>>
>>>
>>>
>>> On 12 February 2014 10:51, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>>>
>>>> Hi Stanley,
>>>>
>>>> I think the "table not valid" message comes when the process tries to
>>>> generate anlytics for events (ie the tracker component). If you don't have
>>>> tracker data/events that is normal. Is this working for the
>>>> routine/aggregate data? We can improve that user message, I can see its
>>>> confusing.
>>>>
>>>> regards,
>>>>
>>>> Lars
>>>>
>>>>
>>>>
>>>> On Wed, Feb 12, 2014 at 9:12 AM, Stanley Kalyati <
>>>> skalyati@xxxxxxxxxxxxx> wrote:
>>>>
>>>>> Dear Colleagues,
>>>>>
>>>>> I have developed a small program with DHIS2 Live 2.14.
>>>>>
>>>>> whenever i want to run the Analytics,i keep getting this message:
>>>>> "Table Not valid,aborted Update"
>>>>>
>>>>> Where am i missing the point?
>>>>>
>>>>> Thank you.
>>>>>
>>>>>
>>>>> *Stanley Kalyati | Monitoring and Evaluation Technical Lead *
>>>>>
>>>>> *PSI/Malawi*
>>>>> Head Office & Main Warehouse,Off M1 Road,Kanengo,Area 28 Plot 198
>>>>>
>>>>> PO Box 30132, Capital City, Lilongwe 3 Malawi
>>>>>
>>>>>
>>>>> Tel: +265 (0) 1 711 484  |  Fax: +265 (0) 1 711 486
>>>>>
>>>>> skalyati@xxxxxxxxxxxxx  <kmalewezi@xxxxxxxxxxxxx%C2%A0>|
>>>>> www.psi.org/malawi
>>>>>
>>>>> Skype: stanley.kalyati1  | Gmail: skalyati@xxxxxxxxx
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>>
>>>>>
>>>>
>>>
>>
>