dhis2-users team mailing list archive

[Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx>]

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