Grouper Users - Open Discussion List

[Chris Hyzer <>]

More logs would be nice too.

That error says:

Exception in uniqueResult: (class edu.internet2.middleware.grouper.Member), 
ByHqlStatic, query: 'from Member as m where m.subjectIdDb = :sid    and  
m.subjectSourceIdDb = :source and m.subjectTypeId = :type'

Which looks like it might mean there are two or more rows in your 
grouper_members table with the same subject_id, source_id, and type.  I don't 
know how this is possible since I believe there should be a unique index on 
those cols.  Try running this query, and see if it returns any rows:

select gm1.SUBJECT_ID, gm2.SUBJECT_ID, gm1.SUBJECT_SOURCE, gm2.SUBJECT_SOURCE
from grouper_members gm1, grouper_members gm2
where gm1.SUBJECT_ID = gm2.SUBJECT_ID and gm1.ID != gm2.ID

And see if there is a unique index on that table for those 3 cols... 

If there is more in the logs then this might be the wrong path, but Gary 
asked me to look at the error message, so I did.  :)

Chris



> -----Original Message-----
> From: GW Brown, Information Systems and Computing
> [mailto:]
> Sent: Wednesday, March 18, 2009 3:31 PM
> To: Scott Koranda; 
> 
> Subject: Re: [grouper-users] UI error for subject previously in wheel
> group
> 
> Hi Scott,
> 
> You can send me the actual HTML and I'll take a look.
> 
> Does the problem persist if the ui webapp is restarted?
> 
> I had a quick go at removing someone from the wheel group but can't see
> any
> problems. May be Chris can see something in the error?
> 
> Gary
> 
> --On 18 March 2009 12:14 -0700 Scott Koranda
> <>
>  wrote:
> 
> > Hi,
> >
> > We are running the Grouper UI from 1.4.1.
> >
> > I had a subject that I had added to our
> > etc:sysadmingroup. That is our 'wheel' group, i.e. in
> > grouper.properties we have
> >
> > groups.wheel.use = true
> > groups.wheel.group = etc:sysadmingroup
> >
> > Later I removed that subject from that wheel group.
> >
> > Now when the user browses to the UI after a long
> > pause he sees only the words "My memberships" and
> > nothing else. I have the actual HTML delivered to the
> > browser and can post it if that would help.
> >
> > Note that this happens with whatever browser the user
> > uses. It is not browser related.
> >
> > The only suspicious thing I see in the logs is this:
> >
> > 2009-03-18 14:05:35,159: [TP-Processor6] ERROR
> > PrivilegeHelper.canViewMemberships(237) - canViewMemberships: Problem
> in
> > HibernateSession: HibernateSession: isNew: true, isReadonly: true,
> > grouperTransactionType: READONLY_NEW,
> > Exception in uniqueResult: (class
> edu.internet2.middleware.grouper.Memb
> > er), ByHqlStatic, query: 'from Member as m where m.subjectIdDb
> >    = :sid    and  m.subjectSourceIdDb = :source and
> >    m.subjectTypeId
> >    = :type', cacheable: true, cacheRegion:
> >    edu.internet2.middleware.groupe
> >    r.internal.dao.hib3.Hib3MemberDAO.FindBySubject,
> >    tx type: nullBind var[
> >    0]: 'Param (class java.lang.String):
> >    'sid'->'GrouperAll', Bind var[1]:
> >    'Param (class java.lang.String):
> >    'type'->'application'Bind var[2]: 'Par
> >    am (class java.lang.String): 'source'->'g:isa',
> >
> > Any ideas on how I can workaround this problem for
> > this user?
> >
> > All other users/subjects are having no problems
> > browsing the UI.
> >
> > Thanks,
> >
> > Scott
> 
> 
> 
> ----------------------
> GW Brown, Information Systems and Computing
>