Hi Busoye, sorry about that, what you need to do is to drop a column by running the following SQL:
alter table validationrulegroup drop column validationgroupid; regards, Lars On Wed, Aug 28, 2013 at 10:30 PM, Juan Manuel Alcantara Acosta < [email protected]> wrote: > I had the same problem upgrading from 2.11 to 2.12 and found a work > around, you need to have at least one validation rule group before doing > the upgrade. > Regards, > JM > > El 28/08/2013, a las 12:13, Adebusoye Anifalaje <[email protected]> > escribió: > > > Hi Juan, > > > > I didn't upgrade from 2:11. The file was converted from DHIS1.4 > > > > Busoye > > > > > > On 28 Aug 2013, at 15:15, Juan Manuel Alcantara Acosta < > [email protected]> wrote: > > > >> Did you upgrade from 2.11 to 2.12? > >> JM > >> > >> El 28/08/2013, a las 05:42, Adebusoye Anifalaje <[email protected]> > escribió: > >> > >>> Dear all, > >>> > >>> We receive an error message when trying to add a validation rule to a > group. > >>> > >>> I noticed that during start up, there is an error message: > >>> > >>> * ERROR 2013-08-28 12:24:32,468 HHH000388: Unsuccessful: alter table > validationrulegroupmembers add constraint > fk_validationrulegroupmembers_validatio > >>> nrulegroupid foreign key (validationgroupid) references > validationrulegroup (SchemaUpdate.java [pool-2-thread-1]) > >>> * ERROR 2013-08-28 12:24:32,468 ERROR: constraint > "fk_validationrulegroupmembers_validationrulegroupid" for relation > "validationrulegroupmembers" already exists (SchemaUpdate.java > [pool-2-thread-1]) > >>> > >>> > >>> The error message during the operation is: > >>> > >>> * ERROR 2013-08-28 12:25:53,515 ERROR: null value in column > "validationgroupid" violates not-null constraint > >>> Detail: Failing row contains (null, null, null, null, null, > palidusime, , 2562). (SqlExceptionHelper.java [http-apr-8080-exec-5]) > >>> * ERROR 2013-08-28 12:25:53,531 Error while executing action > (ExceptionInterceptor.java [http-apr-8080-exec-5]) > >>> org.springframework.dao.DataIntegrityViolationException: could not > execute statement; SQL [n/a]; constraint [validationgroupid]; nested > exception is org.hibernate.exception.ConstraintViolationException: could > not execute statement > >>> > >>> Caused by: org.postgresql.util.PSQLException: ERROR: null value in > column "validationgroupid" violates not-null constraint > >>> Detail: Failing row contains (null, null, null, null, null, > palidusime, , 2562). > >>> > >>> I am using DHIS2.12 build 11290 > >>> > >>> > >>> Does anyone know what's happening here? > >>> > >>> Thanks > >>> > >>> Busoye > >>> > >>> > >>> _______________________________________________ > >>> Mailing list: https://launchpad.net/~dhis2-devs > >>> Post to : [email protected] > >>> Unsubscribe : https://launchpad.net/~dhis2-devs > >>> More help : https://help.launchpad.net/ListHelp > >> > > > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
