dhis2-users team mailing list archive

["Jason Phillips" <jason@xxxxxxxx>]

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.org@xxxxxxxxxxxxxxxxxxx] 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:jason@xxxxxxxx> jason@xxxxxxxx


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:disclaimer@xxxxxxxx> disclaimer@xxxxxxxx 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.