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 [email protected] <[email protected]%C2%A0>| www.psi.org/malawi Skype: stanley.kalyati1 | Gmail: [email protected] On 12 February 2014 11:16, Stanley Kalyati <[email protected]> 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 > > [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
