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

GradebookExternalAssessmentServiceImpl.getExternalAssignment called repeatedly

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Critical
    • Resolution: Incorporated
    • Affects Version/s: 2.9.1
    • Fix Version/s: 2.9.3
    • Component/s: edu-services
    • Labels:

      Description

      Database query analysis showed that queries like:

      select assignment0_.ID as ID59_, assignment0_.VERSION as VERSION59_, assignment0_.GRADEBOOK_ID as GRADEBOOK4_59_, assignment0_.NAME as NAME59_, assignment0_.REMOVED as REMOVED59_, assignment0_.SORT_ORDER as SORT7_59_, assignment0_.POINTS_POSSIBLE as POINTS8_59_, assignment0_.DUE_DATE as DUE9_59_, assignment0_.NOT_COUNTED as NOT10_59_, assignment0_.EXTERNALLY_MAINTAINED as EXTERNALLY11_59_, assignment0_.EXTERNAL_STUDENT_LINK as EXTERNAL12_59_, assignment0_.EXTERNAL_INSTRUCTOR_LINK as EXTERNAL13_59_, assignment0_.EXTERNAL_ID as EXTERNAL14_59_, assignment0_.EXTERNAL_APP_NAME as EXTERNAL15_59_, assignment0_.IS_EXTRA_CREDIT as IS16_59_, assignment0_.ASSIGNMENT_WEIGHTING as ASSIGNMENT17_59_, assignment0_.RELEASED as RELEASED59_, assignment0_.CATEGORY_ID as CATEGORY19_59_, assignment0_.UNGRADED as UNGRADED59_, assignment0_.IS_NULL_ZERO as IS21_59_, assignment0_.HIDE_IN_ALL_GRADES_TABLE as HIDE22_59_ from GB_GRADABLE_OBJECT_T assignment0_ where assignment0_.OBJECT_TYPE_ID=1 and assignment0_.GRADEBOOK_
      ID=5021 and assignment0_.EXTERNAL_ID='26449'

      where being called repeatedly in rendering the main page of a gradebook.

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  maintenanceteam Core Team
                  Reporter:
                  dhorwitz David Horwitz
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration