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

Kenwrick Chan kchan at hawaii.edu
Mon Oct 26 11:27:36 PDT 2009 

well it looks like we had that issue on start up.

-kenwrick

26 Oct 2009 03:23:00,058 INFO  
[org.sakaiproject.component.app.messageforums.MessageForumsTypeManagerImpl 
] [] - init()
26 Oct 2009 03:23:00,130 INFO  
[org.sakaiproject.component.app.messageforums.MessageForumsForumManagerImpl 
] [] - init()
26 Oct 2009 03:23:00,240 INFO  
[org.sakaiproject.component.app.messageforums.AreaManagerImpl] [] -  
init()
26 Oct 2009 03:23:00,334 INFO  
[org.sakaiproject.component.app.messageforums.MessageForumsMessageManagerImpl 
] [] - init()
26 Oct 2009 03:23:00,592 INFO  
[org.sakaiproject.component.app.messageforums.DefaultPermissionsManagerImpl 
] [] - init()
26 Oct 2009 03:23:00,594 INFO  
[org.sakaiproject.component.app.messageforums.PermissionManagerImpl]  
[] - init()
26 Oct 2009 03:23:00,753 INFO  
[org.sakaiproject.component.app.messageforums.MembershipManagerImpl]  
[] - init()
26 Oct 2009 03:23:00,832 INFO  
[org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl 
] [] - init()
26 Oct 2009 03:23:01,158 WARN  
[org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl 
] [] - Error loading initial default permissions
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  
org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl.loadInitialDefaultPermissionLevel 
(PermissionLevelManagerImpl.java:783)
	at  
org.sakaiproject.component.app.messageforums.PermissionLevelManagerImpl.init 
(PermissionLevelManagerImpl.java:80)
	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.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod 
(AbstractAutowireCapableBeanFactory.java:1240)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods 
(AbstractAutowireCapableBeanFactory.java:1205)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean 
(AbstractAutowireCapableBeanFactory.java:1171)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean 
(AbstractAutowireCapableBeanFactory.java:425)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean 
(BeanDefinitionValueResolver.java:215)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary 
(BeanDefinitionValueResolver.java:122)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues 
(AbstractAutowireCapableBeanFactory.java:1099)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean 
(AbstractAutowireCapableBeanFactory.java:861)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean 
(AbstractAutowireCapableBeanFactory.java:421)
	at org.springframework.beans.factory.support.AbstractBeanFactory 
$1.getObject(AbstractBeanFactory.java:251)
	at  
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton 
(DefaultSingletonBeanRegistry.java:156)
	at  
org.springframework.beans.factory.support.AbstractBeanFactory.getBean 
(AbstractBeanFactory.java:248)
	at  
org.springframework.beans.factory.support.AbstractBeanFactory.getBean 
(AbstractBeanFactory.java:160)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference 
(BeanDefinitionValueResolver.java:261)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary 
(BeanDefinitionValueResolver.java:109)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues 
(AbstractAutowireCapableBeanFactory.java:1099)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean 
(AbstractAutowireCapableBeanFactory.java:861)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean 
(AbstractAutowireCapableBeanFactory.java:421)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean 
(BeanDefinitionValueResolver.java:215)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary 
(BeanDefinitionValueResolver.java:122)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues 
(AbstractAutowireCapableBeanFactory.java:1099)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean 
(AbstractAutowireCapableBeanFactory.java:861)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean 
(AbstractAutowireCapableBeanFactory.java:421)
	at org.springframework.beans.factory.support.AbstractBeanFactory 
$1.getObject(AbstractBeanFactory.java:251)
	at  
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton 
(DefaultSingletonBeanRegistry.java:156)
	at  
org.springframework.beans.factory.support.AbstractBeanFactory.getBean 
(AbstractBeanFactory.java:248)
	at  
