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

RS in QM if searching for questionnaire

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 15.3
    • 15.3.8
    • QM
    • 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
      

      Attachments

        Activity

          People

            uhensler Urs Hensler
            gnaegi Florian Gn├Ągi
            Mandy Menzel 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