Can't delete group due to dependency on grouper_sync_dep_group_group

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • 5.14.0, 4.17.0
    • Affects Version/s: 4.14.0
    • Component/s: None
    • None

      Can't delete a group that was provisioned, and has a field with provisioningGroupWrapper.thisGroupPrivilegeHolders('updaters', 'entityAttributeValueCache0'). It creates rows in grouper_sync_dep_group_group, which don't get cleaned up before deleting the group.

      Caused by: Error : 2292, Position : 0, SQL = delete from grouper_groups where id=:1 and hibernate_version_number=:2 , Original SQL = delete from grouper_groups where id=? and hibernate_version_number=?, Error Message = ORA-02292: integrity constraint (GROUPER.GROUPER_SYNC_DEP_GRP_GRP_FK_1) violated - child record found
      

      Deleting the rows manually from this table fixes it, and the group can now be deleted.

            Assignee:
            Chris Hyzer (upenn.edu)
            Reporter:
            Chad Redman
            Votes:
            2 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: