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 [email protected] <[email protected]%C2%A0>| www.psi.org/malawi Skype: stanley.kalyati1 | Gmail: [email protected] On 12 February 2014 11:11, Lars Helge Øverland <[email protected]> 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 > <[email protected]>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 >> >> [email protected] <[email protected]%C2%A0>| >> www.psi.org/malawi >> >> Skype: stanley.kalyati1 | Gmail: [email protected] >> >> >> >> >> On 12 February 2014 11:03, Stanley Kalyati <[email protected]>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 >>> >>> [email protected] <[email protected]%C2%A0>| >>> www.psi.org/malawi >>> >>> Skype: stanley.kalyati1 | Gmail: [email protected] >>> >>> >>> >>> >>> On 12 February 2014 10:51, Lars Helge Øverland <[email protected]>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 < >>>> [email protected]> 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 >>>>> >>>>> [email protected] <[email protected]%C2%A0>| >>>>> www.psi.org/malawi >>>>> >>>>> Skype: stanley.kalyati1 | Gmail: [email protected] >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Mailing list: https://launchpad.net/~dhis2-users >>>>> Post to : [email protected] >>>>> Unsubscribe : https://launchpad.net/~dhis2-users >>>>> More help : https://help.launchpad.net/ListHelp >>>>> >>>>> >>>> >>> >> >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
