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

RS: in open groups table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 13.2.2
    • Component/s: Group
    • Labels:
      None

      Description

      This only happens if you have more the 64 groups published:

      09:30:36,547 ERROR OLATRuntimeException:175 - OLAT::ERROR ^%^ N1-E5 ^%^ org.olat.core.logging
      http://localhost:8080/auth/GroupsSite/0/AllGroups/0
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_3) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/12.0.3 Safari/605.1.15
      **RedScreen** org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>segments</compname>
      		<compclass>org.olat.core.gui.components.segmentedview.SegmentViewComponent</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.components.segmentedview.SegmentViewEvent</class&gt;
      			<command>seg-view-selection</command>
      			<tostring>com:seg-view-selection,org.olat.core.gui.components.segmentedview.SegmentViewEvent@67ce60fb</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.group.ui.main.OverviewBusinessGroupListController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      >>>stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.olat.core.gui.exception.ExceptionWindowController.<init>(ExceptionWindowController.java:116)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:57)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:46)
         at org.olat.core.gui.components.Window.dispatchRequest(Window.java:589)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:282)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:273)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:190)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:294)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:237)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
      >>>stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
         at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
         at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1538)
         at org.hibernate.query.Query.getResultList(Query.java:168)
         at org.olat.group.manager.BusinessGroupDAO.loadRelations(BusinessGroupDAO.java:1241)
         at org.olat.group.manager.BusinessGroupDAO.searchPublishedBusinessGroups(BusinessGroupDAO.java:960)
         at org.olat.group.manager.BusinessGroupServiceImpl.findPublishedBusinessGroups(BusinessGroupServiceImpl.java:693)
         at org.olat.group.ui.main.OpenBusinessGroupListController.searchTableItems(OpenBusinessGroupListController.java:113)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.loadModel(AbstractBusinessGroupListController.java:1132)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.doDefaultSearch(AbstractBusinessGroupListController.java:949)
         at org.olat.group.ui.main.OverviewBusinessGroupListController.updateOpenGroups(OverviewBusinessGroupListController.java:241)
      >>>stack of 3.cause::org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:106)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2173)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1936)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1898)
         at org.hibernate.loader.Loader.doQuery(Loader.java:937)
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:340)
         at org.hibernate.loader.Loader.doList(Loader.java:2695)
      >>>stack of 4.cause::org.postgresql.util.PSQLException: ERROR: missing FROM-clause entry for table "olatresour5_"
        Position: 483
      -> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
         at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
         at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
         at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
         at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
         at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150)
         at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:113)
         at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:73)
         at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:73)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2173)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            stephan Stephan Clemenz
            Tester:
            Mandy Menzel
            Votes:
            0 Vote for this issue
            Watchers:
            2 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 - 1 hour, 35 minutes
                1h 35m