[Building Sakai] Forum/Discussion problem on 2.5.x
Wagner, Michelle R.
wagnermr at iupui.edu
Thu Jun 18 11:47:58 PDT 2009
Hi Tom,
It looks like you have some duplicate data. Could you run this query to verify that this is where the duplicate is? Add in your site id for the CONTEXT_ID param:
select count(*) from MFR_AREA_T where TYPE_UUID = (select UUID from CMN_TYPE_T where KEYWORD = 'discussionForums') and CONTEXT_ID = 'Insert site id here'
>From there, we can work off-list to see what the best strategy is for you.
Thanks!
Have a great day,
Michelle
On 6/18/09 12:13 PM, "Tom Hall" <thall at brocku.ca> wrote:
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)
_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20090618/4754a1db/attachment.html
More information about the sakai-dev
mailing list