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

Cannot search groups by course title

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0.1
    • Component/s: Group
    • Labels:
      None

      Description

      In the group tab, the group search by course title produces a red screen

      RedScreen on commolat 10.0.0
      2014-09-02 16:57:55,375 [ajp-apr-8002-exec-3] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N2-E3 ^%^ org.olat.core.logging
      Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/37.0.2062.102 Safari/537.36 
      
      **RedScreen** org.hibernate.QueryException: could not resolve property: groupKey of:
      org.olat.group.model.BGRepositoryEntryRelation [select distinct(bgi) from org.olat.group.model.BusinessGroupViewImpl as bgi
      inner join fetch bgi.resource as bgResource
      inner join bgi.baseGroup as baseGroup
      where bgi.key in (select bgRel.groupKey from org.olat.group.model.BGRepositoryEntryRelation bgRel
          where bgRel.repositoryEntryDisplayName like :displayName
      ) and exists (select bmember from org.olat.basesecurity.model.GroupMembershipImpl as bmember
         where bmember.identity.key=:identId and bmember.group=baseGroup and bmember.role in (:roles)
      )
      order by bgi.name, bgi.key]
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_group_list</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>validation ok</command>
      			<tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.group.ui.main.BusinessGroupSearchController</controllername>
      		<controllername>org.olat.group.ui.main.BusinessGroupListController</controllername>
      		<controllername>org.olat.group.ui.main.OverviewBusinessGroupListController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      >>> stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.QueryException: could not resolve property: groupKey of: org.olat.group.model.BGRepositoryEntryRelation [select distinct(bgi) from org.olat.group.model.BusinessGroupViewImpl as bgi inner join fetch bgi.resource as bgResource inner join bgi.baseGroup as baseGroup where bgi.key in ( select bgRel.groupKey from org.olat.group.model.BGRepositoryEntryRelation bgRel where bgRel.repositoryEntryDisplayName like :displayName ) and exists (select bmember from org.olat.basesecurity.model.GroupMembershipImpl as bmember where bmember.identity.key=:identId and bmember.group=baseGroup and bmember.role in (:roles) ) order by bgi.name,bgi.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:524)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:228)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:192)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:241)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:197)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:265)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:208)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
      >>> stack of 2.cause::java.lang.IllegalArgumentException: org.hibernate.QueryException: could not resolve property: groupKey of: org.olat.group.model.BGRepositoryEntryRelation [select distinct(bgi) from org.olat.group.model.BusinessGroupViewImpl as bgi inner join fetch bgi.resource as bgResource inner join bgi.baseGroup as baseGroup where bgi.key in ( select bgRel.groupKey from org.olat.group.model.BGRepositoryEntryRelation bgRel where bgRel.repositoryEntryDisplayName like :displayName ) and exists (select bmember from org.olat.basesecurity.model.GroupMembershipImpl as bmember where bmember.identity.key=:identId and bmember.group=baseGroup and bmember.role in (:roles) ) order by bgi.name,bgi.key]
      -> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1750)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1683)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:350)
         at org.olat.group.manager.BusinessGroupDAO.createFindViewDBQuery(BusinessGroupDAO.java:911)
         at org.olat.group.manager.BusinessGroupDAO.findBusinessGroupViews(BusinessGroupDAO.java:726)
         at org.olat.group.manager.BusinessGroupServiceImpl.findBusinessGroupViews(BusinessGroupServiceImpl.java:676)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.searchBusinessGroupViews(AbstractBusinessGroupListController.java:1012)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.updateTableModel(AbstractBusinessGroupListController.java:1026)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.search(AbstractBusinessGroupListController.java:851)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.doSearch(AbstractBusinessGroupListController.java:830)
      >>> stack of 3.cause::org.hibernate.QueryException: could not resolve property: groupKey of: org.olat.group.model.BGRepositoryEntryRelation [select distinct(bgi) from org.olat.group.model.BusinessGroupViewImpl as bgi inner join fetch bgi.resource as bgResource inner join bgi.baseGroup as baseGroup where bgi.key in ( select bgRel.groupKey from org.olat.group.model.BGRepositoryEntryRelation bgRel where bgRel.repositoryEntryDisplayName like :displayName ) and exists (select bmember from org.olat.basesecurity.model.GroupMembershipImpl as bmember where bmember.identity.key=:identId and bmember.group=baseGroup and bmember.role in (:roles) ) order by bgi.name,bgi.key]
      -> at org.hibernate.QueryException.generateQueryException(QueryException.java:137)
         at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:120)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:234)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:158)
         at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:126)
         at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:88)
         at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:167)
         at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:301)
         at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:236)
         at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1800)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:342)
      >>> stack of 4.cause::org.hibernate.QueryException: could not resolve property: groupKey of: org.olat.group.model.BGRepositoryEntryRelation
      -> at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:83)
         at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:77)
         at org.hibernate.persister.entity.AbstractEntityPersister.toType(AbstractEntityPersister.java:1978)
         at org.hibernate.hql.internal.ast.tree.FromElementType.getPropertyType(FromElementType.java:367)
         at org.hibernate.hql.internal.ast.tree.FromElement.getPropertyType(FromElement.java:500)
         at org.hibernate.hql.internal.ast.tree.DotNode.getDataType(DotNode.java:652)
         at org.hibernate.hql.internal.ast.tree.DotNode.prepareLhs(DotNode.java:275)
         at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:219)
         at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:126)
         at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:121)
         at org.hibernate.hql.internal.ast.tree.DotNode.resolveSelectExpression(DotNode.java:711)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Votes:
            0 Vote for this issue
            Watchers:
            1 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 - 45 minutes
                45m