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

Error downloading the spreadsheet of the "Grade report"

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 12.3, 19.0 [Tentative]
    • Fix Version/s: 12.4, 19.0 [Tentative]
    • Component/s: Assignments
    • Labels:
      None
    • 12 status:
      Resolved
    • Test Plan:
      Hide
      1. As a instructor, create 2 or more assignments in a site with around 100 students.
      2. Click on "Grade Report"
      3. Click on "Download Spreadsheet [XLSX]" - The file is empty and a there is a NullPointerException in the log.
      Show
      As a instructor, create 2 or more assignments in a site with around 100 students. Click on "Grade Report" Click on "Download Spreadsheet [XLSX] " - The file is empty and a there is a NullPointerException in the log.

      Description

      There is a problem generating the xls file for the "Grade Report" when there are two or more assignments with more than 100 submissions in total.

      The problem is that the "SXSSFWorkbook" class has a default limit of 100 rows to maintain in memory. When it has 101 or more elements, it starts to flush the first elements, which are no longer accessible.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  adrianmticarum Adrian Martinez
                  Reporter:
                  adrianmticarum Adrian Martinez
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Git Source Code