← Back to team overview

dhis2-devs team mailing list archive

Re: Problems with creating an SQL view in 2.16

 

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
>
>

Follow ups

References