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