XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0, 11.0
    • Labels:
      None

      Description

      In the current trunk Samigo, there is a stack trace because some code was removed from the "group by" in a hibernate query. Not sure if this was for performance or for what reason. It's possible that other removed or altered code might also cause problems.

      https://source.sakaiproject.org/viewsvn/sam/trunk/samigo-services/src/java/org/sakaiproject/tool/assessment/facade/AssessmentFacadeQueries.java?r1=121508&r2=305964

      Stacktrace:
      at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470)
      caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select assessment2_.ID as col_0_0_, count(*) as col_1_0_ from SAM_ITEM_T itemdata0_, SAM_SECTION_T sectiondat1_, SAM_ASSESSMENTBASE_T assessment2_, SAM_AUTHZDATA_T authorizat3_ where assessment2_.isTemplate='0' and assessment2_.ID=sectiondat1_.ASSESSMENTID and sectiondat1_.SECTIONID=itemdata0_.SECTIONID and assessment2_.ID=authorizat3_.QUALIFIERID and authorizat3_.FUNCTIONID=? and authorizat3_.AGENTID=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
      at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
      caused by: org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
      caused by: java.sql.SQLException: ORA-00937: not a single-group group function

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                samigoteam SAMIGO TEAM (Inactive)
                Reporter:
                jonespm Matthew Jones
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration