Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-28566

unexpected end of subtree

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.5.0
    • Fix Version/s: 2.5.6
    • Component/s: Sitestats
    • Labels:
      None
    • Previous Issue Keys:
      STAT-43

      Description

      Not sure how to reproduce this - looks like a Report.

      usage-session: 770cef2f-6770-43b8-001f-b570352d7602
      stack-trace-digest: 03089D7E14E8FB92415AA28D37D6A9D3712DEE61
      sakai-version: 2.4
      service-version: [r36062-r4114]
      app-server: vula5a
      user-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; (R1 1.5); .NET CLR 1.1.4322; InfoPath.1)
      browser-id: Win-InternetExplorer
      IP: 137.158.129.193
      time: 16-Oct-2007 09:03:08

      user comment:

      stack trace:

      org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: Error calling action method of component with id reportsForm:_idJsp84
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:63)
      caused by: org.sakaiproject.tool.api.ToolException: Error calling action method of component with id reportsForm:_idJsp84
      at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1099)
      caused by: javax.servlet.ServletException: Error calling action method of component with id reportsForm:_idJsp84
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      caused by: javax.faces.FacesException: Error calling action method of component with id reportsForm:_idJsp84
      at javax.faces.component.UICommand.broadcast(UICommand.java:109)
      caused by: javax.faces.el.EvaluationException: Exception while invoking expression #

      {ReportsBean.processGenerateReport}

      at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
      caused by: org.springframework.orm.hibernate3.HibernateQueryException: unexpected end of subtree [select s.siteId, s.userId, s.resourceRef, s.resourceAction, sum(s.count), max(s.date) from org.sakaiproject.sitestats.impl.ResourceStatImpl as s where s.siteId = :siteid and s.userId != '?' and s.resourceRef in () and s.date >= :idate and s.date < :fdate group by s.siteId, s.userId, s.resourceRef, s.resourceAction]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select s.siteId, s.userId, s.resourceRef, s.resourceAction, sum(s.count), max(s.date) from org.sakaiproject.sitestats.impl.ResourceStatImpl as s where s.siteId = :siteid and s.userId != '?' and s.resourceRef in () and s.date >= :idate and s.date < :fdate group by s.siteId, s.userId, s.resourceRef, s.resourceAction]
      at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:413)
      caused by: org.hibernate.hql.ast.QuerySyntaxException: unexpected end of subtree [select s.siteId, s.userId, s.resourceRef, s.resourceAction, sum(s.count), max(s.date) from org.sakaiproject.sitestats.impl.ResourceStatImpl as s where s.siteId = :siteid and s.userId != '?' and s.resourceRef in () and s.date >= :idate and s.date < :fdate group by s.siteId, s.userId, s.resourceRef, s.resourceAction]
      at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:225)
      caused by: <AST>:0:0: unexpected end of subtree
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2943)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.collectionFunctionOrSubselect(HqlSqlBaseWalker.java:4243)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.inRhs(HqlSqlBaseWalker.java:4152)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:3835)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1758)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1686)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1683)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:1683)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:776)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:577)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
      at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
      at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:218)
      at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:158)
      at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:109)
      at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
      at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
      at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
      at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1098)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl$6.doInHibernate(StatsManagerImpl.java:1663)
      at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
      at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:334)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getResourceStatsGrpByDateAndAction(StatsManagerImpl.java:1703)
      at org.sakaiproject.sitestats.impl.StatsManagerImpl.getReport(StatsManagerImpl.java:1205)
      at org.sakaiproject.sitestats.tool.bean.ReportsBean.processGenerateReport(ReportsBean.java:696)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132)
      at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
      at javax.faces.component.UICommand.broadcast(UICommand.java:109)
      at org.ajax4jsf.framework.ajax.AjaxViewRoot.processEvents(AjaxViewRoot.java:180)
      at org.ajax4jsf.framework.ajax.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:158)
      at org.ajax4jsf.framework.ajax.AjaxViewRoot.processApplication(AjaxViewRoot.java:346)
      at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
      at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
      at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
      at javax.faces.webapp.FacesServlet.service(FacesServlet.java:139)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:127)
      at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:277)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:555)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
      at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
      at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
      at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      at org.sakaiproject.jsf.util.JsfTool.dispatch(JsfTool.java:221)
      at org.sakaiproject.jsf.util.JsfTool.doPost(JsfTool.java:256)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
      at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
      at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
      at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:441)
      at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1099)
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:163)
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:86)
      at org.sakaiproject.portal.charon.handlers.ToolHandler.doPost(ToolHandler.java:63)
      at org.sakaiproject.portal.charon.SkinnableCharonPortal.doPost(SkinnableCharonPortal.java:942)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:592)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
      at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
      at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
      at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
      at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
      at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
      at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
      at java.lang.Thread.run(Thread.java:595)

      Tool Placement:
      No Placement

      Request:
      : AuthType:null
      : CharEncoding:UTF-8
      : ContentLength:615
      : ContentType:application/x-www-form-urlencoded
      : ContextPath:/portal
      : LocalAddress:null
      : LocalName:vula.uct.ac.za
      : LocalPort:443
      : Method:POST
      : PathInfo:/tool/7ba28b53-1596-4bf8-8002-aebb32dd9e2d/reports
      : Protocol:HTTP/1.1
      : QueryString:null
      : RemoteAddress:137.158.129.193
      : RemoteHost:137.158.129.193
      : RemotePort:-1
      : Requested URL:https://vula.uct.ac.za/portal/tool/7ba28b53-1596-4bf8-8002-aebb32dd9e2d/reports
      : Scheme:https
      : ServerName:vula.uct.ac.za
      : Headers:
      : Header:accept:image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, /
      : Header:referer:https://vula.uct.ac.za/portal/tool/7ba28b53-1596-4bf8-8002-aebb32dd9e2d/reports
      : Header:accept-language:en-za
      : Header:content-type:application/x-www-form-urlencoded
      : Header:accept-encoding:gzip, deflate
      : Header:user-agent:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; (R1 1.5); .NET CLR 1.1.4322; InfoPath.1)
      : Header:host:vula.uct.ac.za
      : Header:content-length:615
      : Header:connection:Keep-Alive
      : Header:Cache-Control:no-cache
      : Header:cookie:--censored--
      : Header:X-NovINet:v1.2
      : Parameters:
      : Parameter:reportsForm:what:0:what-resources
      : Parameter:reportsForm:what-events-by:0:what-events-bytool
      : Parameter:reportsForm:link_hidden:0:
      : Parameter:reportsForm:who:0:who-all
      : Parameter:reportsForm:when-custom-to_time:0:09:01:16 AM
      : Parameter:javax.faces.ViewState:0:rO0ABXVyABNbTGphdmEubGFuZy5PYmplY3Q7kM5YnxBzKWwCAAB4cAAAAAN0AAIyMnB0ABYvc2l0ZXN0YXRzL3JlcG9ydHMuanNw
      : Parameter:reportsForm:when-custom-from_date:0:10/09/2007
      : Parameter:reportsForm:when:0:when-last7days
      : Parameter:reportsForm:who-role-select:0:Lecturer
      : Parameter:reportsForm_SUBMIT:0:1
      : Parameter:reportsForm:_idJsp84:0:Generate report
      : Parameter:reportsForm:_idcl:0:
      : Parameter:reportsForm:when-custom-to_date:0:10/16/2007
      : Parameter:reportsForm:when-custom-from_time:0:09:01:16 AM
      : Attributes:
      : Attribute:tool.url.manager:org.sakaiproject.portal.util.ToolURLManagerImpl@6352ae6b
      : Attribute:sakai.session:org.sakaiproject.tool.impl.SessionComponent$MySession@b8a6f74b
      : Attribute:sakai.html.head.css.base:<link href="/library/skin/tool_base.css" type="text/css" rel="stylesheet" media="all" />

      : Attribute:sakai.character.encoding.done:sakai.character.encoding.done
      : Attribute:sakai.html.head.js:<script type="text/javascript" language="JavaScript" src="/library/js/headscripts.js"></script>

      : Attribute:sakai.html.head:<link href="/library/skin/tool_base.css" type="text/css" rel="stylesheet" media="all" />
      <link href="/library/skin/default/tool.css" type="text/css" rel="stylesheet" media="all" />
      <script type="text/javascript" language="JavaScript" src="/library/js/headscripts.js"></script>

      : Attribute:sakai.request.native.url:sakai.request.native.url
      : Attribute:sakai.html.body.onload:setMainFrameHeight('Main7ba28b53x1596x4bf8x8002xaebb32dd9e2d');setFocus(focus_path);
      : Attribute:sakai.filtered:sakai.filtered
      : Attribute:sakai.html.head.css.skin:<link href="/library/skin/default/tool.css" type="text/css" rel="stylesheet" media="all" />

      : Attribute:sakai.html.head.css:<link href="/library/skin/tool_base.css" type="text/css" rel="stylesheet" media="all" />
      <link href="/library/skin/default/tool.css" type="text/css" rel="stylesheet" media="all" />

      Session:
      : Created:1192516915800
      : LastAccess:1192518188537
      : MaxInactive:3600
      : Attributes:
      : Attribute:portalskin:defaultskin

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                nfernandes Nuno Fernandes (Inactive)
                Reporter:
                smarquard Stephen Marquard
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration