Uploaded image for project: 'COmanage'
  1. COmanage
  2. CO-2556

SQL provisioner plugin - 'Reprovision All' breaks the sp_co_groups table.

    XMLWordPrintable

Details

    Description

      When using the SQL provisioner plugin (4.0.2 & develop)  Resync Reference Data populates the sp_co_groups table with all 5 records. Then I click 'Reprovision All' and the table gets wiped, and only a single record is re-added.

      The remaining sync is trying to write records to sp_co_group_members  without the corresponding group record existing in sp_co_groups , generating a violates foreign key constraint "sp_co_group_members_co_group_id_fkey error. I checked and of the 5 groups we have, only CO:members:active  gets a record in sp_co_groups .  Then it proceeds to try to bring in members for the other groups generating errors. This also causes the sync to take a long time as it's constantly handling errors.

      Attachments

        Activity

          People

            ioannis.e.igoumenos@at.internet2.edu Ioannis Eythymios Igoumenos (google.com)
            andrew.aschenbrener@at.internet2.edu Andrew Aschenbrener
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: