dhis2-users team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

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
>