dhis2-users team mailing list archive

[Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx>]

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 <busoye@xxxxxxxx> 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 <jmalcantara1@xxxxxxxxx> wrote:
> 
>> Did you upgrade from 2.11 to 2.12?
>> JM
>> 
>> El 28/08/2013, a las 05:42, Adebusoye Anifalaje <busoye@xxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>> 
>