Hi Jason, can you execute this on your db and see if the query fails, if so provide the log?
alter table sqlview drop column viewid; regards, Lars On Thu, Aug 28, 2014 at 9:43 AM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Looks like there was an attempt to fix this in rev 14845, but still not > working for me. > > We are using > > Version:2.16 Build 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) > > > _______________________________________________ > 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
