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

Error in ItemView's query with order by

    XMLWordPrintable

    Details

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

      Description

      2013-10-24 16:02:58,421 [ajp-apr-8028-exec-8] ERROR DispatcherAction  - OLAT::ERROR ^%^ N28-E1 ^%^ org.olat.core.dispatcher 
      Mozilla/5.0 (Macintosh; Intel Mac OS X 10_8_5) AppleWebKit/536.30.1 (KHTML, like Gecko) Version/6.0.5 Safari/536.30.1 ^%^ Exception in DispatcherAction ^%^
      >>>stack of 1.cause::java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 376 [select item from org.olat.modules.qpool.model.ItemView item  where item in (select coll2item.item from org.olat.modules.qpool.model.CollectionToItem coll2item where coll2item.collection.key=:collectionKey) and (item.markCreatorKey=:ureqIdentityKey or item.markCreatorKey is null) and (item.ownerKey=:ureqIdentityKey or item.ownerKey is null) order by item.taxonomyLevel asc  order by item.key asc ]
      -> at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1374)
         at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
         at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:309)
         at org.olat.modules.qpool.manager.CollectionDAO.getItemsOfCollection(CollectionDAO.java:144)
         at org.olat.modules.qpool.manager.QuestionPoolServiceImpl.getItemsOfCollection(QuestionPoolServiceImpl.java:649)
         at org.olat.modules.qpool.ui.datasource.CollectionOfItemsSource.getItems(CollectionOfItemsSource.java:116)
         at org.olat.modules.qpool.ui.AbstractItemListController.getRows(AbstractItemListController.java:346)
         at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.loadDatas(DefaultFlexiTableDataSourceModel.java:201)
         at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.load(DefaultFlexiTableDataSourceModel.java:170)
         at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableElementImpl.doScroll(FlexiTableElementImpl.java:534)
         at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableModelMapper.handle(FlexiTableModelMapper.java:117)
      >>>stack of 2.cause::org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: order near line 1, column 376 [select item from org.olat.modules.qpool.model.ItemView item  where item in (select coll2item.item from org.olat.modules.qpool.model.CollectionToItem coll2item where coll2item.collection.key=:collectionKey) and (item.markCreatorKey=:ureqIdentityKey or item.markCreatorKey is null) and (item.ownerKey=:ureqIdentityKey or item.ownerKey is null) order by item.taxonomyLevel asc  order by item.key asc ]
      -> at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
         at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
         at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:277)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:181)
         at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:137)
         at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
         at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
         at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
         at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221)
         at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199)
      2013-10-24 16:03:54,685 [ajp-apr-8028-exec-4] ERROR ErrorCounter  - line 1:376: unexpected token: order
      2013-10-24 16:03:54,686 [ajp-apr-8028-exec-4] ERROR ErrorCounter  - line 1:376: unexpected token: order
      line 1:376: unexpected token: order
      	at org.hibernate.hql.internal.antlr.HqlBaseParser.orderElement(HqlBaseParser.java:2095)
      	at org.hibernate.hql.internal.antlr.HqlBaseParser.orderByClause(HqlBaseParser.java:1173)
      	at org.hibernate.hql.internal.antlr.HqlBaseParser.queryRule(HqlBaseParser.java:750)
      	at org.hibernate.hql.internal.antlr.HqlBaseParser.selectStatement(HqlBaseParser.java:294)
      	at org.hibernate.hql.internal.antlr.HqlBaseParser.statement(HqlBaseParser.java:157)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:267)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:181)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:137)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:105)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
      	at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
      	at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:221)
      	at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:199)
      	at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1778)
      	at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:301)
      	at org.olat.modules.qpool.manager.CollectionDAO.getItemsOfCollection(CollectionDAO.java:144)
      	at org.olat.modules.qpool.manager.QuestionPoolServiceImpl.getItemsOfCollection(QuestionPoolServiceImpl.java:649)
      	at org.olat.modules.qpool.ui.datasource.CollectionOfItemsSource.getItems(CollectionOfItemsSource.java:116)
      	at org.olat.modules.qpool.ui.AbstractItemListController.getRows(AbstractItemListController.java:346)
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.loadDatas(DefaultFlexiTableDataSourceModel.java:201)
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.DefaultFlexiTableDataSourceModel.load(DefaultFlexiTableDataSourceModel.java:170)
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableElementImpl.doScroll(FlexiTableElementImpl.java:534)
      	at org.olat.core.gui.components.form.flexible.impl.elements.table.FlexiTableModelMapper.handle(FlexiTableModelMapper.java:117)
      	at org.olat.core.dispatcher.mapper.MapperDispatcher.execute(MapperDispatcher.java:106)
      	at org.olat.core.dispatcher.DispatcherAction.execute(DispatcherAction.java:141)
      	at org.olat.core.servlets.OLATServlet.doPost(OLATServlet.java:155)
      	at org.olat.core.servlets.OLATServlet.doGet(OLATServlet.java:128)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
      	at org.olat.core.servlets.OLATServlet.service(OLATServlet.java:112)
      	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
      	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
      	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
      	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
      	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
      	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
      	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
      	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
      	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      	at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:197)
      	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
      	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1852)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      

        Attachments

          Activity

            People

            Assignee:
            srosse Stéphane Rossé
            Reporter:
            srosse Stéphane Rossé
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: