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

FORUMS: Error unique result while Automatically create multiple topics for groups

    XMLWordPrintable

    Details

    • 21 Status:
      Resolved
    • 20 status:
      Please Merge
    • Test Plan:
      Hide

      1. Go to Section Info from Site Info
      2. Click Options -> Manually manage sections and membership (discontinues section and membership updates from the registration system)
      3. Click Update and confirm
      4. Click Add Sections
      5. Add 3 sections of 1 category (Studio for example)
      6. Click Add Sections
      7. Click to Forums
      8. Click New Forum
      9. Fill Forum Title
      10. Change permission Level to Contributor to the 3 sections
      11. Click Save
      12. Click New Topic
      13. Fill Topic Title
      14. Check Automatically create multiple topics for groups
      15. Check 2 sections of the 3 sections (Ex: Studio1 and Studio3)
      16. Click Save

      Show
      1. Go to Section Info from Site Info 2. Click Options -> Manually manage sections and membership (discontinues section and membership updates from the registration system) 3. Click Update and confirm 4. Click Add Sections 5. Add 3 sections of 1 category (Studio for example) 6. Click Add Sections 7. Click to Forums 8. Click New Forum 9. Fill Forum Title 10. Change permission Level to Contributor to the 3 sections 11. Click Save 12. Click New Topic 13. Fill Topic Title 14. Check Automatically create multiple topics for groups 15. Check 2 sections of the 3 sections (Ex: Studio1 and Studio3) 16. Click Save

      Description

      See attached image and testing plan

      org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: /jsp/discussionForum/includes/dfAreaInclude.jsp(227,24) '#{! topic.nonePermission}' Error reading [nonePermission] on type [org.sakaiproject.tool.messageforums.ui.DiscussionTopicBean]
          at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:857)
      caused by: org.sakaiproject.tool.api.ToolException: javax.servlet.ServletException: /jsp/discussionForum/includes/dfAreaInclude.jsp(227,24) '#{! topic.nonePermission}' Error reading [nonePermission] on type [org.sakaiproject.tool.messageforums.ui.DiscussionTopicBean]
          at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1500)
      caused by: javax.servlet.ServletException: /jsp/discussionForum/includes/dfAreaInclude.jsp(227,24) '#{! topic.nonePermission}' Error reading [nonePermission] on type [org.sakaiproject.tool.messageforums.ui.DiscussionTopicBean]
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
      caused by: org.apache.jasper.el.JspELException: /jsp/discussionForum/includes/dfAreaInclude.jsp(227,24) '#{! topic.nonePermission}' Error reading [nonePermission] on type [org.sakaiproject.tool.messageforums.ui.DiscussionTopicBean]
          at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:200)
      caused by: org.springframework.dao.IncorrectResultSizeDataAccessException: query did not return a unique result: 2; nested exception is org.hibernate.NonUniqueResultException: query did not return a unique result: 2
          at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
      caused by: org.hibernate.NonUniqueResultException: query did not return a unique result: 2
          at org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:975)
          at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:966)
          at org.sakaiproject.component.app.messageforums.MessageForumsForumManagerImpl.lambda$getAllowedGroupForRestrictedTopic$32(MessageForumsForumManagerImpl.java:1530)
          at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
          at org.springframework.orm.hibernate4.HibernateTemplate.execute(HibernateTemplate.java:296)
          at org.sakaiproject.component.app.messageforums.MessageForumsForumManagerImpl.getAllowedGroupForRestrictedTopic(MessageForumsForumManagerImpl.java:1531)
          at sun.reflect.GeneratedMethodAccessor2261.invoke(null:-1)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:283)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
          at com.sun.proxy.$Proxy112.getAllowedGroupForRestrictedTopic(null:-1)
          at org.sakaiproject.component.app.messageforums.ui.DiscussionForumManagerImpl.getAllowedGroupForRestrictedTopic(DiscussionForumManagerImpl.java:2546)
          at sun.reflect.GeneratedMethodAccessor2260.invoke(null:-1)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
          at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
          at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:283)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
          at com.sun.proxy.$Proxy122.getAllowedGroupForRestrictedTopic(null:-1)
          at org.sakaiproject.component.app.messageforums.ui.UIPermissionsManagerImpl.isInstructorForAllowedGroup(UIPermissionsManagerImpl.java:269)
          at org.sakaiproject.component.app.messageforums.ui.UIPermissionsManagerImpl.isChangeSettings(UIPermissionsManagerImpl.java:460)
          at org.sakaiproject.component.app.messageforums.ui.UIPermissionsManagerImpl.isChangeSettings(UIPermissionsManagerImpl.java:445)
          at org.sakaiproject.tool.messageforums.ui.DiscussionTopicBean.getNonePermission(DiscussionTopicBean.java:1056)
          at sun.reflect.GeneratedMethodAccessor1075.invoke(null:-1)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:498)
          at javax.el.BeanELResolver.getValue(BeanELResolver.java:94)
          at com.sun.faces.el.DemuxCompositeELResolver._getValue(DemuxCompositeELResolver.java:180)
          at com.sun.faces.el.DemuxCompositeELResolver.getValue(DemuxCompositeELResolver.java:208)
          at org.apache.el.parser.AstValue.getValue(AstValue.java:169)
          at org.apache.el.parser.AstNot.getValue(AstNot.java:43)
          at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:190)
          at org.apache.jasper.el.JspValueExpression.getValue(JspValueExpression.java:115)
          at javax.faces.component.ComponentStateHelper.eval(ComponentStateHelper.java:200)
          at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:470)
          at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:302)
          at com.sun.faces.renderkit.html_basic.TableRenderer.renderRow(TableRenderer.java:398)
          at com.sun.faces.renderkit.html_basic.TableRenderer.encodeChildren(TableRenderer.java:161)
          at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:918)
          at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:309)
          at com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:114)
          at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:918)
          at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:309)
          at com.sun.faces.renderkit.html_basic.TableRenderer.renderRow(TableRenderer.java:398)
          at com.sun.faces.renderkit.html_basic.TableRenderer.encodeChildren(TableRenderer.java:161)
          at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:918)
          at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1905)
          at javax.faces.render.Renderer.encodeChildren(Renderer.java:176)
          at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:918)
          at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1905)
          at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1908)
          at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1908)
          at com.sun.faces.application.view.JspViewHandlingStrategy.doRenderView(JspViewHandlingStrategy.java:446)
          at com.sun.faces.application.view.JspViewHandlingStrategy.renderView(JspViewHandlingStrategy.java:201)
          at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:194)
          at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:151)
          at org.apache.myfaces.tomahawk.application.ResourceViewHandlerWrapper.renderView(ResourceViewHandlerWrapper.java:169)
          at org.sakaiproject.jsf2.app.SakaiViewHandlerWrapper.renderView(SakaiViewHandlerWrapper.java:161)
          at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:151)
          at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:126)
          at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
          at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:223)
          at javax.faces.webapp.FacesServlet.service(FacesServlet.java:671)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:426)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
          at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
          at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:384)
          at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
          at org.sakaiproject.tool.messageforums.MessageForumsFilePickerServlet.dispatch(MessageForumsFilePickerServlet.java:171)
          at org.sakaiproject.jsf2.util.JsfTool.doGet(JsfTool.java:235)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:426)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:712)
          at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:459)
          at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:352)
          at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
          at org.sakaiproject.tool.impl.ActiveToolComponent$MyActiveTool.forward(ActiveToolComponent.java:508)
          at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1500)
          at org.sakaiproject.portal.charon.handlers.ToolHandler.doTool(ToolHandler.java:200)
          at org.sakaiproject.portal.charon.handlers.ToolHandler.doGet(ToolHandler.java:96)
          at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:857)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:626)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.sakaiproject.util.RequestFilter.doFilter(RequestFilter.java:475)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
          at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
          at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:747)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
          at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
          at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
          at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
          at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1589)
          at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
          at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
          at java.lang.Thread.run(Thread.java:748) 

        Gliffy Diagrams

          Zeplin

            Attachments

            1. SAK-44292.mp4
              1.08 MB
            2. SAK-44292.png
              SAK-44292.png
              148 kB

              Issue Links

                Activity

                  People

                  Assignee:
                  fernando.alvarez1 Fernando Alvarez
                  Reporter:
                  jesusmmp Jesus Maria Mendez
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration