Grouper Developers Forum

[Jim Fox <>]

After upgrading my database to 1.6.0 I'm getting this on a 
GroupFinder.findByName API call:

-------------------------
  ERROR ByHqlStatic.list(366) - Exception in list: (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.memberUuid = m.uuid  and ms.enabledDb = 'T'', cacheable: false, cacheRegion: edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.FindAllByGroupOwnerAndMemberAndField, tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 'owner'->'b1b359c35174b82ec9d00b2b08d31a98'Bind var[1]: 'Param (class java.lang.String): 'member'->'b9d5a6f95baa42c690c887d5ba158b55', 
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException: Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: true, grouperTransactionType: READONLY_NEW
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession._internal_hibernateSessionCatch(HibernateSession.java:420)
        at 
edu.internet2.middleware.grouper.hibernate.HibernateSession.callbackHibernateSession(HibernateSession.java:506)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.list(ByHqlStatic.java:346)
        at 
edu.internet2.middleware.grouper.hibernate.ByHqlStatic.listSet(ByHqlStatic.java:392)
        at 
edu.internet2.middleware.grouper.internal.dao.hib3.Hib3MembershipDAO.findAllByGroupOwnerAndMember(Hib3MembershipDAO.java:1190)
        at 
edu.internet2.middleware.grouper.privs.GrouperNonDbAccessAdapter.getPrivs(GrouperNonDbAccessAdapter.java:180)
        at 
edu.internet2.middleware.grouper.privs.AccessWrapper.getPrivileges(AccessWrapper.java:98)
        at 
edu.internet2.middleware.grouper.privs.GrouperAllAccessResolver.getPrivileges(GrouperAllAccessResolver.java:78)
        at 
edu.internet2.middleware.grouper.privs.GrouperSystemAccessResolver.getPrivileges(GrouperSystemAccessResolver.java:83)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.getPrivileges(CachingAccessResolver.java:90)
        at 
edu.internet2.middleware.grouper.privs.CachingAccessResolver.hasPrivilege(CachingAccessResolver.java:149)
        at 
edu.internet2.middleware.grouper.privs.WheelAccessResolver.hasPrivilege(WheelAccessResolver.java:179)
        at 
edu.internet2.middleware.grouper.privs.ValidatingAccessResolver.hasPrivilege(ValidatingAccessResolver.java:100)
        at 
edu.internet2.middleware.grouper.privs.PrivilegeHelper.canView(PrivilegeHelper.java:317)
        at 
edu.internet2.middleware.grouper.GroupFinder.findByName(GroupFinder.java:238)
        at 
edu.internet2.middleware.grouper.GroupFinder.findByName(GroupFinder.java:198)
        at 
edu.washington.gws.group.grouper.GrouperGroupManager.getGwsGroupOrStemByStem(GrouperGroupManager.java:369)


and below it reports:

Caused by: org.postgresql.util.PSQLException: ERROR: column 
membership0_.owner_id does not exist
        at 
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
        at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
        ...
--------------------------------

I don't see any table or view named MembershipEntry.  Is that created 
dynamically?
Any ideas where I might look to see if the DB schema is complete?

Thansk

Jim