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

Hibernate bugs in Samigo

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 12.0
    • Fix Version/s: 12.0
    • Labels:
      None
    • Previous Issue Keys:
      SAM-3149
    • Test Plan:
      Hide

      Was getting this stack trace as soon as publishing an assessment.

      Show
      Was getting this stack trace as soon as publishing an assessment.

      Description

      I'm not sure what workflow is causing these but saw these 2 on nightly related to KNL-945

      WARNING: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1; nested exception is org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1
      org.springframework.orm.hibernate4.HibernateQueryException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1; nested exception is org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1
      	at org.springframework.orm.hibernate4.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:175)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
      	at org.springframework.orm.hibernate4.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:309)
      	at org.springframework.orm.hibernate4.HibernateTemplate.find(HibernateTemplate.java:865)
      	at org.sakaiproject.tool.assessment.facade.authz.integrated.AuthzQueriesFacade.removeAuthorizationByAgentQualifierAndFunction(AuthzQueriesFacade.java:252)
      
      15-Feb-2017 15:07:50.946 ERROR [http-apr-18888-exec-5] org.sakaiproject.tool.assessment.services.GradingService.getActualNumberRetake No positional parameters in query: select count(*) from AssessmentGradingData a, StudentGradingSummaryData s  where a.publishedAssessmentId = :id and a.agentId = :agent and a.forGrade = :forgrade  and a.publishedAssessmentId = s.publishedAssessmentId and a.agentId = s.agentId  and a.submittedDate > s.createdDate
      java.lang.IllegalArgumentException: No positional parameters in query: select count(*) from AssessmentGradingData a, StudentGradingSummaryData s  where a.publishedAssessmentId = :id and a.agentId = :agent and a.forGrade = :forgrade  and a.publishedAssessmentId = s.publishedAssessmentId and a.agentId = s.agentId  and a.submittedDate > s.createdDate
      	at org.hibernate.internal.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:442)
      	at org.hibernate.internal.AbstractQueryImpl.setLong(AbstractQueryImpl.java:599)
      	at org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.lambda$getActualNumberRetake$63(AssessmentGradingFacadeQueries.java:1745)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
      	at org.springframework.orm.hibernate4.HibernateTemplate.execute(HibernateTemplate.java:296)
      	at org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries.getActualNumberRetake(AssessmentGradingFacadeQueries.java:1750)
      
      16-Feb-2017 09:20:33.843 ERROR [http-apr-18888-exec-6] org.sakaiproject.tool.assessment.services.QuestionPoolService.getCountItems getCountItems
      java.lang.ClassCastException: java.lang.Long cannot be cast to java.lang.Integer
      	at org.sakaiproject.tool.assessment.facade.QuestionPoolFacadeQueries.lambda$getCountItemFacades$16(QuestionPoolFacadeQueries.java:1316)
      	at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:341)
      	at org.springframework.orm.hibernate4.HibernateTemplate.execute(HibernateTemplate.java:296)
      	at org.sakaiproject.tool.assessment.facade.QuestionPoolFacadeQueries.getCountItemFacades(QuestionPoolFacadeQueries.java:1319)
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ern Earle R Nietzel
                  Reporter:
                  jonespm Matthew Jones
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code