dhis2-users team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

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