Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Morten Olav Hansen
If you see duplicate UIDs, you can get new fresh ones at: /api/system/uid?n=100 -- Morten On Fri, Jul 24, 2015 at 2:14 AM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Lorill, You can try and execute this script (at your own risk against a non-production database) and see if it

Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Lorill Crees
Thanks Morten. On Thu, Jul 23, 2015 at 12:36 PM, Morten Olav Hansen morte...@gmail.com wrote: If you see duplicate UIDs, you can get new fresh ones at: /api/system/uid?n=100 -- Morten On Fri, Jul 24, 2015 at 2:14 AM, Jason Pickering jason.p.picker...@gmail.com wrote: Hi Lorill, You

Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Bob Jolliffe
I know that openmrs makes use of liquibase for managing database diffs : http://www.liquibase.org/ It might be worth considering whether this approach would be useful for us in place of our hibernate ddl + extra sql upgrade script . Student project? On 23 July 2015 at 20:36, Morten Olav Hansen

Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Morten Olav Hansen
Hi Lorill This is known issue with older versions of DHIS 2 (it was a serious bug in hibernate, which we use as our ORM layer). Jason created a script that will add them back (but please know that there might be conflicts, as uniqueness constraints are added) I'm adding him in, as I don't have

Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Jason Pickering
Hi Lorill, You can try and execute this script (at your own risk against a non-production database) and see if it solves the issues you are having. As Morten points out, there is no guarantee it will work, since you have been operating on a database without the constraints. But it may give you

Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Lorill Crees
Thanks Morten, looking forward to getting the script as that will save a lot of manual effort. Perhaps the script could be included or referenced in the upgrade notes here? https://github.com/dhis2/dhis2-utils/blob/master/resources/sql/upgrade-219.sql Also wondering - we're using the latest DHIS

Re: [Dhis2-devs] Schema missing many unique constraints

2015-07-23 Thread Morten Olav Hansen
No, hibernate can't make those can't of changes automatically, which is why Jason created a more manual SQL script for it, hibernate is good at adding columns etc, but can't change the constraints of an already existing column. I agree it should be added on the upgrade page, but its been there