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

Student matrices are sometimes stored multiple times in database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: CLOSED
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.8.1
    • Fix Version/s: None
    • Component/s: OSP: Wizards - Matrix
    • Labels:
      None
    • Environment:
      Oracle DB

      Description

      There are reported cases from IU and LOI where the student's matrix is stored multiple times in the database. Because the code assumes there is only one matrix the the database (it reads the database and uses the first record that is returned) there can be strange behavior for users when viewing the matrix. Sometimes the content of one record is shown, sometimes the content of another record.

      You can use the following query to identify if there are multiple matrix records in the DB:

      select worksiteid, scaffolding_id, owner, count
      from sakai.osp_matrix m
      inner join sakai.osp_scaffolding s on s.id = m.scaffolding_id
      group by worksiteid, scaffolding_id, owner
      having count > 1
      order by count DESC

      The resolution is to remove all duplicate records and then put a constraint on the OSP_MATRIX table to make sure there can be only one matrix per student:

      create unique index OSP_MATRIX_OWN_SCAFF_UK on OSP_MATRIX(OWNER, SCAFFOLDING_ID);

      It's not yet known why there are duplicate records stored in the DB or how to reproduce this behavior.

        Gliffy Diagrams

          Zeplin

            Attachments

              Activity

                People

                Assignee:
                Unassigned Unassigned
                Reporter:
                mbreuker Mark Breuker
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved:

                    Git Integration