Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

Maybe there are disabled memberships?  Try running this for the user and see 
if there are any results.  USDU might need an update to delete disabled 
memberships too

SELECT DISTINCT gm.SUBJECT_ID,
                   gm.SUBJECT_SOURCE,
                   gg.name AS group_name,
                   gfl.NAME AS list_name,
                   gfl.TYPE AS list_type,
                   gg.ID AS GROUP_ID,
                   gm.ID AS member_id,
                   gms.IMMEDIATE_MSHIP_ENABLED,
                   gms.IMMEDIATE_MSHIP_ENABLED_TIME,
                   gms.IMMEDIATE_MSHIP_DISABLED_TIME
     FROM grouper_memberships_all_v gms,
          grouper_members gm,
          grouper_groups gg,
          grouper_fields gfl
    WHERE     gms.OWNER_GROUP_ID = gg.id
          AND gms.FIELD_ID = gfl.ID
          AND gms.MEMBER_ID = gm.ID
          AND gm.subject_id = ?


-----Original Message-----
From: 

 
[mailto:]
 On Behalf Of Peter DiCamillo
Sent: Thursday, June 01, 2017 10:53 AM
To: 

Subject: [grouper-users] Problem deleting unresolvable subject

We have an LDAP subject source, and due to the timing of our 
provisioning operations, sometimes subjects will be removed from LDAP 
before they can be removed from their groups. When this happens, they 
are listed in the Grouper report, and I run the Unresolvable Subject 
Deletion Utility (USDU) to delete them. Normally this works fine, and 
the list of unresolvable subjects goes back to being empty. However, I'm 
having a problem with one particular subject. I see this in the Grouper 
report:

----------------
UNRESOLVABLE SUBJECTS 1 of 1
----------------
brown:LDAP: 140050084

Then I run USDU with -source brown:LDAP and -delete, and get this:

member_uuid='441eca7650b248e992e10ad91fc9991c' 
subject='140050084'/'person'/'brown:LDAP' no_memberships

After that, the subject continues to show up in Grouper reports, and I 
also get the same result if I run USDU again. Is there a way I can get 
this subject to no longer show up as unresolvable? This is with Grouper 
2.3, with patches through last December.

Peter