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

Error downloading the spreadsheet of the "Grade report"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Verified
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 12.3, 19.0
    • Fix Version/s: 12.4, 19.0
    • 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

          Zeplin

            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 Integration