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

RS when searching data collections of a questionnaire

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 15.4.3
    • Component/s: QM
    • Labels:
      None

      Description

      java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: 'survey.formEntry' [select count(collection)  from org.olat.modules.quality.model.QualityDataCollectionImpl as collection       join survey.formEntry as form where form.key in (:formKeys) and (collection.key in (select collectionToOrganisation.dataCollection.key  from org.olat.modules.quality.model.QualityDataCollectionToOrganisationImpl as collectionToOrganisation  where collectionToOrganisation.organisation.key in :organisationKeys) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl ra       join ra.dataCollection dc       join org.olat.modules.quality.model.QualityContextImpl as context         on context.dataCollection.key = dc.key       join org.olat.repository.model.RepositoryEntryToGroupRelation as rel         on rel.entry.key = context.audienceRepositoryEntry.key       join org.olat.basesecurity.model.GroupMembershipImpl as membership         on membership.group.key = rel.group.key where ra.online = true   and ra.type = 'GroupRoles'   and dc.status = 'FINISHED'   and membership.role = ra.role   and membership.identity.key = :reportAccessIdentityKey) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl ra       join ra.dataCollection dc       join org.olat.modules.quality.model.QualityContextImpl as context         on context.dataCollection.key = dc.key       join org.olat.modules.curriculum.model.CurriculumElementImpl as ele         on ele.key = context.audienceCurriculumElement.key       join org.olat.basesecurity.model.GroupMembershipImpl as membership         on membership.group.key = ele.group.key   where ra.online = true   and ra.type = 'GroupRoles'   and dc.status = 'FINISHED'   and membership.role = ra.role   and membership.identity.key = :reportAccessIdentityKey) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl as ra       join ra.dataCollection dc       join org.olat.modules.forms.model.jpa.EvaluationFormSurveyImpl survey         on survey.resId = dc.key        and survey.resName = 'datacollection'       join org.olat.modules.forms.model.jpa.EvaluationFormParticipationImpl as participation         on participation.survey.key = survey.key   where ra.online = true   and ra.type = 'Participants'   and dc.status = 'FINISHED'   and ((ra.role is null) or (participation.status = ra.role))   and participation.executor.key = :reportAccessIdentityKey) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl as ra       join ra.dataCollection dc where ra.online = true   and ra.type = 'TopicIdentity'   and dc.status = 'FINISHED'   and dc.topicIdentity.key = :reportAccessIdentityKey) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl as ra       join ra.dataCollection dc       join org.olat.basesecurity.model.GroupMembershipImpl as membership         on  membership.group.key = ra.group.key where ra.online = true   and ra.type = 'ReportMember'   and dc.status = 'FINISHED'   and membership.identity.key = :reportAccessIdentityKey) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl as ra       join ra.dataCollection dc       join org.olat.basesecurity.model.IdentityToIdentityRelationImpl as identRel         on identRel.target.key = dc.topicIdentity.key       join org.olat.basesecurity.model.RelationRoleToRightImpl as roleRel         on roleRel.role.key = identRel.role.key where ra.online = true   and ra.type = 'RelationRole'   and dc.status = 'FINISHED'   and cast(identRel.role.key as string) = ra.role   and roleRel.right.right = 'selectableQualityReportAccess'   and identRel.source.key = :reportAccessIdentityKey) or collection.key in (select ra.dataCollection.key  from org.olat.modules.quality.model.QualityReportAccessImpl ra       join ra.dataCollection dc       join org.olat.modules.quality.model.QualityContextImpl as context         on context.dataCollection.key = dc.key       join org.olat.repository.model.RepositoryEntryToOrganisationImpl as re_org         on re_org.entry.key = context.audienceRepositoryEntry.key        and re_org.organisation.key in (:learnResourceManagerKeys) where ra.online = true   and ra.type = 'LearnResourceManager'   and dc.status = 'FINISHED'))]
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138) ~[hibernate-core-5.4.28.Final.jar:5.4.28.Final]
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.4.28.Final.jar:5.4.28.Final]
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.4.28.Final.jar:5.4.28.Final]
      	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:734) ~[hibernate-core-5.4.28.Final.jar:5.4.28.Final]
      	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:825) ~[hibernate-core-5.4.28.Final.jar:5.4.28.Final]
      	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) ~[hibernate-core-5.4.28.Final.jar:5.4.28.Final]
      	at org.olat.modules.quality.manager.QualityDataCollectionDAO.getDataCollectionCount(QualityDataCollectionDAO.java:404) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.modules.quality.manager.QualityServiceImpl.getDataCollectionCount(QualityServiceImpl.java:380) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionDataSource.getRowCount(DataCollectionDataSource.java:77) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.loadDatas(DefaultFlexiTableDataSourceModel.java:221) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.load(DefaultFlexiTableDataSourceModel.java:183) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableElementImpl.reloadData(FlexiTableElementImpl.java:1882) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableElementImpl.reset(FlexiTableElementImpl.java:1859) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionListController.doExtendedSearch(DataCollectionListController.java:321) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionListController.event(DataCollectionListController.java:230) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:258) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:255) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:202) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionSearchController.fireSearchEvent(DataCollectionSearchController.java:254) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionSearchController.formInnerEvent(DataCollectionSearchController.java:174) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:431) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:136) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:743) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.FormLinkImpl.dispatchFormRequest(FormLinkImpl.java:270) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:568) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:317) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:105) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1258) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.Window.dispatchRequest(Window.java:433) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:313) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:278) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:183) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:297) ~[classes/:15.4-SNAPSHOT]
      	at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:227) ~[classes/:15.4-SNAPSHOT]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:661) ~[servlet-api.jar:?]
      	at org.olat.core.servlets.OpenOLATServlet.service(OpenOLATServlet.java:159) ~[classes/:15.4-SNAPSHOT]
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[servlet-api.jar:?]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) ~[catalina.jar:8.5.13]
      	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-websocket.jar:8.5.13]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) ~[catalina.jar:8.5.13]
      	at org.olat.core.servlets.HeadersFilter.doFilter(HeadersFilter.java:64) ~[classes/:15.4-SNAPSHOT]
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) ~[catalina.jar:8.5.13]
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) ~[catalina.jar:8.5.13]
      	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:486) ~[tomcat-coyote.jar:8.5.13]
      	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) ~[tomcat-coyote.jar:8.5.13]
      	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861) ~[tomcat-coyote.jar:8.5.13]
      	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455) ~[tomcat-coyote.jar:8.5.13]
      	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-coyote.jar:8.5.13]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) ~[?:?]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) ~[?:?]
      	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-util.jar:8.5.13]
      	at java.lang.Thread.run(Thread.java:834) [?:?]
      

        Figma for Jira By 42nd

          Attachments

            Activity

              People

              Assignee:
              uhensler Urs Hensler
              Reporter:
              gnaegi Florian Gn├Ągi
              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 - 15 minutes
                  15m