Grouper Users - Open Discussion List

[Carl Waldbieser <>]

Shilen,

The group doesn't currently exist.
It did once exist.

The PIT info clued me in to what happened.  I had made some groups in my 
`test` stem for reporting on categories in that policy group.  The `test` 
groups included 2 component groups of a composite.  I had deleted one of the 
component groups without deleting the composite.  This caused the test 
composite to hang on to the "ghost" of its component.  Since that ghost had 
been a member of my policy group, I couldn't edit the policy group.  Once I 
deleted the broken composite, I could edit the policy group, again.

Thanks,
Carl Waldbieser
ITS Identity Management
Lafayette College

----- Original Message -----
From: "Shilen Patel" 
<>
To: "waldbiec" 
<>
Cc: "grouper-users" 
<>
Sent: Friday, June 8, 2018 7:41:17 AM
Subject: Re: [grouper-users] Grouper database error

A few quick things to check that may help narrow down the issue.  Does that 
group in the error actually exist?



select * from grouper_groups where id='7590c19720634ef29450af361b3312a5'



If not, did it exist before?



select * from grouper_pit_groups where 
source_id='7590c19720634ef29450af361b3312a5'

select * from grouper_members where 
subject_id='7590c19720634ef29450af361b3312a5'



If it does exist, does the user that’s making the membership change have read 
and/or view access to this group (again 7590c19720634ef29450af361b3312a5)?



Thanks!



- Shilen





On 6/7/18, 2:27 PM, 
"
 on behalf of Carl Waldbieser" 
<
 on behalf of 
>
 wrote:





    I'm getting an error in one of my groups.  When I try to add or remove a 
member, I get:



    Caused by: 
edu.internet2.middleware.grouper.exception.GroupNotFoundException: Cant find 
group by uuid: 7590c19720634ef29450af361b3312a5,

    Exception in save: edu.internet2.middleware.grouper.Membership, 
edu.internet2.middleware.grouper.hibernate.ByObject@778b6919,

    Problem in HibernateSession: HibernateSession (458ec25e): notNew, 
notReadonly, READ_WRITE_NEW, activeTransaction, session (61a1259f),

    Exception in save: edu.internet2.middleware.grouper.Membership, 
ByObjectStatic, query: ', cacheable: null, cacheRegion: null, entityName: 
ImmediateMembershipEntry, tx type: null

            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findByUuid(Hib3GroupDAO.java:1285)

            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findByUuid(Hib3GroupDAO.java:1253)

            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupDAO.findByUuid(Hib3GroupDAO.java:1244)

            at 
edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java:2249)

            at 
edu.internet2.middleware.grouper.Membership.fixComposites(Membership.java:2286)

            at 
edu.internet2.middleware.grouper.Membership.processPostMembershipSaveOrUpdate(Membership.java:2173)

            at 
edu.internet2.middleware.grouper.Membership.onPostSave(Membership.java:1997)

            at 
edu.internet2.middleware.grouper.hibernate.ByObject.save(ByObject.java:217)

            at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic$7.callback(ByObjectStatic.java:481)

            at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:687)

            at 
edu.internet2.middleware.grouper.hibernate.ByObjectStatic.save(ByObjectStatic.java:468)

            at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.save(Hib3MembershipDAO.java:2053)

            at 
edu.internet2.middleware.grouper.Membership.internal_addImmediateMembership(Membership.java:1246)

            at 
edu.internet2.middleware.grouper.Group$4.callback(Group.java:1392)



    Seems like it can't find a member group?



    It doesn't happen for every subject I add/remove to/from the group.  This 
group is used in a composite, and it seems like if the composite membership 
doesn't change overall, the change will take.  If the overall composite 
changes, the error occurs and the change won't happen.



    Thanks,

    Carl Waldbieser

    ITS Identity Management

    Lafayette College