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

RS in assessment tool if the coach of a group try to reset a QTI 2.1 test

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 11.1
    • Fix Version/s: 11.1.1
    • Component/s: None
    • Labels:
      None

      Description

      https://testing.frentix.com/test8/auth/RepositoryEntry/364150784/assessmentToolv2/0/BusinessGroups/0/Node/94625933291470
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_1) AppleWebKit/602.2.14 (KHTML, like Gecko) Version/10.0.1 Safari/602.2.14
      **RedScreen** org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_groups</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class>org.olat.core.gui.components.form.flexible.impl.elements.table.SelectionEvent</class>
      			<command>select</command>
      			<tostring>com:select,org.olat.core.gui.components.form.flexible.impl.elements.table.SelectionEvent@c9ff351b</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.course.assessment.ui.tool.AssessedBusinessGroupCourseNodeListController</controllername>
      		<controllername>org.olat.course.assessment.ui.tool.AssessedBusinessGroupListCourseTreeController</controllername>
      		<controllername>org.olat.course.assessment.ui.tool.AssessmentToolController</controllername>
      		<controllername>org.olat.course.run.CourseRuntimeController</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:548)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:241)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:275)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:192)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:292)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:235)
         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:1383)
         at org.hibernate.Query.getResultList(Query.java:417)
         at org.olat.group.manager.BusinessGroupRelationDAO.getMembers(BusinessGroupRelationDAO.java:286)
         at org.olat.group.manager.BusinessGroupServiceImpl.getMembers(BusinessGroupServiceImpl.java:1705)
         at org.olat.ims.qti21.ui.QTI21ResetToolController.initButton(QTI21ResetToolController.java:112)
         at org.olat.ims.qti21.ui.QTI21ResetToolController.<init>(QTI21ResetToolController.java:96)
         at org.olat.course.nodes.IQTESTCourseNode.createAssessmentTools(IQTESTCourseNode.java:243)
         at org.olat.course.assessment.ui.tool.IdentityListCourseNodeController.updateModel(IdentityListCourseNodeController.java:346)
         at org.olat.course.assessment.ui.tool.IdentityListCourseNodeController.activate(IdentityListCourseNodeController.java:417)
      >>>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:79)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2117)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1905)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1881)
         at org.hibernate.loader.Loader.doQuery(Loader.java:926)
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:343)
         at org.hibernate.loader.Loader.doList(Loader.java:2609)
      >>>stack of 4.cause::org.postgresql.util.PSQLException: ERROR: syntax error at or near ")"
      
      

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              sscheiwiler Sabrina Scheiwiler
            • 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 - 40 minutes
                40m