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 <bus...@hisp.org> 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 > <jmalcanta...@gmail.com> wrote: > >> Did you upgrade from 2.11 to 2.12? >> JM >> >> El 28/08/2013, a las 05:42, Adebusoye Anifalaje <bus...@hisp.org> 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 : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >> > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp