dhis2-users team mailing list archive

Thread
Date

Re: UNABLE TO COMPLETE ANALYTICS

To: Lars Helge Øverland <larshelge@xxxxxxxxx>
From: Stanley Kalyati <skalyati@xxxxxxxxxxxxx>
Date: Wed, 12 Feb 2014 16:17:41 +0200
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CADJLM2qscA42xQmuhLZkWk3UOsEbceg7Jrpnc80oGtmKtmOWUA@mail.gmail.com>

Lars,

I am still waiting for your assistance.

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

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

References

UNABLE TO COMPLETE ANALYTICS
From: Stanley Kalyati, 2014-02-12
Re: UNABLE TO COMPLETE ANALYTICS
From: Lars Helge Øverland, 2014-02-12
Re: UNABLE TO COMPLETE ANALYTICS
From: Stanley Kalyati, 2014-02-12
Re: UNABLE TO COMPLETE ANALYTICS
From: Stanley Kalyati, 2014-02-12
Re: UNABLE TO COMPLETE ANALYTICS
From: Lars Helge Øverland, 2014-02-12
Re: UNABLE TO COMPLETE ANALYTICS
From: Stanley Kalyati, 2014-02-12
Re: UNABLE TO COMPLETE ANALYTICS
From: Stanley Kalyati, 2014-02-12