← Back to team overview

dhis2-devs team mailing list archive

Exception when importing metadata dataelements

 

Hi Devs

 

I am receiving this exception:-

 

Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"active" violates not-null constraint

  Detail: Failing row contains (10248, X9TfdT6JLNJ, null, 2015-03-31
19:43:09.306, 2015-03-31 19:43:12.352, Sub-dermal implant inserted,
Sub-dermal implant insert, Sub-dermal contraceptive implant inserted just
under the skin of..., null, null, int, number, null, AGGREGATE, sum, 14,
null, null, t, null, --------, null, null, null).

        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)

        ... 31 more

 

What position in the csv file must the active field be in or is this a bug?

Attached is my csv file.

 

Regards

Pooben

Attachment: csv_Import.csv
Description: MS-Excel spreadsheet


Follow ups