Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-678

postgresql update has missing tables

    XMLWordPrintable

    Details

      Description

      After updating openolat 8.4.0 to 9.0 got following exception while login:

      Throwable: javax.persistence.PersistenceException

      message:org.hibernate.exception.SQLGrammarException: could not extract ResultSet,javax.persistence.PersistenceException

      at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
      at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
      at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:275)
      at org.olat.group.manager.BusinessGroupDAO.findBusinessGroup(BusinessGroupDAO.java:483)
      at org.olat.group.manager.BusinessGroupServiceImpl.findBusinessGroups(BusinessGroupServiceImpl.java:649)
      at org.olat.group.ui.portlet.GroupsPortletRunController.reloadModel(GroupsPortletRunController.java:166)
      at org.olat.group.ui.portlet.GroupsPortletRunController.(GroupsPortletRunController.java:124)
      at org.olat.group.ui.portlet.GroupsPortlet.getInitialRunComponent(GroupsPortlet.java:86)
      at org.olat.core.gui.control.generic.portal.PortletContainer.initializeRunComponent(PortletContainer.java:117)
      at org.olat.core.gui.control.generic.portal.PortalImpl.initPortlets(PortalImpl.java:259)

      1. cause:

      message:could not extract ResultSet,org.hibernate.exception.SQLGrammarException

      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:123)
      at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
      at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:61)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2040)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1837)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1816)
      at org.hibernate.loader.Loader.doQuery(Loader.java:900)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:342)

      2. cause:

      message:ERROR: relation "o_gp_member_v" does not exist
      Position: 231,org.postgresql.util.PSQLException

      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:116)
      at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:56)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:2040)
      at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1837)

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              jkraehemann Joël Krähemann
              Tester:
              Joël Krähemann
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours
                2h