[Building Sakai] Forum/Discussion problem on 2.5.x

Tom Hall thall at brocku.ca
Thu Jun 18 09:13:21 PDT 2009


Good day

We are having a problem with the forum/discussion tool in (as far as I 
know) one course site.  When ever an instructor attempts to make any 
changes to or add topics the following message is received.  While this 
is similar to SAK-8486, we are currently using 2.5.x (version 59993) 
which is much more recent than the versions mension in the SAK-8486.  
Does anyone have any suggestions.

Thanks

Tom




org.sakaiproject.portal.api.PortalHandlerException: 
org.sakaiproject.tool.api.ToolException: 
javax.faces.el.EvaluationException: Error getting property 'siteRoles' 
from bean of type 
org.sakaiproject.tool.messageforums.DiscussionForumTool: 
org.springframework.dao.IncorrectResultSizeDataAccessException: query 
did not return a unique result: 2
   at 
org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:891) 

caused by: org.sakaiproject.tool.api.ToolException: 
javax.faces.el.EvaluationException: Error getting property 'siteRoles' 
from bean of type 
org.sakaiproject.tool.messageforums.DiscussionForumTool: 
org.springframework.dao.IncorrectResultSizeDataAccessException: query 
did not return a unique result: 2
   at 
org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1346) 

caused by: org.apache.jasper.JasperException: 
javax.faces.el.EvaluationException: Error getting property 'siteRoles' 
from bean of type 
org.sakaiproject.tool.messageforums.DiscussionForumTool: 
org.springframework.dao.IncorrectResultSizeDataAccessException: query 
did not return a unique result: 2
   at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373) 

caused by: javax.faces.el.EvaluationException: 
javax.faces.el.EvaluationException: Error getting property 'siteRoles' 
from bean of type 
org.sakaiproject.tool.messageforums.DiscussionForumTool: 
org.springframework.dao.IncorrectResultSizeDataAccessException: query 
did not return a unique result: 2
   at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:154)
caused by: javax.faces.el.EvaluationException: Error getting property 
'siteRoles' from bean of type 
org.sakaiproject.tool.messageforums.DiscussionForumTool: 
org.springframework.dao.IncorrectResultSizeDataAccessException: query 
did not return a unique result: 2
   at com.sun.faces.el.impl.ArraySuffix.evaluate(ArraySuffix.java:167)
caused by: 
org.springframework.dao.IncorrectResultSizeDataAccessException: query 
did not return a unique result: 2
   at 
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:649) 

   at 
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412) 

   at 
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377) 

   at 
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338) 

   at 
org.sakaiproject.component.app.messageforums.AreaManagerImpl.getAreaByContextIdAndTypeId(AreaManagerImpl.java:261) 

   at 
org.sakaiproject.component.app.messageforums.AreaManagerImpl.getDiscusionArea(AreaManagerImpl.java:126) 

   at sun.reflect.GeneratedMethodAccessor1140.invoke(null:-1)
   at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

   at java.lang.reflect.Method.invoke(Method.java:585)
   at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296) 

   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177) 

   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) 

   at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) 

   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) 

   at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 

   at $Proxy33.getDiscusionArea(null:-1)
   at 
org.sakaiproject.component.app.messageforums.ui.DiscussionForumManagerImpl.getDiscussionForumArea(DiscussionForumManagerImpl.java:336) 

   at sun.reflect.GeneratedMethodAccessor1139.invoke(null:-1)
   at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

   at java.lang.reflect.Method.invoke(Method.java:585)
   at 
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:296) 

   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:177) 

   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144) 

   at 
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) 

   at 
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) 

   at 
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) 

   at $Proxy39.getDiscussionForumArea(null:-1)
   at 
org.sakaiproject.component.app.messageforums.ui.UIPermissionsManagerImpl.initMembershipForSite(UIPermissionsManagerImpl.java:1435) 

   at 
org.sakaiproject.component.app.messageforums.ui.UIPermissionsManagerImpl.getForumItemsSet(UIPermissionsManagerImpl.java:1130) 

   at 
org.sakaiproject.tool.messageforums.DiscussionForumTool.getSiteMembers(DiscussionForumTool.java:5338) 

   at 
org.sakaiproject.tool.messageforums.DiscussionForumTool.getSiteRoles(DiscussionForumTool.java:5313) 

   at sun.reflect.GeneratedMethodAccessor6377.invoke(null:-1)
   at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 

   at java.lang.reflect.Method.invoke(Method.java:585)
   at 
com.sun.faces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:79) 

   at com.sun.faces.el.impl.ArraySuffix.evaluate(ArraySuffix.java:167)
   at com.sun.faces.el.impl.ComplexValue.evaluate(ComplexValue.java:151)
   at 
com.sun.faces.el.impl.ExpressionEvaluatorImpl.evaluate(ExpressionEvaluatorImpl.java:243) 

   at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:173)
   at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:154)
   at javax.faces.component.UISelectItems.getValue(UISelectItems.java:110)
   at com.sun.faces.util.Util.getSelectItems(Util.java:600)
   at 
com.sun.faces.renderkit.html_basic.MenuRenderer.getOptionNumber(MenuRenderer.java:488) 

   at 
com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:465) 

   at 
com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:430) 

   at 
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:720)
   at 
com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:443) 

   at 
com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:130) 

   at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:701) 

   at 
com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:435) 

   at 
com.sun.faces.renderkit.html_basic.GridRenderer.encodeChildren(GridRenderer.java:233) 

   at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:701) 

   at 
org.sakaiproject.tool.messageforums.jsf.HideDivisionRenderer.encodeChildren(HideDivisionRenderer.java:83) 

   at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:701) 

   at 
javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:607)
   at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:544)
   at 
org.apache.jsp.jsp.dfReviseForumSettingsAttach_jsp._jspService(dfReviseForumSettingsAttach_jsp.java:414) 

   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at 
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331) 

   at 
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
   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:679) 

   at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461) 

   at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399) 

   at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) 

   at 
com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322) 

   at 
com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130) 

   at 
org.sakaiproject.jsf.app.SakaiViewHandler.renderView(SakaiViewHandler.java:137) 

   at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) 

   at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
   at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117)
   at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198)
   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: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:679) 

   at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461) 

   at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:399) 

   at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) 

   at 
org.sakaiproject.tool.messageforums.MessageForumsFilePickerServlet.dispatch(MessageForumsFilePickerServlet.java:151) 

   at org.sakaiproject.jsf.util.JsfTool.doGet(JsfTool.java:241)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
   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: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:679) 

   at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:461) 

   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:459) 

   at 
org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1346) 

   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.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:891) 

   at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
   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:594)
   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:213) 

   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:174)
   at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
   at 
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) 

   at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) 

   at 
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) 

   at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) 

   at java.lang.Thread.run(Thread.java:595)


More information about the sakai-dev mailing list