Grouper Users - Open Discussion List

[Shilen Patel <>]

Looks like you may have duplicates in your group set table.  I don't think bad membership finder catches that right now.  I can add it there, but you can verify by running this I think:

select owner_group_id, member_group_id, field_id from grouper_group_set where depth='0' and owner_group_id is not null and member_group_id is not null and field_id is not null group by owner_group_id, member_group_id, field_id having count(*) > 1

Thanks!

- Shilen

On 8/3/17, 6:13 PM, "Jim Fox" <> wrote:

This is experimenting with grouper api 2.3

I am trying to add a group as a field member (not membership).  I get an

exception: (sorry for the messay post)

I am able to add non-group subjects.

Something to do with group sets?

Jim

------------------------------------------------------

Aug 03, 2017 2:59:11 PM org.apache.catalina.core.StandardWrapperValve invoke

SEVERE: Servlet.service() for servlet [gws] in context with path [/gws_grouper] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession (6c4c2a54): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (5bd96f94),

Exception in uniqueResult: (class edu.internet2.middleware.grouper.group.GroupSet), ByHqlStatic, query: 'select gs from GroupSet as gs where gs.ownerGroupId = :id and memberGroupId = :id and fieldId = :field and depth='0'', cacheable: true, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupSetDAO.FindSelfGroup, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'id'->'881fef48f9e32bedf88b8fe5d96ed250'Bind var[1]: 'Param (class java.lang.String): 'field'->'0094f3965ca2419286d3c4c3c9a1fb4e', ,

Exception in save: edu.internet2.middleware.grouper.Membership, edu.internet2.middleware.grouper.hibernate.ByObject@44744e2e,

Problem in HibernateSession: HibernateSession (6e7b95d1): notNew, notReadonly, READ_WRITE_NEW, activeTransaction, session (5bd96f94),

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

, group name: u:fox:spud97, subject: Subject groupName: u:fox:spud97, sourceId: g:gsa, field: authorized-senders,

Problem in HibernateSession: HibernateSession (29610a0e): new, notReadonly, READ_WRITE_NEW, notActiveTransaction, session (5bd96f94)] with root cause

org.hibernate.NonUniqueResultException: query did not return a unique result: 2

         at org.hibernate.internal.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:971)

         at org.hibernate.internal.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:960)

         at edu.internet2.middleware.grouper.hibernate.ByHql.uniqueResult(ByHql.java:282)

         at edu.internet2.middleware.grouper.hibernate.ByHqlStatic$1.callback(ByHqlStatic.java:348)

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

         at edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:339)

         at edu.internet2.middleware.grouper.internal.dao.hib3.Hib3GroupSetDAO.findSelfGroup(Hib3GroupSetDAO.java:356)

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

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

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

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

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

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

         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)

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

         at edu.internet2.middleware.grouper.Group.internal_addMember(Group.java:1364)

         at edu.internet2.middleware.grouper.Group.addMember(Group.java:938)

         at edu.internet2.middleware.grouper.Group.addMember(Group.java:899)

         at edu.washington.gws.group.grouper.GrouperGroupFactory.updateFieldMembers(GrouperGroupFactory.java:848)

   ...