← Back to team overview

dhis2-devs team mailing list archive

[Bug 914980] Re: data-visualizer-favorites-throws-sql-error

 

Sometimes the hibernate schema update tool is a bit funny.. Works fine
on my databases here. I think sometimes we just need to help hibernate a
bit by doing manual schema updates.

** Changed in: dhis2
       Status: New => Won't Fix

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/914980

Title:
  data-visualizer-favorites-throws-sql-error

Status in DHIS 2 - District Health Information Software:
  Won't Fix

Bug description:
  While attempting to save a chart to the favorites I see this..


  Caused by: org.postgresql.util.PSQLException: ERROR: column this_.targetline does not exist
    Position: 410
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
          at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
          at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
          at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
          at org.hibernate.loader.Loader.doQuery(Loader.java:802)
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
          at org.hibernate.loader.Loader.doList(Loader.java:2533)
          ... 111 more

  
  The UI freezes. 

  Same problem happens when accessing the dashboard, except the same
  error is thrown to the UI.

  Version:
  2.6
  Build revision:
  5646

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/914980/+subscriptions


References