Grouper Developers Forum

[Jim Fox <>]

I'm trying to delete a member from a group (using gsh, but get the same 
result from the API)

Note the ending line in the report: "// ERROR: cannot update a view"

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

gsh 0% s=GrouperSession.startRootSession()

gsh 1%  g=GroupFinder.findByName(s, "u:fox:browser6")
group: name='u:fox:browser6' displayName='uwnetid root:fox:Test group 6e' 
uuid='a1681c3fcba3f54f759e6c9432004381'

gsh 2% m1=MemberFinder.findByUuid(s, "46b520f6badb4b9dad0b8c4dc4ba1d8c", 
false)
member: id='8bc5cb1ad35311d78b049788b57938d5' type='person' source='uwpds' 
uuid='46b520f6badb4b9dad0b8c4dc4ba1d8c'

gsh 3% g.deleteMember(m1)

// Error: unable to evaluate command: Sourced file: inline evaluation of: 
``g.deleteMember(m1);'' : Method Invocation g.deleteMember
// See error log for full stacktrace
// caused by: 
edu.internet2.middleware.grouper.exception.MemberDeleteException:
// Problem in HibernateSession: HibernateSession: isNew: false, 
isReadonly: false, grouperTransactionType: READ_WRITE_NEW,
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.FindByGroupOwnerAndMemberAndFieldAndType, 
tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 
'owner'->'a1681c3fcba3f54f759e6c9432004381', Bind var[1]: 'Param (class 
java.lang.String): 'member'->'46b520f6badb4b9dad0b8c4dc4ba1d8c'Bind 
var[2]: 'Param (class java.lang.String): 
'fuuid'->'1879168ec99c410ea580e44707d14bad', , , group name: 
u:fox:browser6, subject: Subject id: 8bc5cb1ad35311d78b049788b57938d5, 
sourceId: uwpds, field: members,
Problem in HibernateSession: HibernateSession: isNew: true, isReadonly: 
false, grouperTransactionType: READ_WRITE_NEW
// caused by: 
edu.internet2.middleware.grouper.internal.dao.GrouperDAOException:
// Problem in HibernateSession: HibernateSession: isNew: false, 
isReadonly: false, grouperTransactionType: READ_WRITE_NEW,
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.FindByGroupOwnerAndMemberAndFieldAndType, 
tx type: null, tx type: nullBind var[0]: 'Param (class java.lang.String): 
'owner'->'a1681c3fcba3f54f759e6c9432004381', Bind var[1]: 'Param (class 
java.lang.String): 'member'->'46b520f6badb4b9dad0b8c4dc4ba1d8c'Bind 
var[2]: 'Param (class java.lang.String): 
'fuuid'->'1879168ec99c410ea580e44707d14bad',
// caused by: org.hibernate.exception.GenericJDBCException:
// could not update: 
[MembershipEntry#component[uuid,immediateMembershipId,groupSetId]{groupSetId=18de84d2450541ffaf5a5b97ac8aded7, 
immediateMembershipId=ff03cc3d98b14695a04cd7fb1d2e90c7, 
uuid=ff03cc3d98b14695a04cd7fb1d2e90c7:18de84d2450541ffaf5a5b97ac8aded7}]
// caused by: org.postgresql.util.PSQLException:
// ERROR: cannot update a view