Uploaded image for project: 'Grouper'
  1. Grouper
  2. GRP-1565

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.1, 2.4.0, 2.3.0.patch
    • Component/s: API
    • Labels:
      None

      Description

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

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
              Reporter:
              chris.hyzer@at.internet2.edu Chris Hyzer (upenn.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: