dhis2-users team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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
>