Details

      Description

      In a course with a test:

      • Go in archive tool
      • Go in "Tests and questionnaires"
      • Do the first workflow and deselect all checkbox in step "User restriction"
        -> Red screen
      2017-02-10 12:13:59,637 [ajp-nio2-8079-exec-8] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N79-E6 ^%^ org.olat.core.logging
      
      https://xyz.olat.com/auth/RepositoryEntry/19267627 ^%^ Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/56.0.2924.87 Safari/537.36
      **RedScreen** org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: query [select response from org.olat.ims.qti21.model.jpa.AssessmentResponseImpl response inner join fetch response.assessmentItemSession itemSession inner join fetch itemSession.assessmentTestSession testSession inner join fetch testSession.assessmentEntry assessmentEntry left join assessmentEntry.identity as ident left join ident.user as usr where testSession.testEntry.key=:testEntryKey and testSession.finishTime is not null and testSession.repositoryEntry.key=:repoEntryKey and testSession.subIdent=:subIdent and () order by usr.lastName, testSession.key, itemSession.key]
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_stepslayout</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class>org.olat.core.gui.control.Event</class>
      			<command>validation next</command>
      			<tostring>com:validation next,org.olat.core.gui.control.Event@f8569659</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.ims.qti.export.Archive_2_UserSelectionStep$UserRestrictionsController</controllername>
      		<controllername>org.olat.core.gui.control.generic.wizard.StepsMainRunController</controllername>
      		<controllername>org.olat.ims.qti.export.CourseQTIArchiveController</controllername>
      		<controllername>org.olat.course.archiver.ArchiverMainController</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.hql.internal.ast.QuerySyntaxException: unexpected AST node: query [select response from org.olat.ims.qti21.model.jpa.AssessmentResponseImpl response inner join fetch response.assessmentItemSession itemSession inner join fetch itemSession.assessmentTestSession testSession inner join fetch testSession.assessmentEntry assessmentEntry left join assessmentEntry.identity as ident left join ident.user as usr where testSession.testEntry.key=:testEntryKey and testSession.finishTime is not null and testSession.repositoryEntry.key=:repoEntryKey and testSession.subIdent=:subIdent and () order by usr.lastName, testSession.key, itemSession.key]
      -> 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:273)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:190)
         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::java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: query [select response from org.olat.ims.qti21.model.jpa.AssessmentResponseImpl response inner join fetch response.assessmentItemSession itemSession inner join fetch itemSession.assessmentTestSession testSession inner join fetch testSession.assessmentEntry assessmentEntry left join assessmentEntry.identity as ident left join ident.user as usr where testSession.testEntry.key=:testEntryKey and testSession.finishTime is not null and testSession.repositoryEntry.key=:repoEntryKey and testSession.subIdent=:subIdent and () order by usr.lastName, testSession.key, itemSession.key]
      -> at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:131)
         at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)
         at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:162)
         at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:662)
         at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
         at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
         at org.olat.ims.qti21.manager.AssessmentResponseDAO.getResponse(AssessmentResponseDAO.java:171)
         at org.olat.ims.qti21.manager.archive.QTI21ArchiveFormat.export(QTI21ArchiveFormat.java:263)
         at org.olat.ims.qti.export.QTIArchiver.exportQTI21(QTIArchiver.java:271)
         at org.olat.ims.qti.export.QTIArchiver.export(QTIArchiver.java:262)
         at org.olat.ims.qti.export.CourseQTIArchiveController$FinishArchive.execute(CourseQTIArchiveController.java:145)
      >>> stack of 3.cause::org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected AST node: query [select response from org.olat.ims.qti21.model.jpa.AssessmentResponseImpl response inner join fetch response.assessmentItemSession itemSession inner join fetch itemSession.assessmentTestSession testSession inner join fetch testSession.assessmentEntry assessmentEntry left join assessmentEntry.identity as ident left join ident.user as usr where testSession.testEntry.key=:testEntryKey and testSession.finishTime is not null and testSession.repositoryEntry.key=:repoEntryKey and testSession.subIdent=:subIdent and () order by usr.lastName, testSession.key, itemSession.key]
      -> at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74)
         at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:91)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:267)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
         at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
         at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
         at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
         at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:545)
         at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:654)
         at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
      

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              srosse Stéphane Rossé
            • 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, 10 minutes
                1h 10m