org.springframework.beans.factory.support.AbstractBeanFactory.getBean 
(AbstractBeanFactory.java:160)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference 
(BeanDefinitionValueResolver.java:261)
	at  
org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary 
(BeanDefinitionValueResolver.java:109)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues 
(AbstractAutowireCapableBeanFactory.java:1099)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean 
(AbstractAutowireCapableBeanFactory.java:861)
	at  
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean 
(AbstractAutowireCapableBeanFactory.java:421)
	at org.springframework.beans.factory.support.AbstractBeanFactory 
$1.getObject(AbstractBeanFactory.java:251)
	at  
org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton 
(DefaultSingletonBeanRegistry.java:156)
	at  
org.springframework.beans.factory.support.AbstractBeanFactory.getBean 
(AbstractBeanFactory.java:248)
	at  
org.springframework.beans.factory.support.AbstractBeanFactory.getBean 
(AbstractBeanFactory.java:160)
	at  
org.sakaiproject.util.NoisierDefaultListableBeanFactory.preInstantiateSingletons 
(NoisierDefaultListableBeanFactory.java:63)
	at  
org.springframework.context.support.AbstractApplicationContext.refresh 
(AbstractApplicationContext.java:352)
	at org.sakaiproject.component.impl.SpringCompMgr.init 
(SpringCompMgr.java:254)
	at org.sakaiproject.component.cover.ComponentManager.getInstance 
(ComponentManager.java:62)
	at org.sakaiproject.component.cover.ComponentManager.get 
(ComponentManager.java:71)
	at  
org.sakaiproject.component.cover.ServerConfigurationService.getInstance 
(ServerConfigurationService.java:53)
	at  
org.sakaiproject.component.cover.ServerConfigurationService.getStrings 
(ServerConfigurationService.java:206)
	at org.sakaiproject.dav.DavServlet.init(DavServlet.java:529)
	at javax.servlet.GenericServlet.init(GenericServlet.java:212)
	at org.apache.catalina.core.StandardWrapper.loadServlet 
(StandardWrapper.java:1139)
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java: 
966)
	at org.apache.catalina.core.StandardContext.loadOnStartup 
(StandardContext.java:3956)
	at org.apache.catalina.core.StandardContext.start 
(StandardContext.java:4230)
	at org.apache.catalina.core.ContainerBase.addChildInternal 
(ContainerBase.java:760)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java: 
740)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java: 
544)
	at org.apache.catalina.startup.HostConfig.deployDescriptor 
(HostConfig.java:626)
	at org.apache.catalina.startup.HostConfig.deployDescriptors 
(HostConfig.java:553)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java: 
488)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent 
(HostConfig.java:311)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent 
(LifecycleSupport.java:120)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java: 
1022)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java: 
1014)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java: 
443)
	at org.apache.catalina.core.StandardService.start 
(StandardService.java:448)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java: 
700)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
	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.catalina.startup.Bootstrap.start(Bootstrap.java:295)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
26 Oct 2009 03:23:01,210 INFO  
[org.sakaiproject.component.app.messageforums.ui.DiscussionForumManagerImpl 
] [] - init()
26 Oct 2009 03:23:01,287 INFO  
[org.sakaiproject.api.app.messageforums.DiscussionForumService] [] -  
init()
26 Oct 2009 03:23:01,326 INFO  
[org.sakaiproject.component.app.messageforums.ui.UIPermissionsManagerImpl 
] [] - init()
26 Oct 2009 03:23:01,371 INFO  
[org.sakaiproject.component.app.messageforums.UserPermissionManagerImpl 
] [] - init()
26 Oct 2009 03:23:01,479 INFO  
[org.sakaiproject.component.app.messageforums.ui.PrivateMessageManagerImpl 
] [] - init()
26 Oct 2009 03:23:01,578 INFO  
[org.sakaiproject.component.app.messageforums.MessageForumsUserManagerImpl 
] [] - init()

On Oct 26, 2009, at 8:23 AM, 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