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

RS in QM if searching for questionnaire

    XMLWordPrintable

    Details

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

      Description

       org.hibernate.hql.internal.ast.QuerySyntaxException: Invalid path: 'form.key' [select count(collection)  from org.olat.modules.quality.model.QualityDataCollectionImpl as collection 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.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:74) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.hql.internal.ast.ErrorTracker.throwQueryException(ErrorTracker.java:93) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:282) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:113) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:604) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:716) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:816) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23) ~[hibernate-core-5.4.24.Final.jar:5.4.24.Final]
      	at org.olat.modules.quality.manager.QualityDataCollectionDAO.getDataCollectionCount(QualityDataCollectionDAO.java:397) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.manager.QualityServiceImpl.getDataCollectionCount(QualityServiceImpl.java:380) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionDataSource.getRowCount(DataCollectionDataSource.java:70) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.loadDatas(DefaultFlexiTableDataSourceModel.java:221) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.load(DefaultFlexiTableDataSourceModel.java:183) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableElementImpl.reloadData(FlexiTableElementImpl.java:1882) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableElementImpl.reset(FlexiTableElementImpl.java:1859) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionListController.doSearch(DataCollectionListController.java:332) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionListController.doExtendedSearch(DataCollectionListController.java:327) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionListController.event(DataCollectionListController.java:233) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:258) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:255) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:202) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionSearchController.fireSearchEvent(DataCollectionSearchController.java:254) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.modules.quality.ui.DataCollectionSearchController.formInnerEvent(DataCollectionSearchController.java:174) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormBasicController.event(FormBasicController.java:431) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:214) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent$1.run(AbstractComponent.java:240) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent.fireEvent(AbstractComponent.java:238) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.fireFormEvent(FormWrapperContainer.java:136) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.Form.fireFormEvent(Form.java:740) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.elements.FormLinkImpl.dispatchFormRequest(FormLinkImpl.java:270) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormItemImpl.doDispatchFormRequest(FormItemImpl.java:568) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.Form.evalFormRequest(Form.java:317) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer.doDispatchRequest(FormWrapperContainer.java:105) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:193) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.Window.doDispatchToComponent(Window.java:1258) ~[classes/:15.3-SNAPSHOT]
      	at org.olat.core.gui.components.Window.dispatchRequest(Window.java:433) ~[classes/:15.3-SNAPSHOT]
      	... 34 more
      

        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 - 20 minutes
                  20m