Grouper Users - Open Discussion List

[Peter DiCamillo <>]

Thanks, I tried the patch and it worked as expected. It deleted the 
membership with the expiration date.

Peter

On 6/11/17 10:22 PM, Hyzer, Chris wrote:
> 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