Grouper Developers Forum

[Shilen Patel <>]

I'm trying to reproduce this on Postgres, but I'm not having much luck 
so far.  But it seems odd that you're getting a "cannot update a view" 
error on what appears to be a select statement.

If you run this directly on the database, what do you get back?

select membership0_.membership_id as membership1_23_0_, 
membership0_.immediate_membership_id as immediate2_23_0_, 
membership0_.group_set_id as group3_23_0_, member1_.id as id22_1_, 
membership0_.hibernate_version_number as hibernate4_23_0_, 
membership0_.owner_id as owner5_23_0_, membership0_.owner_attr_def_id as 
owner6_23_0_, membership0_.owner_group_id as owner7_23_0_, 
membership0_.owner_stem_id as owner8_23_0_, membership0_.member_id as 
member9_23_0_, membership0_.field_id as field10_23_0_, 
membership0_.immediate_field_id as immediate11_23_0_, 
membership0_.via_composite_id as via12_23_0_, 
membership0_.membership_creator_id as membership13_23_0_, 
membership0_.membership_create_time as membership14_23_0_, 
membership0_.group_set_creator_id as group15_23_0_, 
membership0_.group_set_create_time as group16_23_0_, 
membership0_.context_id as context17_23_0_, 
membership0_.group_set_parent_id as group18_23_0_, 
membership0_.via_group_id as via19_23_0_, membership0_.depth as 
depth23_0_, membership0_.mship_type as mship21_23_0_, 
membership0_.immediate_mship_enabled as immediate22_23_0_, 
membership0_.immediate_mship_enabled_time as immediate23_23_0_, 
membership0_.immediate_mship_disabled_time as immediate24_23_0_, 
member1_.hibernate_version_number as hibernate2_22_1_, 
member1_.subject_id as subject3_22_1_, member1_.subject_source as 
subject4_22_1_, member1_.subject_type as subject5_22_1_, 
member1_.context_id as context6_22_1_ from grouper_memberships_all_v 
membership0_, grouper_members member1_ where 
membership0_.owner_group_id='a1681c3fcba3f54f759e6c9432004381' and 
membership0_.member_id='46b520f6badb4b9dad0b8c4dc4ba1d8c' and 
membership0_.field_id='1879168ec99c410ea580e44707d14bad' and 
membership0_.member_id=member1_.id and membership0_.mship_type='immediate'

Can you also send the stack trace in grouper_error.log?

Thanks!

-- Shilen



On 6/30/10 3:57 PM, Jim Fox wrote:
> 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
>
>
>
>
>