We have a custom plug-in that adds and removes members from the groups.
As we run this plug-in we are seeing following error
Caused by: Error : 1, Position : 0, Sql = insert into cwd_membership (parent_id, child_group_id, child_user_id, id) values (:1 , :2 , :3 , :4 ), OriginalSql = insert into cwd_membership (parent_id, child_group_id, child_user_id, id) values (?, ?, ?, ?), Error Msg = ORA-00001: unique constraint (CONFLNCE.CWD_UNIQUE_MEMBERSHIP) violated
What is the best way resolve this issue? Is there a way to clean up the table?