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

RS coaching tool if a group doesn't have any courses

    XMLWordPrintable

    Details

      Description

      It happens in the list of the groups if a group doesn't have any course

      2017-10-25 14:43:36,029 [ajp-nio2-8079-exec-5] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N79-E1 ^%^ org.olat.core.logging 
      
      https://sbs.olat.com/auth/CoachSite/0/Groups/0 ^%^ Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.62 Safari/537.36
      **RedScreen** org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>table</compname>
      		<compclass>org.olat.core.gui.components.table.Table</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.components.table.TableEvent</class&gt;
      			<command>r</command>
      			<tostring>cmd:r, rowId:1, actionId:select</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.core.gui.components.table.TableController</controllername>
      		<controllername>org.olat.modules.coach.ui.GroupListController</controllername>
      		<controllername>org.olat.modules.coach.ui.CoachMainController</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:549)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:242)
         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:289)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:232
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
      >>> stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:147)
         at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
         at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1423)
         at org.hibernate.query.Query.getResultList(Query.java:146)
         at org.olat.course.certificate.manager.CertificatesManagerImpl.getLastCertificates(CertificatesManagerImpl.java:549)
         at org.olat.modules.coach.ui.GroupController.loadModel(GroupController.java:236)
         at org.olat.modules.coach.ui.GroupController.<init>(GroupController.java:137)
         at org.olat.modules.coach.ui.GroupListController.selectGroup(GroupListController.java:200)
         at org.olat.modules.coach.ui.GroupListController.event(GroupListController.java:139)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:246)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
      >>> 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:111)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:80)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2123)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1911)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1887)
         at org.hibernate.loader.Loader.doQuery(Loader.java:932)
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:349) at org.hibernate.loader.Loader.doList(Loader.java:2615)
      >>> stack of 4.cause::org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Votes:
            0 Vote for this issue
            Watchers:
            1 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 minute
                1m