Grouper Users - Open Discussion List

[Jim Fox <>]

( This is grouper 2.3 with patches to about #100 )

I am trying to delete a member from a field and getting an "Exception in 
uniqueResult:"

-------------------------------------------------------------
The call is (Group).deleteMember( (Member), (Field) )

[ Adds always work, it's just deletes that fail ]

SEVERE: Servlet.service() for servlet [gws] in context with path 
[/gws_grouper] threw exception [Request processing failed; nested exception 
is edu.internet2.middleware.grouper.exception.MemberDeleteException: Problem 
in HibernateSession: HibernateSession (72961acc): notNew, notReadonly, 
READ_WRITE_NEW, activeTransaction, session (531fd45e),
Exception in uniqueResult: (class [Ljava.lang.Object;), ByHqlStatic, query: 'select 
ms, m from MembershipEntry as ms, Member as m where       ms.ownerGroupId  = :owner    
        and  ms.memberUuid = :member           and  ms.fieldId = :fuuid and  
ms.memberUuid = m.uuid  and  ms.type  = 'immediate' ', cacheable: false, cacheRegion: 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO, tx type: null, 
tx type: nullBind var[0]: 'Param (class java.lang.String): 
'owner'->'881fef48f9e32bedf88b8fe5d96ed250', Bind var[1]: 'Param (class 
java.lang.String): 'member'->'737b30aff49747f480806371ca041e7d'Bind var[2]: 'Param 
(class java.lang.String): 'fuuid'->'0094f3965ca2419286d3c4c3c9a1fb4e', , , group 
name: u:fox:spud97, subject: Subject id: da74fce621d011d4abd00004ac494ffe, sourceId: 
uwpds, field: authorized-senders,
Problem in HibernateSession: HibernateSession (8dd69ee): new, notReadonly, 
READ_WRITE_NEW, notActiveTransaction, session (531fd45e)] 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:365)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.uniqueResult(ByHqlStatic.java:356)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findByGroupOwnerAndMemberAndFieldAndType(Hib3MembershipDAO.java:1537)
        at 
edu.internet2.middleware.grouper.Membership.internal_delImmediateMembership(Membership.java:1337)
        at edu.internet2.middleware.grouper.Group$9.callback(Group.java:2403)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:701)
        at 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2378)
        at 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2191)
        at 
edu.internet2.middleware.grouper.Group.deleteMember(Group.java:2225)
        at 
edu.washington.gws.group.grouper.GrouperGroupFactory.updateFieldMembers(GrouperGroupFactory.java:906)

--------------------------------------------------------------------------------
Everything in the query exists, and I've verified the member being deleted is 
a row of grouper_memberships for the field.

What's the not unique query looking for??

Thanks,

Jim