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
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
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "validationgroupid" violates not-null constraint
I am using DHIS2.12 build 11290
Does anyone know what's happening here?
Thanks
Busoye
juan
28 August 2013 13:15
2
Did you upgrade from 2.11 to 2.12?
···
El 28/08/2013, a las 05:42, Adebusoye Anifalaje <busoye@hisp.org> 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
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
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "validationgroupid" violates not-null constraint
I am using DHIS2.12 build 11290
Does anyone know what's happening here?
Thanks
Busoye
_______________________________________________DHIS 2 developers in Launchpad DHIS 2 developers in Launchpad ListHelp - Launchpad Help
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@gmail.com> wrote:
Did you upgrade from 2.11 to 2.12?
El 28/08/2013, a las 05:42, Adebusoye Anifalaje <busoye@hisp.org> 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
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
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "validationgroupid" violates not-null constraint
I am using DHIS2.12 build 11290
Does anyone know what's happening here?
Thanks
Busoye
_______________________________________________DHIS 2 developers in Launchpad DHIS 2 developers in Launchpad ListHelp - Launchpad Help
juan
28 August 2013 20:30
4
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.
···
El 28/08/2013, a las 12:13, Adebusoye Anifalaje <busoye@hisp.org> 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@gmail.com> wrote:
Did you upgrade from 2.11 to 2.12?
El 28/08/2013, a las 05:42, Adebusoye Anifalaje <busoye@hisp.org> 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
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
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column "validationgroupid" violates not-null constraint
I am using DHIS2.12 build 11290
Does anyone know what's happening here?
Thanks
Busoye
_______________________________________________DHIS 2 developers in Launchpad DHIS 2 developers in Launchpad ListHelp - Launchpad Help
Lars
1 September 2013 18:27
5
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@gmail.com 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@hisp.org 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@gmail.com wrote:
Did you upgrade from 2.11 to 2.12?
JM
El 28/08/2013, a las 05:42, Adebusoye Anifalaje busoye@hisp.org 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
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 Wed, Aug 28, 2013 at 10:30 PM, Juan Manuel Alcantara Acosta jmalcantara1@gmail.com 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@hisp.org 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@gmail.com wrote:
Did you upgrade from 2.11 to 2.12?
JM
El 28/08/2013, a las 05:42, Adebusoye Anifalaje busoye@hisp.org 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@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp