[Building Sakai] forums: org.sakaiproject.tool.api.ToolException: query did not return a unique result: 3

Tom Hall thall at brocku.ca
Mon Oct 26 11:29:55 PDT 2009 

Hi Kenwrick

This sounds like a problem we has several months ago.  You may have
duplicate records in some of your MFR_* tables.  I'll find my notes on
this and send them to you.

Tom



On Mon, 26 Oct 2009, Kenwrick Chan wrote:

> Folks,
> When users like on forums settings they get the following?  Any
> suggestions?
>
> Thanks,
> Kenwrick
>
> org.sakaiproject.portal.api.PortalHandlerException:
> org.sakaiproject.tool.api.ToolException: query did not return a unique
> result: 3
>      at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet
> (SkinnableCharonPortal.java:891)
> caused by: org.sakaiproject.tool.api.ToolException: query did not
> return a unique result: 3
>      at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool
> (SkinnableCharonPortal.java:1343)
> caused by: org.apache.jasper.JasperException: query did not return a
> unique result: 3
>      at org.apache.jasper.servlet.JspServletWrapper.service
> (JspServletWrapper.java:389)
> caused by:
> org.springframework.dao.IncorrectResultSizeDataAccessException: query
> did not return a unique result: 3
>      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.PermissionLevelManagerImpl.getDefaultPermissionLevel
> (PermissionLevelManagerImpl.java:592)
>      at
> org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl.getDefaultContributorPermissionLevel
> (PermissionLevelManagerImpl.java:500)
>      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.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 $Proxy48.getDefaultContributorPermissionLevel(null:-1)
>      at
> org.sakaiproject.tool.messageforums.DiscussionForumTool.generatePermissionScript
> (DiscussionForumTool.java:5503)
>      at org.apache.jsp.jsp.dfReviseForumSettingsAttach_jsp._jspService
> (dfReviseForumSettingsAttach_jsp.java:343)
>      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:328)
>      at org.apache.jasper.servlet.JspServlet.serviceJspFile
> (JspServlet.java:315)
>      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: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 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: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.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: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:459)
>      at
> org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool
> (SkinnableCharonPortal.java:1343)
>      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: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)
>
>
> user: dc0ef21a-fd36-4a16-80fe-2ed45161e088
>
> usage-session: df90c309-dc55-49c2-a043-29737456e1b7
>
> time: Oct 26, 2009 08:13:15
>
> _______________________________________________
> 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"
>

More information about the sakai-dev mailing list