Hi all,
Some more detail on the issue:
The instance in question is using 2.18 Build 18121 running on top of
PostgreSQL 9.4. There is no issue EDITING DE's, and no other issues that I
am aware of at the moment.
The system stays up and continues to process requests thereafter.
Excerpt of the log:
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"active" violates not-null constraint
Detail: Failing row contains (2917, k4pyjcqlU12, null, 2015-02-05
08:39:24.971, 2015-02-05 08:39:24.984, Complaint an$
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorI
mpl.java:2198)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.ja
va:1927)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:561)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2St
atement.java:419)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2State
ment.java:365)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPre
paredStatement.java:105)
at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultS
etReturnImpl.java:133)
Kind regards,
Jason.
From: Dhis2-users
[mailto:dhis2-users-bounces+jason=hisp....@lists.launchpad.net] On Behalf Of
Jason Phillips
Sent: 05 February 2015 08:47 AM
To: 'DHIS 2 Users List'
Subject: [Dhis2-users] Error Adding Data Elements
Hi all,
We have an odd one:
When trying to add a new Data Element, dhis 2.18 throws an exception in the
UI ("sorry, the system failed to.") and the logs show a "null value in
column 'active'" (Data Integrity Exception Violation) error.
I get the meaning - for some reason the new DE doesn't have a value for
'active', which obviously cannot be null. But what would cause this, and
more importantly, how do I fix it?
Kind Regards,
Jason Phillips
hisp
Software & Information Systems
Health Information Systems Program
-------------------------------------------------------------
eMail:
<mailto:ja...@hisp.org> ja...@hisp.org
Landline:
+27 21 712 0170
Mobile:
+27 72 973 7250
Skype:
jason.n.phillips
This message and any attachments are subject to a disclaimer published at
<http://www.hisp.org/policies.html#comms_disclaimer>
http://www.hisp.org/policies.html#comms_disclaimer. Please read the
disclaimer before opening any attachment or taking any other action in terms
of this electronic transmission.
If you cannot access the disclaimer, kindly send an email to
<mailto:disclai...@hisp.org> disclai...@hisp.org and a copy will be provided
to you. By replying to this e-mail or opening any attachment you agree to be
bound by the provisions of the disclaimer.
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
