Grouper Users - Open Discussion List

["Hyzer, Chris" <>]

This is fixed in 2.3.0 api patch #68

Please try it out and let us know.

https://bugs.internet2.edu/jira/browse/GRP-1565

Thanks
Chris

-----Original Message-----
From: Peter DiCamillo 
[mailto:]
 
Sent: Thursday, June 01, 2017 12:13 PM
To: Hyzer, Chris 
<>;
 

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: 
> 
>  
> [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
>
>