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

GradebookService.getAssignmentScoreComment may result in IncorrectResultSizeDataAccessException

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.6.0, 2.6.1, 2.6.2, 2.6.3, 2.7.0, 2.7.1
    • Fix Version/s: None
    • Labels:
      None

      Description

      This seems like an unlikely scenario, but it popped up here at Indiana.

      Create a gradebook item.
      Add comments for student A
      Delete the gradebook item.
      Add a new gradebook item with the exact same name
      Add comments for student A again

      A call to GradebookService.getAssignmentScoreComment to retrieve the comment will result in an IncorrectResultSizeDataAccessException because the query (which uses the gb item name as the identifier) does not filter out deleted gb items.

      The method is currently used by Forums and Assignment2. To see the issue in Forums, create a graded topic associated with the gb item above. Try to grade a post from Student A. Clicking the "Grade" link does nothing and there is a stack trace in the logs.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                wagnermr Michelle Wagner
                Reporter:
                wagnermr Michelle Wagner
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code