dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Looks like there was an attempt to fix this in rev 14845, but still not
working for me.

We are using

Version:2.16Build revision:16370
Probably could be hacked rather easily, but not sure if things are still
not fixed properly in the startup routines?
Regards,Jason
Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"viewid" violates not-null constraint
  Detail: Failing row contains (null, test sql view, , SELECT uid, name
from organisationunit LIMIT 10;, bMTwKD2Vpe0, null, 2014-08-28
07:41:46.921, 4511, 2014-08-28 07:41:46.921, 2361, rw------).
        at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
        at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
        at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
        at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
        at
org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)