dhis2-users team mailing list archive

[Stanley Kalyati <skalyati@xxxxxxxxxxxxx>]

Lars,

On another instance,this is what am getting:

 2014-02-12 10:08:46

Process failed: Exception during execution

2014-02-12 10:08:46

Populating analytics tables

2014-02-12 10:08:46

Creating analytics tables

2014-02-12 10:08:46

Updating analytics tables

2014-02-12 10:08:45

Updating resource tables

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 11:16, Stanley Kalyati <skalyati@xxxxxxxxxxxxx> wrote:

> 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
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>