-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 11.2.3
-
Labels:None
-
Funded by:
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)