Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland
Hmm, yeah something doesn't seem right here. Not really familiar with the detailed workings of the analytics table creation process, though (Lars would be the one to ask). What's the schema for the left over analytics_temp_2015? Also, can you make sure to (manually) delete the temp table and re-run

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen
Hi Halvdan, No the analytics is still failing. Here is the log. I don’t quite understand what is wrong. What I can see in the database is because analytics is failing the table Analytics_2015_temp remains after the analytics fails. Regards, Elmarie Claasen Hisp logo Project Mana

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland
Hi, Yes, the first issue seems to be fixed (and there is no indication of faults in the log as you say). Why it didn't run properly before I don't know. As for the analytics: yes, analytics tables (named analytics_2014, analytics_2015 etc) er generated tables. If they do not exist, you might expe

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen
Hi Halvdan, I don’t see anything failing in the startup routine – here is the log of the first startup after the replaced the war file. Maybe the log should give an error if the tables was not successfully updated? Can you assist in how we fix the problem with the analytics table which st

Re: [Dhis2-users] [Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland
In addition; please look at the startup log of dhis2 (specifically under InitTableAlterator) and see if there's any queries failing. 2015-07-30 12:59 GMT+02:00 Abyot Gizaw : > > > On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen wrote: > >> Hi Devs, >> >> >> >> I have an urgent database issue wh