dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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.pickering@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>