Uploaded image for project: 'COmanage Framework Migration'
  1. COmanage Framework Migration
  2. CFM-376

transmogrify fails to create COUs where parent ID is greater than current ID

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Blocker
    • None
    • None
    • None

    Description

      Transmogrification currently uses the code

      $insql = "SELECT * FROM " . $this->tables[$t]['source'] . " ORDER BY id ASC"; 

      to get the rows from the source table. The rows are ordered by id in ascending order and processed in that order.

      The problem is that for the cous table the parent_id column may have a value for a row with a much larger id. This can happen when an "old" COU is made the child of a "new" COU.

      The result currently is that any row (COU) where the parent id is greater than the id for the row being processed results in a foreign key constraint violation and the row (COU) is skipped.

      Besides missing COUs, this causes problems later when roles are processed since the COU doesn't exist in the new table.

      Attachments

        Issue Links

          Activity

            People

              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              scott.koranda@at.internet2.edu Scott Koranda (uwm.edu/illinois.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: