Re: [Dhis2-users] [Dhis2-devs] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Bob Jolliffe
Yes that does help. And the upgrade notes tell you to do this. Unfortunately when users create views directly through the database rather than through the application they need to be tracked down and removed. Fortunately all these were prefixed with _view so I could grab them all with 'pg_dump -s

Re: [Dhis2-users] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Bob Jolliffe
Thanks all. The startup routines should take care of all this stuff without the need for running manual queries. And indeed they do unless they fail - which as Dan says they do horribly when they do, I have deleted the offending views and everything started up fine. On 22 July 2016 at 14:33, Mi

Re: [Dhis2-users] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Michael Mwebaze
Hi Bob, Can you update the dataelement table on postgres by running an update query and setting the aggregationtype to 'SUM' where it is 'sum'? UPDATE dataelement set aggregationtype = 'SUM' where aggregationtype = 'sum'; Regards, Michael On 22 July 2016 at 09:09, Bob Jolliffe wrote: > Hi

Re: [Dhis2-users] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Timothy Harding
Unfortunately, I do not have a query that will quickly uppercase that column, but here is the mapping I used when doing my 2.20 -> 2.21 though: sum SUM average AVERAGE_SUM_ORG_UNIT avg AVERAGE count COUNT stddev STDDEV variance VARIANCE min MIN max MAX I'm surprised that somehow "average" was upda

[Dhis2-users] Problem upgrading from 2.20 to 2.21

2016-07-22 Thread Bob Jolliffe
Hi After upgrading from 2.20 to 2.21 system is failing to start with: ERROR 2016-07-22 09:01:36,593 java.lang.IllegalArgumentException: Unknown name value [avg_sum_org_unit] for enum class [org.hisp.dhis.analytics.AggregationType] This looks like one of those new enum upper case restrictions. D

Re: [Dhis2-users] Unfortunately DHIS2 Tracker Capture has stopped error message

2016-07-22 Thread Erling Fjelstad
Hi Chandrasekar, Can you please explain how you managed to make the app to crash? Regards, Erling On Fri, Jul 22, 2016 at 11:17 AM, Chandrasekar Ravi wrote: > Dear Team, > > When I am trying to enter the data Tracker Capture Mobile App displaying > *Unfortunately > DHIS2 Tracker Capture has st

[Dhis2-users] PROGRAM WITH ATTRIBUTES

2016-07-22 Thread tuzo engelbert
Dear Team, I have created a program but when trying assigning attributes to program it gives an error and then not assigning it. when i looked to logs its shows that its sending an empty programattributeid to programattribute table which violents the contraints. i have tried to use dhis 2.22 and 2

Re: [Dhis2-users] [Dhis2-devs] DHIS2 version 2.24

2016-07-22 Thread Bridget Magoba
Let me try that, thanks From: Sergio Valenzuela [mailto:sergio.valenzu...@ehas.org] Sent: Friday, July 22, 2016 11:39 AM To: Bridget Magoba Cc: DHIS 2 Users List; dhis2-devs Subject: Re: [Dhis2-devs] DHIS2 version 2.24 Hi, I have had similar problems with the last build. I suggest you to de

Re: [Dhis2-users] [Dhis2-devs] DHIS2 version 2.24

2016-07-22 Thread Sergio Valenzuela
Hi, I have had similar problems with the last build. I suggest you to deploy 2.23 and add the org units and option sets there. Once you have done it, you can update to 2.24 and it should work, at least it did for me. Hope it helps ;) *Sergio Valenzuela* Fundación EHAS Telemedicina para países en

[Dhis2-users] DHIS2 version 2.24

2016-07-22 Thread Bridget Magoba
Dear all, I have just deployed version 2.24, started adding organization units and option sets but the system freezes. It fails to load the org units or option sets, can't add new or even edit. What could be the problem with my setup? Please help Magoba Bridget Database Manager MIFUM