dhis2-users team mailing list archive

[Adebusoye Anifalaje <busoye@xxxxxxxx>]

Thanks Lars,

This has solved the problem.

 Just in case anyone else experiences this problem, you might get an error message saying the column can't be deleted because other objects depend on it.. just add CASCADE to the SQL statement i.e.

> alter table validationrulegroup drop column validationgroupid CASCADE;

Cheers

Busoye


On 1 Sep 2013, at 19:27, Lars Helge Øverland <larshelge@xxxxxxxxx> wrote:

> Hi Busoye,
> 
> sorry about that, what you need to do is to drop a column by running the following SQL:
> 
> alter table validationrulegroup drop column validationgroupid;
> 
> 
> 
> regards,
> 
> Lars
> 
> 
> On Wed, Aug 28, 2013 at 10:30 PM, Juan Manuel Alcantara Acosta <jmalcantara1@xxxxxxxxx> wrote:
> 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
> >>
> >
> 
> 
> _______________________________________________
> 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
>