Details
-
Bug
-
Resolution: Unresolved
-
Minor
-
COmanage Registry 4.0.2 (Purple Jade MR2)
-
None
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.