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

          Zeplin

            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 Integration