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

GB Classic 12.x: No positional parameters in query

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 12.0
    • Fix Version/s: 12.0, 19.0
    • Component/s: Gradebook Classic
    • Labels:
      None
    • 12 status:
      Resolved
    • Test Plan:
      Hide
      • Gradebook classic is stealthed in 12/13 so to do this you'll have to manually add it to a site.
      • The easiest way is to add it to the already existing mercury
      • Login as admin, go to Sites tool
      • Search for mercury site
      • Click edit, Add/Edit pages, New Page, Fill in title (Gradebook), Click Tool, Click New Tool, Click the button next to "Gradebook Classic (sakai.gradebook.tool)"
      • Save

      Go to the mercury site /portal/site/mercury

      Click on the gradebook classic. The tool should work as expected.

      Show
      Gradebook classic is stealthed in 12/13 so to do this you'll have to manually add it to a site. The easiest way is to add it to the already existing mercury Login as admin, go to Sites tool Search for mercury site Click edit, Add/Edit pages, New Page, Fill in title (Gradebook), Click Tool, Click New Tool, Click the button next to "Gradebook Classic (sakai.gradebook.tool)" Save Go to the mercury site /portal/site/mercury Click on the gradebook classic. The tool should work as expected.

      Description

      With an older site Gradebook, this causes a bug report on the home page:

      Caused by: java.lang.IllegalArgumentException: No positional parameters in query: from GradebookAssignment as asn where asn.gradebook.id = :id and asn.removed=false and asn.category is null
              at org.hibernate.internal.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:442)
              at org.hibernate.internal.AbstractQueryImpl.setLong(AbstractQueryImpl.java:599)
              at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.lambda$getAssignmentsWithNoCategory$6(GradebookManagerHibernateImpl.java:2160)
              at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
              at org.springframework.orm.hibernate4.HibernateTemplate.execute(HibernateTemplate.java:296)
              at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsWithNoCategory(GradebookManagerHibernateImpl.java:2164)
              at org.sakaiproject.tool.gradebook.business.impl.GradebookManagerHibernateImpl.getAssignmentsWithNoCategoryWithStats(GradebookManagerHibernateImpl.java:2177)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
              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:282)
              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.$Proxy258.getAssignmentsWithNoCategoryWithStats(Unknown Source)
              at org.sakaiproject.tool.gradebook.ui.OverviewBean.init(OverviewBean.java:182)
              at org.sakaiproject.tool.gradebook.ui.InitializableBean.startRenderResponse(InitializableBean.java:62)
              at org.sakaiproject.jsf.component.FlowState.encodeBegin(FlowState.java:119)
              at javax.faces.webapp.UIComponentTag.encodeBegin(UIComponentTag.java:467)
              at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:320)
              at org.apache.jsp.overview_jsp._jspx_meth_sakai_005fflowState_005f0(overview_jsp.java:1702)
              at org.apache.jsp.overview_jsp._jspService(overview_jsp.java:400)
              at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
              at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:443)
              ... 84 more
      
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                ern Earle R Nietzel
                Reporter:
                smarquard Stephen Marquard
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code