usdu will not remove memberships of unresolvables if the membership has a start or end date

----Original Message----
From: Peter DiCamillo
Sent: Thursday, June 01, 2017 12:13 PM
To: Hyzer, Chris ; grouper-users
Subject: Re: [grouper-users] Problem deleting unresolvable subject

There was one line of results with these values:

SUBJECT_ID 140050084
SUBJECT_SOURCE brown:LDAP
GROUP_NAME BROWN:SERVICES:NETWORK:IPTV:PREMIUM
LIST_NAME members
LIST_TYPE list
GROUP_ID 39f8a0a8cadc4e2e94d6402f516d084b
MEMBER_ID 441eca7650b248e992e10ad91fc9991c
I F
IMMEDIATE_MSHIP_ENABLED_TIME
IMMEDIATE_MSHIP_DISABLED_TIME 1.4391E+12

That makes sense to me, since that group had memberships that expired
earlier this week. I guess a USDU update is needed?

Peter

On 6/1/17 11:08 AM, Hyzer, Chris wrote:
> 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: grouper-users-request@internet2.edu grouper-users-request@internet2.edu On Behalf Of Peter DiCamillo
> Sent: Thursday, June 01, 2017 10:53 AM
> To: grouper-users@internet2.edu
> 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
>
>